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
Or try my own tool mymonitor. Available on sourceforge at
https://sourceforge.net/projects/mymonitor
It's still in beta, but works OK. Still work in progress, and features
will be added, but in your situation, I think it could be useful.
Best regards
Anders Karlsson
Duncan Hill wrote:
On Tuesd
Hi,
Maybe you can use --log-slow-queries.
http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
Gu Lei
- Original Message -
From: "Peter Van Dijck" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, June 20, 2006 3:49 PM
Subject: finding the slow query
> Hi,
> I have some troubles finding t
On Tuesday 20 June 2006 08:49, Peter Van Dijck wrote:
> 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.
http://www.google.co.uk/searc
