Saturday, June 30, 2012

Amazon RDS - MySQL - Turn on Slow Log and General Log

Following commands create a new db parameter group for your RDS server and set 
slow_query_log and general_log parameters


You will need to setup RDS tools configured with your keys to execute the below commands


$ rds-create-db-parameter-group slow-log-group -f mysql5.1 -d "This is created to enable slow query logging and a few other db parameters"

$ rds-modify-db-instance pd-rds-server --db-parameter-group-name slow-log-group --apply-immediately

$ rds-modify-db-parameter-group slow-log-group --parameters "name=slow_query_log, value=ON, method=immediate" --parameters "name=long_query_time, value=1, method=immediate" --parameters "name=min_examined_row_limit, value=100, method=immediate" "name=general_log, value=ON, method=immediate"

$ rds-describe-db-parameters slow-log-group

$ rds-reboot-db-instance pd-rds-server 

No comments:

Post a Comment