MySQL Forums
Forum List  »  Partitioning

Re: alter table rebuild partition locks reads
Posted by: Chris C
Date: December 20, 2009 08:41PM

Like I said - trying to do an:

alter table <table_name> rebuild partition <partition_name>;

Version is 5.1.39 and the Innodb version is 1.0.4...

mysql> SELECT @@innodb_version;
+------------------+
| @@innodb_version |
+------------------+
| 1.0.4-7 |
+------------------+
1 row in set (0.00 sec)

I know they have 1.0.6 out now, so we can try with that. What's odd is - this *WAS* working fine. We have been rebuilding tables for at least a month. Suddenly it's locking queries out on all databases. No upgrades or installs have occurred, so we're puzzled what has changed.

Options: ReplyQuote


Subject
Views
Written By
Posted
5859
December 18, 2009 01:24AM
Re: alter table rebuild partition locks reads
2465
December 20, 2009 08:41PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.