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
Is there anyway to get additional information about a query that is currently
running? I've got some performance problems I'm trying to analyze while
loading large data sets and I'm running a test query, but I don't have any
idea how far the query has progressed.
The test query is a