I am running Ver 8.8 Distrib 3.23.22-Beta on RedHat Linux. I have two
databases, foo and bar.
Below I show the output of mysqladmin processlist. Pid 5 is executing a
long-running select from the event table of
db foo. Pid 1 (started after pid 5) is attempting an insert in the same
event table. It makes sense that this would block
and it does.
Now, Pid 6, started after both 1 and 5, is executing an insert in the Sensor
table of the other db, bar. I don''t see why
this should block, but it does! Is this a feature of MySql or does it have
to do with the thread package on linux, perhaps?
BTW, is there a way to speed up a select with distinct keyword? There is a
temporary file in /tmp that is being
actively accessed. I am guessing that this is the temporary table being
creatd by pid 5. Correct?
Thanks for your attention,
Bob
+----+--------+-----------+-----------+---------+------+--------------------
--+-------------------------------------------------------------------------
-------
| Id | User | Host | db | Command | Time | State
| Info
+----+--------+-----------+-----------+---------+------+--------------------
--+-------------------------------------------------------------------------
-------
| 1 | snorty | localhost | foo | Query | 6156 | update |
INSERT INTO event (sid,cid,signature,timestamp) VALUES ('1', '253550',
'<137.219.43.24;984619820.161 |
| 4 | root | localhost | | Query | 0 |
| show processlist
| 5 | root | localhost | foo | Query | 6535 | Copying to tmp table
| select distinctrow signature from event
| 6 | root | localhost | bar | Query | 5076 | update
| insert INTO Sensor VALUES ('SensorTwo','Second Test Sensor','Bishop')
|
| 9 | root | localhost | foo | Sleep | 665 |
|
+----+--------+-----------+-----------+---------+------+--------------------
--+-------------------------------------------------------------------------
-------
----------------------+
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
