From: Date: July 5 2003 3:03pm
Subject: The difference between 1.9G and 2.2G table when create Index
List-Archive: http://lists.mysql.com/mysql/144460
Message-Id: <Law11-F114r5XsCj1d4000127c1@hotmail.com>
MIME-Version: 1.0
Content-Type: text/plain; format=flowed

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