Hi,
Currently, I have a situation where an app makes connections (via JDBC) to a mysql server, 50 connections at once, and everything just becomes super-slow. For instance, a SELECT that should take 0.01 sec takes several minutes. SHOW PROCESSLIST says that these threads that are connections from the app are in a state "Locked". The mysql manual doesn't explain this option, or even list it as a possibility (maybe I'm looking at the wrong place: http://dev.mysql.com/doc/mysql/en/SHOW_PROCESSLIST.html)
The other question is what one can do about this, to prevent this locking, or even diagnose it.
Thanks for your help.
Jim
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
