How to enable Database Logging

AWS console – >  RDS -> DB Instances -> ammaprd -> configuration -> parameter group(e.g. “qasqlgroup”)

Click on Edit Parameters on Top right and type in below parameters (one by one)

Set slow_query_log set to “1”

long query time set to “20”

log_output to “FILE”

Click “Tick Mark” on the chosen parameters on the left “Save Changes” on Top right

You will see the slow query log on AWS console -> RDS – > AMMAPRD -> Logs and events

Incase, you have to reset theses values, please click “Tick Mark” on the needed parameter on the left and then click on “Reset” on Top right

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s