List:General Discussion« Previous MessageNext Message »
From:Basil Daoust Date:March 4 2014 7:32pm
Subject:Waiting for table metadata lock
View as plain text  
InnoDB question

So I have a rename table command that sometimes locks up with the waiting
We have tried a few things, and nothing has worked well yet.
So I was wondering is their a method in reducing the time this lock last
Can I change any MySQL settings, increase space, get faster drives, more
memory, anything?

Waiting for table metadata lock
RENAME TABLE A to A_old, A_temp to A

Waiting for table metadata lockBasil Daoust4 Mar