MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: Does Mysql Date Partition can be created on date time for every day???
Posted by: Rick James
Date: August 23, 2015 05:55PM

Short answer: Don't use PARTITIONing.

Long answer:

Yes, you could create a partition per day.

There is/was a limit of 1024 partitions in a table.

Your code will slow down with partitioning.

Use PARTITION BY RANGE ( TO_DAYS(dt_column) ), not what you proposed.

BY LIST and BY HASH provide no performance benefit. Only BY RANGE, and only in limited situations.

"Please suggest suitable partition for above scenario." -- You have not described the scenario. You need to include how the data is to be ingested, how big the table will be, what queries will be performed on the table. Etc.

Read this before proceeding:
mysql.rjweb.org/doc.php/partitionmaint

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


Subject
Views
Written By
Posted
Does Mysql Date Partition can be created on date time for every day???
4640
Akshath Hegde
August 23, 2015 12:18AM
Re: Does Mysql Date Partition can be created on date time for every day???
2234
Rick James
August 23, 2015 05:55PM
Re: Does Mysql Date Partition can be created on date time for every day???
2567
Akshath Hegde
August 26, 2015 02:53AM
Re: Does Mysql Date Partition can be created on date time for every day???
2126
Rick James
August 27, 2015 07:40AM


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.