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

Published by heemasatapathy

Heema is currently working as Manager, Infrastructure and Cloud Solutions at Computer Technology Resources, Inc and oversees a team of Infrastructure and Cloud Experts performing complex upgrades and migrations to various cloud flavors including but not limited to OCI, AWS, Azure. She is a seasoned IT professional having worked worldwide - India, Japan, Malaysia, Singapore, Switzerland, and USA. She holds an Oracle Ace status and loves to be part of the community group.

Leave a Reply

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

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com 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 )

Cancel

Connecting to %s