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
demandé il y a un mois129 vues
1 réponse
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
EXPERT
répondu il y a un mois
profile picture
EXPERT
vérifié il y a un mois
profile pictureAWS
EXPERT
vérifié il y a un mois
  • 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

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions