mysql Waiting for table level lock

转载来自：http://www.jianzhanseo.com/?p=470

1.We recently had a similar problem. Initially our key_buffer_size was set to 1GB. Increasing that to 10GB reduced the problem.

2. @Rick James, thank you. You saved me a lot of trouble today. Do you have a wish list in Amazon or somewhere else? :) I set up query_cache_limit to 1024. There is no lock problem now. I did it in variables at first from mysql client. set global query_cache_limit = 1024; Now I will write it to my.cnf. This solution got me the time to plan innodb migration without any stress so thank you