1# 2# Basic test for innodb_saved_page_number_debug. 3# 4SELECT @@global.innodb_saved_page_number_debug; 5@@global.innodb_saved_page_number_debug 60 7set global innodb_saved_page_number_debug = 10; 8SELECT @@global.innodb_saved_page_number_debug; 9@@global.innodb_saved_page_number_debug 1010 11set global innodb_saved_page_number_debug = 100; 12set global innodb_saved_page_number_debug = dummy; 13ERROR 42000: Incorrect argument type to variable 'innodb_saved_page_number_debug' 14set innodb_saved_page_number_debug = ON; 15ERROR HY000: Variable 'innodb_saved_page_number_debug' is a GLOBAL variable and should be set with SET GLOBAL 16# An example usage. 17create table t1 (f1 int primary key) engine = innodb; 18select space from information_schema.innodb_sys_tables 19where name = 'test/t1' into @space_id; 20Warnings: 21Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead 22set global innodb_saved_page_number_debug = 0; 23set global innodb_fil_make_page_dirty_debug = @space_id; 24drop table t1; 25set global innodb_saved_page_number_debug = 0; 26SELECT @@global.innodb_saved_page_number_debug; 27@@global.innodb_saved_page_number_debug 280 29