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.
Subject
Views
Written By
Posted
5859
December 18, 2009 01:24AM
2837
December 18, 2009 02:27AM
2446
December 19, 2009 09:22AM
Re: alter table rebuild partition locks reads
2465
December 20, 2009 08:41PM
2569
December 21, 2009 03:04PM
2369
December 22, 2009 02:37AM
2375
December 22, 2009 10:17AM
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.