Debian Codegraph @

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

raw
1 select @@global.innodb_fill_factor;
2 @@global.innodb_fill_factor
3 100
4 select @@session.innodb_fill_factor;
5 ERROR HY000: Variable 'innodb_fill_factor' is a GLOBAL variable
6 show global variables like 'innodb_fill_factor';
7 Variable_name Value
8 innodb_fill_factor 100
9 show session variables like 'innodb_fill_factor';
10 Variable_name Value
11 innodb_fill_factor 100
12 select * from performance_schema.global_variables where variable_name='innodb_fill_factor';
13 VARIABLE_NAME VARIABLE_VALUE
14 innodb_fill_factor 100
15 select * from performance_schema.session_variables where variable_name='innodb_fill_factor';
16 VARIABLE_NAME VARIABLE_VALUE
17 innodb_fill_factor 100
18 set global innodb_fill_factor=9;
19 Warnings:
20 Warning 1292 Truncated incorrect innodb_fill_factor value: '9'
21 select @@innodb_fill_factor;
22 @@innodb_fill_factor
23 10
24 set global innodb_fill_factor=10;
25 select @@innodb_fill_factor;
26 @@innodb_fill_factor
27 10
28 set global innodb_fill_factor=75;
29 select @@innodb_fill_factor;
30 @@innodb_fill_factor
31 75
32 set global innodb_fill_factor=100;
33 select @@innodb_fill_factor;
34 @@innodb_fill_factor
35 100
36 set global innodb_fill_factor=101;
37 Warnings:
38 Warning 1292 Truncated incorrect innodb_fill_factor value: '101'
39 select @@innodb_fill_factor;
40 @@innodb_fill_factor
41 100
42 set global innodb_fill_factor=100;