mysql.rds_show_configuration - Amazon Relational Database Service


The number of hours that binary logs are retained.


CALL mysql.rds_show_configuration;

Usage notes

To verify the number of hours that Amazon RDS retains binary logs, use the mysql.rds_show_configuration stored procedure.

The mysql.rds_show_configuration procedure is available in these versions of RDS for MySQL:

  • MySQL 5.6

  • MySQL 5.7

  • MySQL 8.0


The following example displays the retention period:

call mysql.rds_show_configuration; name value description binlog retention hours 24 binlog retention hours specifies the duration in hours before binary logs are automatically deleted.