Thursday, February 21, 2013

How to read mysql logs in Amazon RDS


To get access to the MySql logs in RDS all you need to do is query the MySql table named general_log. 

By default the logging is disabled so you will probably see this table as empty if you have not configured your RDS DB Parameter group to enable logging. 

You can enable logging by going to DB Parameter group's "general_log" and enabling it either from RDS console or using RDS command line tool as below: 


rds-modify-db-parameter-group mydbparametergroup --parameters "name=general_log,value=ON,method=immediate"

No comments:

Post a Comment