- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
On Wed, May 30, 2001 at 11:32:16PM -0400, Michael Villalba wrote:
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
31, 2001 12:38 PM
Subject: Re: myisamchk --sort-records extremely slow
Perhaps the physical layout of your disk drives are contributing to the
'slowness'...
- Are the 12 drives making up the SCSI RAID 5 array the only drives in the
system ?
- Do you have the O/S and/or the 'temp' area being
On Wed, May 30, 2001 at 11:32:16PM -0400, Michael Villalba wrote:
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
)
Temp - Mirrored drives 5 13
- Original Message -
Sent: Thursday, May 31, 2001 8:55 AM
Subject: Re: myisamchk --sort-records extremely slow
In the last episode (May 30), Michael Villalba said:
I have a rather large MyISAM table (~230 million rows) running under
MySQL 3.23.30. It has
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