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
gefragt vor einem Monat128 Aufrufe
1 Antwort
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
EXPERTE
beantwortet vor einem Monat
profile picture
EXPERTE
überprüft vor einem Monat
profile pictureAWS
EXPERTE
überprüft vor einem Monat
  • 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

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen