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

Issue

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.

Solution

The issue is fixed by restarting mysql server.

Answered By – Ayman Hussein

Answer Checked By – Pedro (BugsFixing Volunteer)