Heikki,
See inline.
Heikki Tuuri wrote:
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:
Progress indicators, and perhaps an estimated time for completion prior to operation would be extremely useful.
"
Number of rows inserted 3738558, updated 127415, deleted 33707, read 755779
"
That number is, of course, cluttered by other workload that you have.
Not good. Table has 85m records:
Number of rows inserted 36157507, updated 5060, deleted 151059, read 3764704970
So at most 36m records processed. Query so far been running 1wk; with innodb_buffer_pool_size=900M set.
Looks like another two weeks to go! Not exactly on a slow machine either (dual xeon lots of ram).
-- James Green Systems Administrator, StealthNET Ltd, www.stealthnet.co.uk Tel: 0870 800 1777 Intl: +44 1493 660066 Fax: 0870 135 1069
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
