1set @save_expire_logs_days=@@global.expire_logs_days; 2flush logs; 3set global expire_logs_days = 3; 4show variables like 'log_bin%'; 5Variable_name Value 6log_bin OFF 7log_bin_basename 8log_bin_compress OFF 9log_bin_compress_min_len 256 10log_bin_index 11log_bin_trust_function_creators ON 12show variables like 'relay_log%'; 13Variable_name Value 14relay_log XXX-relay-bin 15relay_log_basename MYSQLTEST_VARDIR/mysqld.1/data/XXX-relay-bin 16relay_log_index MYSQLTEST_VARDIR/mysqld.1/data/XXX-relay-bin.index 17relay_log_info_file relay-log.info 18relay_log_purge ON 19relay_log_recovery OFF 20relay_log_space_limit 0 21flush logs; 22show variables like 'log_bin%'; 23Variable_name Value 24log_bin OFF 25log_bin_basename 26log_bin_compress OFF 27log_bin_compress_min_len 256 28log_bin_index 29log_bin_trust_function_creators ON 30show variables like 'relay_log%'; 31Variable_name Value 32relay_log XXX-relay-bin 33relay_log_basename MYSQLTEST_VARDIR/mysqld.1/data/XXX-relay-bin 34relay_log_index MYSQLTEST_VARDIR/mysqld.1/data/XXX-relay-bin.index 35relay_log_info_file relay-log.info 36relay_log_purge ON 37relay_log_recovery OFF 38relay_log_space_limit 0 39set global expire_logs_days=@save_expire_logs_days; 40