We are going to talk here about time series data and Partitions in MySQL. If you are not familiar with these I highly recommend you read the prevoius blog post

Since there cannot be a infinite number of partitions, periodic maintenance of partitions - dropping old partitions and creating new ones - is required. Manual Partition Maintenance is prone to delays and errors. Read on to know how I created a script for automatic maintenance for partitions.

Read on Medium →