set @save_expire_logs_days=@@global.expire_logs_days; flush logs; set global expire_logs_days = 3; show variables like 'log_bin%'; Variable_name Value log_bin OFF log_bin_basename log_bin_compress OFF log_bin_compress_min_len 256 log_bin_index log_bin_trust_function_creators ON show variables like 'relay_log%'; Variable_name Value relay_log XXX-relay-bin relay_log_basename MYSQLTEST_VARDIR/mysqld.1/data/XXX-relay-bin relay_log_index MYSQLTEST_VARDIR/mysqld.1/data/XXX-relay-bin.index relay_log_info_file relay-log.info relay_log_purge ON relay_log_recovery OFF relay_log_space_limit 0 flush logs; show variables like 'log_bin%'; Variable_name Value log_bin OFF log_bin_basename log_bin_compress OFF log_bin_compress_min_len 256 log_bin_index log_bin_trust_function_creators ON show variables like 'relay_log%'; Variable_name Value relay_log XXX-relay-bin relay_log_basename MYSQLTEST_VARDIR/mysqld.1/data/XXX-relay-bin relay_log_index MYSQLTEST_VARDIR/mysqld.1/data/XXX-relay-bin.index relay_log_info_file relay-log.info relay_log_purge ON relay_log_recovery OFF relay_log_space_limit 0 set global expire_logs_days=@save_expire_logs_days;