Your key_buffer_size and sort_buffer_size configuration variables play
a role in the speed of your indexes, including creation and
modification. If these are set low, creating an index can be pretty
slow. 43 minutes seems like and extremely long time to create an index
on only 160K records. It
Hi,
I don't know what is wrong with running indexing on this table. It have
been last for nearly 3 hours.
here is the command I run at the prompt of mysql> :
alter table inventory add index(basename);
Because it is running indexing, all operation seems hang up.
As far as I can remember I only inj
