MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: (non-unique) index more efficient than partition pruning
Posted by: Rick James
Date: November 19, 2014 06:01PM

Here's some of what we have have discussed, plus more. In particular it includes the two SQLs that I promised you a few days ago.
http://mysql.rjweb.org/doc.php/staging_table
Please review it and let me know of any typos, goofs, missing things, wrong statements, whatever.

Was that partition pruning issue with MariaDB 5.2? There may have been improvements since then.

> partitions = idx0,idx2

That is an issue with 'bad' dates mapping to the 'first' partition. Hence it is better to have the first partition empty (bogus).

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


Subject
Views
Written By
Posted
large InnoDB table partitioning without explicit PK
4601
Miko M
November 12, 2014 07:41PM
Re: large InnoDB table partitioning without explicit PK
2335
Rick James
November 13, 2014 06:40PM
Re: large InnoDB table partitioning without explicit PK
2117
Miko M
November 14, 2014 03:02AM
Re: large InnoDB table partitioning without explicit PK
1631
Rick James
November 15, 2014 12:05AM
Re: large InnoDB table partitioning without explicit PK
1665
Miko M
November 16, 2014 07:39PM
Re: large InnoDB table partitioning without explicit PK
1617
Rick James
November 17, 2014 04:21PM
Re: large InnoDB table partitioning without explicit PK
1706
Rick James
November 17, 2014 07:48PM
Re: large InnoDB table partitioning without explicit PK
1675
Miko M
November 18, 2014 02:00AM
Re: large InnoDB table partitioning without explicit PK
1749
Rick James
November 18, 2014 11:35PM
Re: large InnoDB table partitioning without explicit PK
1730
Miko M
November 22, 2014 06:44AM
Re: large InnoDB table partitioning without explicit PK
1610
Miko M
November 18, 2014 01:13AM
(non-unique) index more efficient than partition pruning
2042
Miko M
November 19, 2014 12:27AM
Re: (non-unique) index more efficient than partition pruning
1754
Rick James
November 19, 2014 06:01PM
Re: (non-unique) index more efficient than partition pruning
1968
Miko M
November 22, 2014 08:39AM
Re: large InnoDB table partitioning without explicit PK
1899
Miko M
November 14, 2014 03:04AM
Re: large InnoDB table partitioning without explicit PK
1941
Miko M
November 14, 2014 03:05AM
Re: large InnoDB table partitioning without explicit PK
1954
Rick James
November 15, 2014 12:32AM
Re: large InnoDB table partitioning without explicit PK
1965
Miko M
November 16, 2014 08:31PM
Re: large InnoDB table partitioning without explicit PK
1753
Rick James
November 19, 2014 12:12AM
Re: large InnoDB table partitioning without explicit PK
1661
Miko M
November 22, 2014 09:07AM
Re: large InnoDB table partitioning without explicit PK
1672
Rick James
November 23, 2014 09:00PM
Re: large InnoDB table partitioning without explicit PK
1842
Miko M
December 01, 2014 11:16AM


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.