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
Categories: databaseMYSQL

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

Please wait...

Subscribe to our newsletter

Want to be notified when our article is published? Enter your email address and name below to be the first to know.