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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
select @@GLOBAL.relay_log_info_repository into @save_relay_log_info_repository;
Warnings:
Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
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 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
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;
Warnings:
Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
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.
|
