If you do a SHOW PROCESSLIST list, you might see some queries with a state of "Locked" or
"Sending Data".
The sending data query may be the one that is causing all the others to wait. You would see these state a lot more on MyISAM tables
than InnoDB.
----- Original Message -----
From: "Peter Van Dijck" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Tuesday, June 20, 2006 3:49 AM
Subject: finding the slow query
Hi,
I have some troubles finding the slowest queries.
My server has regular high loads when a lot of queries that hit the
same tables slow down. The question is, which query is slowing it
down? The others are probably just slow because the whole thing is
slow.
And a related question: what's a good strategy to figure out if table
locking is causing queries to be slow?
Thanks for any pointers,
Peter
--
find videoblogs: http://mefeedia.com
my blog: http://poorbuthappy.com/ease/
my job: http://petervandijck.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
