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
5871
December 18, 2009 01:24AM
2842
December 18, 2009 02:27AM
2451
December 19, 2009 09:22AM
Re: alter table rebuild partition locks reads
2471
December 20, 2009 08:41PM
2572
December 21, 2009 03:04PM
2372
December 22, 2009 02:37AM
2381
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.