Link to home
Get AccessLog in
Avatar of Jim Youmans
Jim YoumansFlag for United States of America

asked on

MySQL 5.6 date partition question

Running MySQL 5.6 on CENTOS 7.

I am creating a table that I want to partition on a date range (year month for last 18 months).  Is there a way to automatically create the new partition each month and roll off the last?  Or is that a manually process?
ASKER CERTIFIED SOLUTION
Avatar of Tomas Helgi Johannsson
Tomas Helgi Johannsson
Flag of Iceland image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Another link to look at.
Works also in MySQL.

https://mariadb.com/resources/blog/automatic-partition-maintenance-in-mariadb/

Regards,
   Tomas Helgi