DZone Database Zone
Automatic Partition Maintenance in MariaDB
A MariaDB Support customer recently asked how they could automatically drop old partitions after six months. MariaDB does not have a mechanism to do this automatically out-of-the-box, but it is not too difficult to create a custom stored procedure and an event to call the procedure on the desired schedule. In fact, it is also possible to go even further and create a stored procedure that can also automatically add new partitions.
In this blog post, I will show you how to write stored procedures that perform these tasks.
No comments:
Post a Comment