Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_fill_factor_basic.test

raw
1
2 #
3 # 2014-03-26 - Added
4 #
5
6
7 #
8 # show the global and session values;
9 #
10 select @@global.innodb_fill_factor;
11 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
12 select @@session.innodb_fill_factor;
13 show global variables like 'innodb_fill_factor';
14 show session variables like 'innodb_fill_factor';
15 --disable_warnings
16 select * from performance_schema.global_variables where variable_name='innodb_fill_factor';
17 select * from performance_schema.session_variables where variable_name='innodb_fill_factor';
18 --enable_warnings
19
20 #
21 # test default, min, max value
22 #
23 let $innodb_fill_factor_orig=`select @@innodb_fill_factor`;
24
25 set global innodb_fill_factor=9;
26 select @@innodb_fill_factor;
27
28 set global innodb_fill_factor=10;
29 select @@innodb_fill_factor;
30
31 set global innodb_fill_factor=75;
32 select @@innodb_fill_factor;
33
34 set global innodb_fill_factor=100;
35 select @@innodb_fill_factor;
36
37 set global innodb_fill_factor=101;
38 select @@innodb_fill_factor;
39
40 eval set global innodb_fill_factor=$innodb_fill_factor_orig;