[SOLVED] After add index to MySQL table the table did not open


I have this table

id     name image
1      aa   x.png
2      bb   cc.png
102145 fgf  rrr.png

The table have more than 102K rows.

After add index to name the process hanged then could not open the table and even can not select from it any row.

How can I solve this issue.


The issue is fixed by restarting mysql server.

Answered By – Ayman Hussein

Answer Checked By – Pedro (BugsFixing Volunteer)

Leave a Reply

Your email address will not be published. Required fields are marked *