MySQL Forums
Forum List  »  Partitioning

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

Hi,

Hard to say without more information. Is it still creating temp tables if you remove the ORDER BY?

Can you add 'EXPLAIN PARTITIONS SELECT ...' and if on 5.6 also an optimizer trace for the query, then it will be easier to see how the optimizer came up with the plan. See more about it in the manual, but typically it is http://dev.mysql.com/doc/internals/en/optimizer-tracing-typical-usage.html

Regards
Mattias, MySQL Partitioning developer

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Consumption of more hard disk space in "Copying to tmp table" phase
1230
April 14, 2014 05:05PM


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.