#### Binary log ENABLED #### ==== Don't set any option ==== # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err include/assert_grep.inc [There shall be no binlog_off+seconds warning] include/assert.inc [binlog_expire_logs_seconds shall be 0] include/assert.inc [expire_logs_days shall be 0] ==== Set one option to zero ==== ---- days=0 ---- # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=0 include/assert_grep.inc [There shall be no binlog_off+seconds warning] include/assert.inc [binlog_expire_logs_seconds shall be 0] include/assert.inc [expire_logs_days shall be 0] ---- seconds=0 ---- # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --binlog-expire-logs-seconds=0 include/assert_grep.inc [There shall be no binlog_off+seconds warning] include/assert.inc [binlog_expire_logs_seconds shall be 0] include/assert.inc [expire_logs_days shall be 0] ==== Set one option to non-zero ==== ---- days=2 ---- # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=2 include/assert_grep.inc [There shall be no binlog_off+seconds warning] include/assert.inc [binlog_expire_logs_seconds shall be 172800] include/assert.inc [expire_logs_days shall be 2] ---- seconds=86400 ---- # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --binlog-expire-logs-seconds=86400 include/assert_grep.inc [There shall be no binlog_off+seconds warning] include/assert.inc [binlog_expire_logs_seconds shall be 86400] include/assert.inc [expire_logs_days shall be 1] ==== Set both options to zero ==== # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=0 --binlog-expire-logs-seconds=0 include/assert_grep.inc [There shall be no binlog_off+seconds warning] include/assert.inc [binlog_expire_logs_seconds shall be 0] include/assert.inc [expire_logs_days shall be 0] ==== Set both options: one to zero and one to non-zero ==== ---- days=1 seconds=0 ---- ---- The later seconds=0 will override days. # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=1 --binlog-expire-logs-seconds=0 include/assert_grep.inc [There shall be no binlog_off+seconds warning] include/assert.inc [binlog_expire_logs_seconds shall be 0] include/assert.inc [expire_logs_days shall be 0] ---- seconds=0 days=1 ---- ---- The later days=1 will override seconds. # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --binlog-expire-logs-seconds=0 --expire_logs_days=1 include/assert_grep.inc [There shall be no binlog_off+seconds warning] include/assert.inc [binlog_expire_logs_seconds shall be 86400] include/assert.inc [expire_logs_days shall be 1] ---- days=0 seconds=86400 ---- ---- The later seconds=86400 will override days. # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=0 --binlog-expire-logs-seconds=86400 include/assert_grep.inc [There shall be no binlog_off+seconds warning] include/assert.inc [binlog_expire_logs_seconds shall be 86400] include/assert.inc [expire_logs_days shall be 1] ==== Set both options to non-zero ==== ---- days=1 and seconds=172800 ---- ---- Since binlog_expire_logs_seconds is set later expire_log_days ---- becomes 2 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=1 --binlog-expire-logs-seconds=172800 include/assert_grep.inc [There shall be no binlog_off+seconds warning] include/assert.inc [binlog_expire_logs_seconds shall be 172800] include/assert.inc [expire_logs_days shall be 2] ---- days=1 and seconds=172800 ---- ---- Since expire_logs_days is set later binlog_expire_logs_seconds ---- becomes 86400 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --binlog-expire-logs-seconds=172800 --expire_logs_days=1 include/assert_grep.inc [There shall be no binlog_off+seconds warning] include/assert.inc [binlog_expire_logs_seconds shall be 86400] include/assert.inc [expire_logs_days shall be 1] #### Binary log DISABLED #### ==== Don't set any option ==== # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin include/assert_grep.inc [There shall be no binlog_off+seconds warning] include/assert.inc [binlog_expire_logs_seconds shall be 0] include/assert.inc [expire_logs_days shall be 0] ==== Set one option to zero ==== ---- days=0 ---- # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=0 include/assert_grep.inc [There shall be no binlog_off+seconds warning] include/assert.inc [binlog_expire_logs_seconds shall be 0] include/assert.inc [expire_logs_days shall be 0] ---- seconds=0 ---- # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --binlog-expire-logs-seconds=0 include/assert_grep.inc [There shall be no binlog_off+seconds warning] include/assert.inc [binlog_expire_logs_seconds shall be 0] include/assert.inc [expire_logs_days shall be 0] ==== Set one option to non-zero ==== ---- days=2 ---- # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=2 include/assert_grep.inc [There shall be a binlog_off+seconds warning] include/assert.inc [binlog_expire_logs_seconds shall be 172800] include/assert.inc [expire_logs_days shall be 2] ---- seconds=86400 ---- # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --binlog-expire-logs-seconds=86400 include/assert_grep.inc [There shall be a binlog_off+seconds warning] include/assert.inc [binlog_expire_logs_seconds shall be 86400] include/assert.inc [expire_logs_days shall be 1] ==== Set both options to zero ==== # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=0 --binlog-expire-logs-seconds=0 include/assert_grep.inc [There shall be no binlog_off+seconds warning] include/assert.inc [binlog_expire_logs_seconds shall be 0] include/assert.inc [expire_logs_days shall be 0] ==== Set both options: one to zero and one to non-zero ==== ---- days=1 seconds=0 ---- ---- The later seconds=0 will override days. # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=1 --binlog-expire-logs-seconds=0 include/assert_grep.inc [There shall be no binlog_off+seconds warning] include/assert.inc [binlog_expire_logs_seconds shall be 0] include/assert.inc [expire_logs_days shall be 0] ---- seconds=0 days=1 ---- ---- The later days=1 will override seconds. # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --binlog-expire-logs-seconds=0 --expire_logs_days=1 include/assert_grep.inc [There shall be a binlog_off+seconds warning] include/assert.inc [binlog_expire_logs_seconds shall be 86400] include/assert.inc [expire_logs_days shall be 1] ---- days=0 seconds=86400 ---- ---- The later seconds=86400 will override days. # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=0 --binlog-expire-logs-seconds=86400 include/assert_grep.inc [There shall be a binlog_off+seconds warning] include/assert.inc [binlog_expire_logs_seconds shall be 86400] include/assert.inc [expire_logs_days shall be 1] ==== Set both options to non-zero ==== ---- days=1 and seconds=172800 ---- ---- Since binlog_expire_logs_seconds is set later expire_log_days ---- becomes 2 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=1 --binlog-expire-logs-seconds=172800 include/assert_grep.inc [There shall be a binlog_off+seconds warning] include/assert.inc [binlog_expire_logs_seconds shall be 172800] include/assert.inc [expire_logs_days shall be 2] ---- days=1 and seconds=172800 ---- ---- Since expire_logs_days is set later binlog_expire_logs_seconds ---- becomes 86400 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --binlog-expire-logs-seconds=172800 --expire_logs_days=1 include/assert_grep.inc [There shall be a binlog_off+seconds warning] include/assert.inc [binlog_expire_logs_seconds shall be 86400] include/assert.inc [expire_logs_days shall be 1]