On Thu, 7 Apr 2005, Gleb Paharenko wrote:
> 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 > > Thanks. I'll give it a shot. Mike > > > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
