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.

mysql -u root -p

Step 2: Execute the command to delete the slow and general logs.

CALL mysql.rds_rotate_slow_log;
CALL mysql.rds_rotate_general_log;

 

© 2019, Techrunnr. All rights reserved.

#1
#2
#3
Questions Answered
Articles Written
Overall Points

Prabhin Prabharkaran

He is Technical professional. He is a person who loves to share tricks and tips on the Internet. He Posts what he does!!

0 Comments

Leave a Reply