Mysql table hanging

Mysql table hanging

Posted by: Wizal
Posted on: 2008-04-26 22:37:00

Earlier today I tried to add a simple secondary index to a table and since then everytime I try to access it it hangs forever: I can't repair it, optimize it, analyze it or of course dump it. The table has about 90,000 entries and only 4 simple short fields. Nothing works: whatever I do with this table, be it through PHPmyAdmin or in command line, it just hangs until timeout. The rest of the mysql5 database works fine. What can I do to fix this mess?


Re: Mysql table hanging

Posted by: patricktan
Posted on: 2008-04-27 00:55:00

In reply to:

be it through PHPmyAdmin or in command line, it just hangs until timeout.

I think it takes too long to add an index to 90,000 entries. You may want to contact DH support and ask them to use root user to add the index for you.

In reply to:

What can I do to fix this mess?

have you tried to roll back to a back up one?

Tags: nothing worksphpmyadminnothing worksphpmyadmin