MySQL Index Ongoing, More Than 12 Hours!
Posted on 2011-10-08
I'm creating an index on a MySQL table with 25,000,000 rows.
The index is on 4 columns which are all VARCHAR(45), average being around 5 characters.
I started this 12 hours ago and it's still running, it's using 14/16 of the server load, around 10% of the RAM. The server is dual quad core 3Ghz, 12GB RAM.
I can't login to SSH to check on progress of anything because of the high load. Basically I'm locked out of the server while it's doing its processing and I have no idea how long it's going to last.
Is it supposed to take this long? Anything I can do to check on progress and/or speed it up?
EDIT: I managed to check running processes through WHM and it's currently on "Repair with keycache". Is that near the beginning or the end?