1#
2# Basic test for innodb_buf_flush_list_now.
3#
4SELECT @@global.innodb_buf_flush_list_now;
5@@global.innodb_buf_flush_list_now
60
7set global innodb_buf_flush_list_now = 1;
8SELECT @@global.innodb_buf_flush_list_now;
9@@global.innodb_buf_flush_list_now
100
11set global innodb_buf_flush_list_now = 0;
12set global innodb_buf_flush_list_now = dummy;
13ERROR 42000: Variable 'innodb_buf_flush_list_now' can't be set to the value of 'dummy'
14set innodb_buf_flush_list_now = ON;
15ERROR HY000: Variable 'innodb_buf_flush_list_now' is a GLOBAL variable and should be set with SET GLOBAL
16# Setting to ON is ok.
17set global innodb_buf_flush_list_now = ON;
18# Setting to OFF is ok.
19set global innodb_buf_flush_list_now = OFF;
20# Must always be 0.
21SELECT @@global.innodb_buf_flush_list_now;
22@@global.innodb_buf_flush_list_now
230
24