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