MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Consumption of more hard disk space in "Copying to tmp table" phase
3789
Raghavendra K
April 14, 2014 01:07AM
Re: Consumption of more hard disk space in "Copying to tmp table" phase
1490
Mattias Jonsson
April 14, 2014 05:05PM
Re: Consumption of more hard disk space in "Copying to tmp table" phase
1425
Raghavendra K
April 16, 2014 06:40AM
Re: Consumption of more hard disk space in "Copying to tmp table" phase
1448
Mattias Jonsson
April 17, 2014 12:55PM
Re: Consumption of more hard disk space in "Copying to tmp table" phase
1468
Rick James
April 17, 2014 11:36PM


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.