Debian Codegraph @

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

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