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

Unknown's avatar

Published by heemasatapathy

Heema is an Oracle Ace Pro, IEEE Senior Member, and experienced speaker at both local and international IT conferences. With two decades of hands-on experience as a senior DBA and Solution Architect, Heema is adept at database administration and eager to embrace new technologies. Known for being customer-focused, organized, and self-motivated, Heema has a strong track record in managing technical projects and communicating solutions effectively. His global IT experience spans India, Japan, Malaysia, Singapore, Switzerland, and the USA. He holds a Bachelor of Engineering degree with Honors.

Leave a comment