Thanks guys,
Actaully my Hard disk is 10G, just for one table. There is enough table
space. I noticed when I created index for 1.9G table, at the first phase,
mysql copy table, but mysql doesn't write to the tmp index file, I means the
filesize of the tmp index didn't increase. When I create in
Hello MySQL,
I have a MYISAM table, which is about 2.2G and 19,000,000 records. When I
create indexs for it, I couldn't finish after 4 hours. But when I reduce the
records to 16,000,000, about 1.9G, the same index can be finished within 35
minutes. Can anyone explain it? Thanks in advance.
I a
