2

I had a crash on a machine and rebooted and restarted mysql. Mysql loaded fine, I can connect with 'mysql -p' and do simple commands like "show tables;". However, real DB operations (e.g., "select [...]") just hang. Is there any idea on what is going on?

Improve this question
4
  • What is your server load? Is it slow? You can check top and uptime.
    – Khaled
    Jan 20, 2011 at 16:02
  • low. mysql is running at about 11%. load average: 2.11, 2.08, 1.99
    – muckabout
    Jan 20, 2011 at 16:12
  • 1
    That's not that low...
    – Josh
    Jan 20, 2011 at 21:00
  • Are any tables showing as locked? Do your DB ops use locking (e.g., in an app you might be testing)?
    – Paul
    Aug 8, 2011 at 4:21

2 Answers 2

Reset to default
1

Try:

mysqlcheck -u root -pPASSWORD -A --check
mysqlcheck -u root -pPASSWORD -A --auto-repair
mysqlcheck -u root -pPASSWORD -A --optimize
Improve this answer
0

MySQL runs check db operations when it boots up, and these make a lock on the dbs. Try this:

show processlist;

If a check process is currently running, you'll just have to wait it out.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .