Anil
-Original Message-
From: Greg Fortune [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 22, 2004 1:34 AM
To: mysql@lists.mysql.com
Subject: Re: Need more info about currently running queries
Yep, mysqladmin can give the same info. As noted in my original message, I
need much
Hello.
Using SHOW PROCESSLIST you can just check if your query running, or
is waiting for some lock. For more info, you can run ps axm in shell
and look for the thread state, but that's more related to the kernel stuff.
See:
http://dev.mysql.com/doc/mysql/en/SHOW_PROCESSLIST.html
Yep, mysqladmin can give the same info. As noted in my original message, I
need much more detailed info.
The crux of the problem is that I need to run a query that could take several
hours when it's using indexes correctly, but it is not working correctly so
it takes longer than I've been