MySQL Bugs: #95243: Automatic creation of new partitions as needed

Bug #95243	Automatic creation of new partitions as needed
Submitted:	3 May 2019 18:06	Modified:	10 Jun 2019 12:44
Reporter:	Datapipe Admins	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	any	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
When partitioning by date, it would be useful if there were a way to give a date-based rule and tell MySQL/InnoDB to auto-create new partitions as needed on first write.  This would greatly simplify management of date-based partitioning schemes as it would enable the partitioning to be self-maintaining.

How feasible would this be?

How to repeat:
Not applicable, this is a feature request.

Suggested fix:
Not applicable, this is a feature request.

Hi,

Thank you very much for your feature request.

You wrote the following:

"
When partitioning by date, it would be useful if there were a way to give a date-based rule and tell MySQL/InnoDB to auto-create new partitions as needed on first write. 
"

We are very happy to accept new feature request, but it has to be well designed.

There are many types of partition types over the whole range of data types. Hence , we would like to see how do you envisage to design those rules, which would trigger a creation of the new partition. Rules have to be very much defined and have to cover all partition types over all data types.

We also do not know of any RDBMS that has that feature, so pointing to an existing feature of that type would be useful.

Many thanks in advance.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".