Re: myisamchk sorting records descending
Posted by:
JJWR
Date: April 28, 2005 08:21AM
Thanks, but unfortunately
INSERT ... SELECT FROM first table ORDER BY column
is incredible slow. The table has more than 5 million of records and this can take days to comlete and mysql is unusable during this time, and I would like to do a resorting each few days.
It would be nice a tool like myisamchk to sort the rows descending (sorting ascending goes very well and it can be done in less than 1 hour for the same table and in a separate process with lower priority than mysql) or a way to perform a 'select' retrieving the rows starting by the end of the table.
Subject
Views
Written By
Posted
7390
April 12, 2005 01:19AM
3429
April 25, 2005 02:44AM
3529
April 26, 2005 12:50AM
3277
April 27, 2005 01:12AM
4709
May 18, 2005 02:19AM
4579
May 19, 2005 01:03AM
3164
May 19, 2005 02:22AM
Re: myisamchk sorting records descending
3158
April 28, 2005 08:21AM
3039
May 04, 2005 05:24PM
3738
May 09, 2005 10:25AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.