binlog_expire_logs_seconds

USAGE

The binlog_expire_logs_seconds system variable can be set in a configuration file:

[mariadb]
binlog_expire_logs_seconds=21600

The global value of the binlog_expire_logs_seconds system variable can also be set dynamically at runtime by executing SET GLOBAL:

SET GLOBAL binlog_expire_logs_seconds=21600;

When the binlog_expire_logs_seconds system variable is set dynamically at runtime, its value will be reset the next time the server restarts. To make the value persist on restart, set it in a configuration file too.

DETAILS

The binlog_expire_logs_seconds system variable can be used to configure the binlog expiration period with a temporal resolution of 1 second.

In versions with the binlog_expire_logs_seconds system variable, the expire_logs_days system variable is linked to the binlog_expire_logs_seconds system variable:

• When the binlog_expire_logs_seconds system variable is set, the specified value in seconds is converted to the corresponding number of days, and the resulting floating point value is set to the expire_logs_days system variable.

• When the expire_logs_days system variable is set, the specified value in days is converted to the corresponding number of seconds, and the resulting integer value is set to the binlog_expire_logs_seconds system variable.

Prior to this feature, the expire_logs_days system variable only supported integer values, so the binary log expiration period could only have a temporal resolution of 1 day.

EXAMPLES

SET GLOBAL binlog_expire_logs_seconds = 43200;

SHOW VARIABLES LIKE '%expire_logs%';

+----------------------------+----------+
| Variable_name              | Value    |
+----------------------------+----------+
| binlog_expire_logs_seconds | 43200    |
| expire_logs_days           | 0.500000 |
+----------------------------+----------+

SET GLOBAL expire_logs_days = 10;

SHOW VARIABLES LIKE '%expire_logs%';

+----------------------------+-----------+
| Variable_name              | Value     |
+----------------------------+-----------+
| binlog_expire_logs_seconds | 864000    |
| expire_logs_days           | 10.000000 |
+----------------------------+-----------+

CHANGE HISTORY

EXTERNAL REFERENCES

• Information specific to MariaDB SkySQL can be found on the binlog_expire_logs_seconds page in the SkySQL Documentation.