John,
----- Original Message ----- From: "John Taylor" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 26, 2005 6:54 PM
Subject: InnoDB Rollback - 162 hrs remaining!?
Hi,
We have a large InnoDB table to which we recently added an index. That index creation thread was issued a kill yesterday due to length of time, unfortunately according to 'show innodb status' the rollback is now 162 hrs away from completion (1 every 5 secs).
We are not using per-table tablespaces. MySQL version is 4.1.9, server is 2x Xeon hyperthreading, 2Gb ram.
1. Can we safely kill the Linux PID of the thread doing this? What is the risk to the data?
you can safely kill mysqld.
Here you find advice how to DROP the temporary table the rollback is running on:
http://dev.mysql.com/doc/mysql/en/innodb-troubleshooting-datadict.html
http://dev.mysql.com/doc/mysql/en/forcing-recovery.html
2. We note the server has many default settings, looks like for a 256MB machine. Can we adjust some of those mentioned in the manual for performance tuning and see a hopefully positive effect on the time?
http://dev.mysql.com/doc/mysql/en/innodb-configuration.html
Many 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]