Hi!
>>>>> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello mysql,
Peter> I was trying to load very huge (5GB 45mil rows) to the text dump in
Peter> sorted order (according to primary key).
Peter> The problem is mysql somehow does not wants to scan the table by
Peter> primary key to produce sorted output row by row, but prefers to use
Peter> filesort which would take quite a long time in this case:
mysql> explain select * from dominf.domip order by ip desc;
If you do a full sort of the table, it will actually be faster to use
a filesort than using an index (This is because how MySQL caches rows
when it does the sort).
In MySQL 3.23.41 you can speed up filesort a lot by increasing the value
of record_rnd_buffer
Regards,
Monty
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
