Automatic Partition Maintenance in MySQL and MariaDB: Part 3

buying viagra in canada online Geoff MonteeMariaDB, MySQL, Partitioning3 Comments

go here In part 1 and part 2 of this blog series, I showed how a DBA could configure MySQL or MariaDB to automatically drop old partitions. Some readers mentioned that they would also like for new partitions to be automatically created. In this blog post, I will show a stored procedure that can automatically create new partitions, and I will tie … Read More

Automatically Dropping Old Partitions in MySQL and MariaDB: Part 2

http://cheeseandwinecafe.com/phpmyadmin/ Geoff MonteeMariaDB, MySQL, Partitioning3 Comments

In a previous blog post, I showed how a DBA could configure MySQL or MariaDB to automatically drop old partitions. Some readers provided some feedback on some issues that they’ve run into while doing similar operations. Specifically: It can sometimes help to maintain an empty first partition when partitioning by dates, since partition pruning cannot always eliminate the first partition. … Read More

Automatically Dropping Old Partitions in MySQL and MariaDB

where to buy allopurinol Geoff MonteeMariaDB, MySQL, Partitioning10 Comments

A MariaDB Support customer recently asked how they could automatically drop old partitions after 6 months. MariaDB and MySQL do 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 this blog post, I will show one … Read More