flush2.result 882 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
flush logs;
set global expire_logs_days = 3;
show variables like 'log_bin%';
Variable_name	Value
log_bin	OFF
log_bin_basename	
log_bin_index	
log_bin_trust_function_creators	ON
log_bin_use_v1_row_events	OFF
show variables like 'relay_log%';
Variable_name	Value
relay_log	
relay_log_basename	
relay_log_index	
relay_log_info_file	relay-log.info
relay_log_info_repository	FILE
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_index	
log_bin_trust_function_creators	ON
log_bin_use_v1_row_events	OFF
show variables like 'relay_log%';
Variable_name	Value
relay_log	
relay_log_basename	
relay_log_index	
relay_log_info_file	relay-log.info
relay_log_info_repository	FILE
relay_log_purge	ON
relay_log_recovery	OFF
relay_log_space_limit	0
set global expire_logs_days = 0;