James,
----- Original Message ----- From: "James Green" <[EMAIL PROTECTED]>
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/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
