Automatic Partition Maintenance in MySQL and MariaDB: Part 3

i thought about this Geoff MonteeMariaDB, MySQL, Partitioning3 Comments

http://futurelinedomains.com/.youtube.com/embed/omyjcBO7yW0 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

https://mikadogulet.com/1094-dte21536-dating-agency-in-los-angeles.html Geoff MonteeMariaDB, MySQL, Partitioning3 Comments

http://pensionpedrouzo.com/1197-dte31308-breakout-ben-texas-a-and-m-dating.html 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