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
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.
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: mysql@lists.mysql.com
Sent: Tuesday, June 20, 2006 3:49 PM
Subject: finding the slow query
Hi,
I have some
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
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