MySQL Forums
Forum List  »  Partitioning

Re: Consumption of more hard disk space in "Copying to tmp table" phase
Posted by: Mattias Jonsson
Date: April 17, 2014 12:55PM

Hi,

By using EXPLAIN PARTITIONS SELECT... you will also get which partitions that will be used after pruning the WHERE clause (during join, dynamic pruning will be used which depend on the table contents, which will not be reflected in the EXPLAIN).

The ORDER BY will be done on the final result, through an internal temporary table. Unless it can reuse the sorting order from an used index.

Also notice that 5.5.10 is pretty old, I would suggest you to try a more recent 5.5 or even 5.6 :)

Regards
Mattias

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Consumption of more hard disk space in "Copying to tmp table" phase
1499
April 17, 2014 12:55PM


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.