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 Greg Fortune <[EMAIL PROTECTED]> wrote: > 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 count(some_field) with the JOINs that I need and I'd like > to know how many rows it has counted or how many rows it has visited from > each table, etc, etc, etc. I know ahead of time that the result should be > about 2.6 million and am just trying to get timing data. > > Is there any way to get at this kind of info? > > Greg > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
