Hello.
If you're using an InnoDB tables you could monitor the progress with SHOW INNODB STATUS using the number of proceeded rows. See: http://dev.mysql.com/doc/mysql/en/innodb-monitor.html Mike Muratet <[EMAIL PROTECTED]> wrote: > Greetings > > I have a query that has been running for days on a otherwise unused mysql > server. It's running on a reasonbly stout machine (dual Pentium III with > 1GB of memory) and I tuned the server for big jobs. It's meeting all of > the metrics in the documentation for a well-tuned system as near as I can > tell. Is there some way I can compare the output from the 'explain' of the > query with the output of 'show status' to estimate how far along the query > is? There have been no other queries processed so that everything in the > status variables is a result of this query. > > Thanks > > Mike > > -- 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]