51 lines
1.9 KiB
Plaintext
51 lines
1.9 KiB
Plaintext
select @@GLOBAL.relay_log_info_repository into @save_relay_log_info_repository;
|
|
select @@GLOBAL.expire_logs_days into @save_expire_logs_days;
|
|
Warnings:
|
|
Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
|
|
set @@GLOBAL.relay_log_info_repository = 'FILE';
|
|
Warnings:
|
|
Warning 1287 'FILE' is deprecated and will be removed in a future release. Please use 'TABLE' instead
|
|
flush logs;
|
|
set global expire_logs_days = 3;
|
|
Warnings:
|
|
Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
|
|
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 hostname-relay-bin
|
|
relay_log_basename MYSQLTEST_VARDIR/mysqld.1/data/hostname-relay-bin
|
|
relay_log_index MYSQLTEST_VARDIR/mysqld.1/data/hostname-relay-bin.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 hostname-relay-bin
|
|
relay_log_basename MYSQLTEST_VARDIR/mysqld.1/data/hostname-relay-bin
|
|
relay_log_index MYSQLTEST_VARDIR/mysqld.1/data/hostname-relay-bin.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.relay_log_info_repository = @save_relay_log_info_repository;
|
|
set @@GLOBAL.expire_logs_days = @save_expire_logs_days;
|
|
Warnings:
|
|
Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
|