Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_saved_page_number_debug_basic.result

raw
1 #
2 # Basic test for innodb_saved_page_number_debug.
3 #
4 SELECT @@global.innodb_saved_page_number_debug;
5 @@global.innodb_saved_page_number_debug
6 0
7 set global innodb_saved_page_number_debug = 10;
8 SELECT @@global.innodb_saved_page_number_debug;
9 @@global.innodb_saved_page_number_debug
10 10
11 set global innodb_saved_page_number_debug = 100;
12 set global innodb_saved_page_number_debug = dummy;
13 ERROR 42000: Incorrect argument type to variable 'innodb_saved_page_number_debug'
14 set innodb_saved_page_number_debug = ON;
15 ERROR HY000: Variable 'innodb_saved_page_number_debug' is a GLOBAL variable and should be set with SET GLOBAL
16 # An example usage.
17 create table t1 (f1 int primary key) engine = innodb;
18 select space from information_schema.innodb_tables
19 where name = 'test/t1' into @space_id;
20 set global innodb_saved_page_number_debug = 10000;
21 set global innodb_fil_make_page_dirty_debug = @space_id;
22 drop table t1;
23 set global innodb_saved_page_number_debug = 0;
24 SELECT @@global.innodb_saved_page_number_debug;
25 @@global.innodb_saved_page_number_debug
26 0