MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

alter table rebuild partition locks reads
Posted by: Chris C
Date: December 18, 2009 01:24AM

I'm performing an alter table rebuild partition on innodb database. (Using the innodb plugin.) Version 5.1.39 of mysql. Database is on EC2, EBS volumes. There's many tables of various size, all have the same issue. The table is range partitioned by date - each partition is one week. No writes occur during the rebuild, but queries still occur. Immediately after the rebuild starts, all queries hang. In processlist they show "Waiting for table". They didn't always do this. Just started. From what I've read - they should allow queries. Why would a query suddenly not be allowed? Innodb show status doesn't show much else. This is killing us right now - we can't rebuild at all. Is there anyway to diagnose this???

Thanks

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
alter table rebuild partition locks reads
5872
Chris C
December 18, 2009 01:24AM
Re: alter table rebuild partition locks reads
2842
Chris C
December 18, 2009 02:27AM
Re: alter table rebuild partition locks reads
2452
Rick James
December 19, 2009 09:22AM
Re: alter table rebuild partition locks reads
2472
Chris C
December 20, 2009 08:41PM
Re: alter table rebuild partition locks reads
2573
Chris C
December 21, 2009 03:04PM
Re: alter table rebuild partition locks reads
2374
Mattias Jonsson
December 22, 2009 02:37AM
Re: alter table rebuild partition locks reads
2381
Chris C
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.