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

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ