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?
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.
have you tried to roll back to a back up one?