Hi,
Can someone explain this?
| 13 | XX | chrome | XX | Query | 1 | Locked | SELECT name FROM users WHERE uid=288950
||
| 376 | XX | chrome | XX | Query | 1 | Sending data | SELECT uid FROM users WHERE name
|like '%Fuzzster' limit 1 |
| 397 | XX | chrome | XX | Query | 1 | Locked | SELECT uid,flags,aseclev, ... etc
| 479 | XX | blue-private | XX | Query | 0 | NULL | show processlist |
| 542 | XX | chrome | XX | Query | 1 | Locked | update users set
|lllogin=llogin,visits=visits+1,llogin=NOW() where uid=333705 |
I removed all the sleeping processes from the processlist
* connection #397 is 'sending data' from a select. Fine.
* connection #542 (an update) is "Locked" on that. Fine.
* But ... why is connection #13 (another select) locked???
And .. other examples show any other new selects also lock
when there that or other pending locked updates are waiting...
at least this is my interpretation..
-Justin
---------------------------------------------------------------------
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
