How to Clear the Slow Query Log on AWS RDS MySQL/ MariaDB

How to Clear the Slow Query Log on AWS RDS MySQL/ MariaDB

Category : How-to

Get Social!

Here is a super simple little tip for clearing the mysql.slow_log in MySQL or MariaDB when running an RDS on Amazon AWS. 

Unfortunately the usual approach of simply DELETing or TRUNCATING data from the table doesn’t work due to a permission error. This is true, even for the AWS created master database user.

Luckily, the Amazon AWS team have put together a package that clears out the table for us. 


Visit our advertisers

Search

Quick Poll

Are you using Docker.io?

Visit our advertisers