Hi All, this document deals with how to remove slow queries and general log from Amazon RDS.
Sometimes there is a requirement to enable slow query in RDS to see the queries which are taking more time to execute. there are to options while enabling slow queries either the queries can be written to TABLE or FIle.
Whenever the size is RDS instance storage, there is a requirement to delete the queries to free up some space.
Here is the command to delete the general logs and slow queries.
Step 1: Login to MySQL with root user.
Step 2: Execute the command to delete the slow and general logs.
© 2019, Techrunnr. All rights reserved.