MySQL Forums :: Partitioning :: Does Mysql Date Partition can be created on date time for every day???


Advanced Search

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
Does Mysql Date Partition can be created on date time for every day??? 1562 Akshath Hegde 08/23/2015 12:18AM
Re: Does Mysql Date Partition can be created on date time for every day??? 820 Rick James 08/23/2015 05:55PM
Re: Does Mysql Date Partition can be created on date time for every day??? 816 Akshath Hegde 08/26/2015 02:53AM
Re: Does Mysql Date Partition can be created on date time for every day??? 773 Rick James 08/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.