John,
Marko will add a commit at every 10 000 rows to CREATE INDEX in 4.1.11. Then this kind of a runaway rollback can not happen any more.
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
------------------------------------------
Save the Pacific Northwest Tree Octopus! |
http://zapatopi.net/treeoctopus.html |
------------------------------------------
----- Original Message ----- From: ""Heikki Tuuri"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Sunday, February 27, 2005 12:33 AM
Subject: Re: InnoDB Rollback - 162 hrs remaining!?
John,
----- Original Message ----- From: "John Taylor" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 26, 2005 11:37 PM
Subject: Re: InnoDB Rollback - 162 hrs remaining!?
Thanks for the quick response. I note within the database directory a #sql- file but it has not been modified for two days, around the time the index was begun.
that is probably the .frm file for the temp table you need to DROP.
Does this have a bearing on matters? Last thing we need is to kill mysqld processes and find the innodb data file is corrupt beyond repair.
I almost always shut down InnoDB with
killall -9 mysqld
It never gets corrupt.
Unfortunately the server.err file is not giving me any output, nor .log and I don't have a .status file either.
Thanks,
John.
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
--
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]
