Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

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 ?

share|improve this question
It sounds like you're being impatient more than anything else. What does SHOW FULL PROCESSLIST show when such a hang is occurring? – Phil May 25 '12 at 13:39
Question: When you drop a database, are there any foreign key constraints among the InnoDB tables? Are those tables with FK constraints big? – RolandoMySQLDBA May 25 '12 at 15:22
Another question: Are using innodb_file_per_table ??? – RolandoMySQLDBA May 25 '12 at 15:26
innodb_file_per_table is OFF – Eric May 31 '12 at 12:46
The tables are created by django framework, I guess there may be some constraints : is there a problem with that ? – Eric May 31 '12 at 12:47

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.