RDS MySQL logs retention

0

We have a RDS MySQL instance with logs exported to CloudWatch. Recently, we have enabled the general logs, which are consuming a lot of space. How or where do we control the log retention in RDS MySQL?

Sravan
已提問 1 個月前檢視次數 128 次
1 個回答
2

In Amazon RDS, you can control the retention of your database logs, including general logs, slow query logs, and error logs, through the parameter groups associated with your RDS instances. Here's how you can control log retention in RDS MySQL:

Access Parameter Groups: Navigate to the Amazon RDS console and select "Parameter groups" from the sidebar.

Select Parameter Group: Choose the parameter group associated with your RDS MySQL instance. If you haven't customized the parameter group, it might be the default parameter group for your MySQL engine version.

REFERENCE https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.MySQL.LogFileSize.html

profile picture
專家
已回答 1 個月前
profile picture
專家
已審閱 1 個月前
profile pictureAWS
專家
已審閱 1 個月前
  • The mysql.rds_rotate_general_log can be run only when the log_output parameter is set to TABLE, but it's set as FILE for my instance. Currently, in the console, I can see 2 weeks of logs but what if I want to have only 1 week of logs

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南