MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: Create partition on non key column
Posted by: Rick James
Date: May 29, 2016 12:28AM

What problem (present or future) are you trying to solve?

PARTITIONing without a clear reason for it is folly. There are only 4 use cases where performance improves. See http://mysql.rjweb.org/doc.php/partitionmaint

UUIDs are also a performance problem, especially as the PRIMARY KEY. More discussion here: http://mysql.rjweb.org/doc.php/uuid

But 2000 INSERTs per day is a 'tiny' number. (Even 2000 per minute is not a big problem.)

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


Subject
Views
Written By
Posted
Create partition on non key column
2115
Kapil Gupta
May 26, 2016 05:51AM
Re: Create partition on non key column
1177
Rick James
May 29, 2016 12:28AM


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.