Remove old records from a table in MariaDB/MySQL

MariaDb
Sometimes, we use our database to store various logs or events having all the relations to other entities. It is very useful then to analyse recent activity and potentially detect some anomalies, errors e.t.c
However, the table get's bloated over time and we need a simple mechanism to do some maintenance, such as cleaning old records, or removing the extra trace info.

In MariaDB/MySQL this can be done with the event scheduler.

Post a Comment

Previous Post Next Post