Debian Codegraph @

mysql-test/suite/binlog/r/binlog_expire_logs_persisted_options.result

raw
1 RESET MASTER;
2 SET PERSIST binlog_expire_logs_auto_purge = 0;
3 FLUSH BINARY LOGS;
4 FLUSH BINARY LOGS;
5 show binary logs;
6 Log_name File_size Encrypted
7 binlog.000001 # #
8 binlog.000002 # #
9 binlog.000003 # #
10 include/stop_mysqld.inc [server 1]
11 # restart
12 show binary logs;
13 Log_name File_size Encrypted
14 binlog.000001 # #
15 binlog.000002 # #
16 binlog.000003 # #
17 binlog.000004 # #
18 RESET PERSIST;
19 RESET MASTER;
20 SET PERSIST binlog_expire_logs_seconds = 1000000;
21 FLUSH BINARY LOGS;
22 FLUSH BINARY LOGS;
23 show binary logs;
24 Log_name File_size Encrypted
25 binlog.000001 # #
26 binlog.000002 # #
27 binlog.000003 # #
28 include/stop_mysqld.inc [server 1]
29 # restart
30 show binary logs;
31 Log_name File_size Encrypted
32 binlog.000001 # #
33 binlog.000002 # #
34 binlog.000003 # #
35 binlog.000004 # #
36 RESET PERSIST;
37 SET GLOBAL binlog_expire_logs_seconds = 1;