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"
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