List:General Discussion« Previous MessageNext Message »
From:James Yang Date:July 5 2003 1:03pm
Subject:The difference between 1.9G and 2.2G table when create Index
View as plain text  
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 am using PIII 550, RedHat 8.0, with 1G Memory and IDE Hard Disk.The 
database is stored at "ext3" file system. When I use "show processlist" for 
the 2.2G indexs, it tell me "Copying to tmp table".

James

James@stripped

_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail
Thread
• The difference between 1.9G and 2.2G table when create IndexJames Yang5 Jul
  • Re: The difference between 1.9G and 2.2G table when create IndexFred van Engen5 Jul
    • Re: The difference between 1.9G and 2.2G table when create IndexFred van Engen5 Jul
• Re: The difference between 1.9G and 2.2G table when create IndexJames Yang6 Jul