- Original Message -
From: "Bernd Jagla" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 03, 2003 1:14 PM
Subject: Re: sort-records
> Yup, I guess I set parameters too high...
>
> Thanks
>
> Bernd
>
> - Original Mes
Hi there,
I wanted to sort the records in one of my tables (205,000,000 entries) to test if this
will give me any speed increase.
It is an MyISAM table, and was trying to use myisamchk -R 2 user.
But what I get in return is a core dump and that the index file is not working
anymore...
I am usin
gt;
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, May 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
ns 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).
> >
> >
- mirrored on drives 0 & 1
Data - RAID 5 array on drives 2, 6, 10, 14, 18
Data - RAID 5 array on drives 3, 7, 11, 15, 19
Indexes - Mirrored drives 4 & 12, 8 & 16 (note: each 'half' of the
mirror is located on a different SCSI 'card' as well as 'path'
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 10 columns and 3 indices. The data and index
> files each occupy about 10GB.
>
> My problem is that sorting the rows using m
ing 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
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
