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