MySQL Forums
Forum List  »  Partitioning

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Does Mysql Date Partition can be created on date time for every day???
980
August 23, 2015 05:55PM


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.