InnoDB question So I have a rename table command that sometimes locks up with the waiting message. 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 for? 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
