One of my servers runs a query once a week to remove all rows from a Syslog table (>20,000,000 rows) in a MySQL database that are older than 60 days. This was running terribly slowly and interfering with other tasks on the server. Although the original query used a DELETE statement I’ve used SELECT statements … Continue reading MySQL date_add and date_sub functions running against millions of rows