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 个月前123 查看次数
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

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则