James,
----- Original Message -----
From: "James Green" <james.green@stripped>
Newsgroups: mailing.database.myodbc
Sent: Monday, April 04, 2005 1:28 PM
Subject: Innodb: Alter table progress
> Hi,
>
> Is there any way of checking the progress of an "ALTER TABLE" query on
> an InnoDB table? "show innodb status" isn't clear.
hmm... in the newest versions of MySQL there is no way, except by monitoring
the number of inserted rows in SHOW INNODB STATUS:
"
Number of rows inserted 3738558, updated 127415, deleted 33707, read 755779
"
That number is, of course, cluttered by other workload that you have.
> Thanks,
>
> --
> James Green
> Systems Administrator, StealthNET Ltd, www.stealthnet.co.uk
> Tel: 0870 800 1777 Intl: +44 1493 660066 Fax: 0870 135 1069
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL Network from http://www.mysql.com/network/
