I've been looking everywhere for an answer to this, so please excuse me if it should have been obvious.
I have a very big MySQL server, under load, serving in the 1500 QPS range. Under times of high concurrenncy (many threads connected issuing queries), I start to see a lot of the threads with "NULL" as their state (rather then Sending data, sorting, etc). These threads seem to be blocked for some reason, as they eventually do get executed.
Am I running into a locking issue?
MySQL seems like it -should- scale to 12 CPU's... so I must be missing something.
Up until this point, it's just grown and grown along with us (using InnoDB table system), so I'm hoping to continue. :)
Thanks in advance,
Dylan
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
