James,
----- Original Message ----- From: "James Green" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, April 05, 2005 11:06 AM
Subject: Re: Innodb: Alter table progress
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).
I assume that you also have innodb_log_file_size configured as recommended? http://dev.mysql.com/doc/mysql/en/innodb-configuration.html
If the ALTER is still running in October 2005, this TODO item will come to your rescue:
http://www.innodb.com/todo.php
"
Fast index creation in CREATE INDEX statement. You can load big tables quickly to a table with no indexes, and afterwards create the indexes efficiently. Appears in 5.1.
"
-- 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]
