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