I am using Mysql 5.5 from ubuntu 12.04 64 Bits with both MyIsam and Innodb engines : From time to time, when I do some 'big' requests like dropping a database, altering a table, adding an index on a big table, dumping or restoring a whole database, the request is 'hanging' : usually, I run these requests from phpmyadmin or on the command line : both of them does not give the hand when the problem accurs.
I can use 'mytop' to see mysql process list : I can see the request, but it never finishes. It looks like there is a lock somewhere that is never released...
The only way I found to solve this is to restart mysql. :
I did not have this issue with Mysql 5.1 :
Do you know how can I solve that ?