MySQL :: Re: No other way than delete primary key to create partitions by single datetime columns?

New Topic

Re: No other way than delete primary key to create partitions by single datetime columns?

Posted by: Rick James
Date: August 22, 2015 03:35PM

Did you consider adding this, instead of PARTITIONing?

INDEX(createDate)

What query is 'slow'? Maybe some other index would be even better. For example, if you have

WHERE col3 = 123 AND createDate BETWEEN ... AND ...

then this would be optimal (and _better_ than partitioning):

INDEX(col3, createDate)

I'm not saying that PARTITION is _useless_; I am saying that you have not presented a case where it is _more useful_ than some index.

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

No other way than delete primary key to create partitions by single datetime columns?

2612

Sam Young

August 20, 2015 08:00PM

Re: No other way than delete primary key to create partitions by single datetime columns?

1631

Jonathan Stephens

August 21, 2015 02:53AM

Re: No other way than delete primary key to create partitions by single datetime columns?

1497

Sam Young

August 23, 2015 08:57PM

Re: No other way than delete primary key to create partitions by single datetime columns?

1528

Rick James

August 22, 2015 03:35PM

Re: No other way than delete primary key to create partitions by single datetime columns?

1483

Sam Young

August 23, 2015 09:23PM

Re: No other way than delete primary key to create partitions by single datetime columns?

1527

Rick James

August 24, 2015 12:36PM

Re: No other way than delete primary key to create partitions by single datetime columns?

1597

Sam Young

August 26, 2015 12:53AM

Re: No other way than delete primary key to create partitions by single datetime columns?

1505

Rick James

August 26, 2015 10:02AM

Re: No other way than delete primary key to create partitions by single datetime columns?

1467

Sam Young

August 26, 2015 07:42PM

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.