Debian Codegraph @

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

raw
1 #
2 # Basic test for innodb_fil_make_page_dirty_debug.
3 #
4 SELECT @@global.innodb_fil_make_page_dirty_debug;
5 @@global.innodb_fil_make_page_dirty_debug
6 4294967295
7 set global innodb_fil_make_page_dirty_debug = 1000;
8 SELECT @@global.innodb_fil_make_page_dirty_debug;
9 @@global.innodb_fil_make_page_dirty_debug
10 4294967295
11 set global innodb_fil_make_page_dirty_debug = 1000;
12 set global innodb_fil_make_page_dirty_debug = dummy;
13 ERROR 42000: Incorrect argument type to variable 'innodb_fil_make_page_dirty_debug'
14 set innodb_fil_make_page_dirty_debug = ON;
15 ERROR HY000: Variable 'innodb_fil_make_page_dirty_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 = 1000;
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 # Must always be 0.
25 SELECT @@global.innodb_fil_make_page_dirty_debug;
26 @@global.innodb_fil_make_page_dirty_debug
27 4294967295