I have a rather large MyISAM table (~230 million rows) running
under MySQL 3.23.30.  It has 10 columns and 3 indices.  The data
and index files each occupy about 10GB.

My problem is that sorting the rows using myisamchk --sort-records
takes an extremely long time.  The last sort took 95 hours (that's right...almost four 
days).

The machine is a four-processor Sun E450 with 4GB of memory.
The OS is Solaris 2.7.  The database files reside on a 12-disk
SCSI RAID 5 array.  The machine was essentially idle with the
exception of the sort job.

The previous time I ran myisamchk --sort-records, the table
had ~170 million rows, and it only took 12 hours.

The specific command I used in both cases was:
myisamchk -O sort_buffer_size=1024M -O key_buffer_size=1024M 
-O read_buffer_size=64M -O write_buffer_size=64M --sort-records=2

95 hours to sort and reindex 10 GB of data does not seem
reasonable.  Anyone have any idea what's going on here?

Thanks,
Michael


Reply via email to