We have Mysql running 5.5.25 and “expire_logs_days” is by default ‘0’. We have purged the logs using the command PURGE BINARY LOGS TO ‘mysql-bin.xxxxxx’;. Plan to enable auto purge of mysql bin logs so I set the variable to retain the last 14 days logs as SET GLOBAL expire_logs_days=14. My question…

Clarification on Mysql dynamic variable "expire_logs_days"

krishna January 9, 2014, 3:55pm 3

Thanks for clarifying Irfan.

Topic		Replies	Views
expire_log_days can't be set in my.cnf Other MySQL® Questions	1	1068	December 7, 2017
When is bin-logs expired by expire_log_days? Other MySQL® Questions	2	2935	May 30, 2014
After Dynamic expire_logs_days Change, Only Manual Flushing Works Percona Server for MySQL 5.6	0	812	July 31, 2016
Error log rotation on crash Other MySQL® Questions	1	1048	December 24, 2012
Expire_logs_days => binlog_expire_logs_seconds Percona Toolkit	1	105	February 17, 2025