1SET @start_innodb_defragment_fill_factor_n_recs = @@global.innodb_defragment_fill_factor_n_recs; 2SELECT @start_innodb_defragment_fill_factor_n_recs; 3@start_innodb_defragment_fill_factor_n_recs 420 5SELECT COUNT(@@global.innodb_defragment_fill_factor_n_recs); 6COUNT(@@global.innodb_defragment_fill_factor_n_recs) 71 8SET @@global.innodb_defragment_fill_factor_n_recs = 50; 9SELECT @@global.innodb_defragment_fill_factor_n_recs; 10@@global.innodb_defragment_fill_factor_n_recs 1150 12SET @@global.innodb_defragment_fill_factor_n_recs = 100; 13SELECT @@global.innodb_defragment_fill_factor_n_recs; 14@@global.innodb_defragment_fill_factor_n_recs 15100 16SET @@global.innodb_defragment_fill_factor_n_recs = 1; 17SELECT @@global.innodb_defragment_fill_factor_n_recs; 18@@global.innodb_defragment_fill_factor_n_recs 191 20SET @@global.innodb_defragment_fill_factor_n_recs = -1; 21Warnings: 22Warning 1292 Truncated incorrect innodb_defragment_fill_factor... value: '-1' 23SELECT @@global.innodb_defragment_fill_factor_n_recs; 24@@global.innodb_defragment_fill_factor_n_recs 251 26SET @@global.innodb_defragment_fill_factor_n_recs = 10000; 27Warnings: 28Warning 1292 Truncated incorrect innodb_defragment_fill_factor... value: '10000' 29SELECT @@global.innodb_defragment_fill_factor_n_recs; 30@@global.innodb_defragment_fill_factor_n_recs 31100 32SET @@global.innodb_defragment_fill_factor_n_recs = 10.5; 33ERROR 42000: Incorrect argument type to variable 'innodb_defragment_fill_factor_n_recs' 34SELECT @@global.innodb_defragment_fill_factor_n_recs; 35@@global.innodb_defragment_fill_factor_n_recs 36100 37SET @@global.innodb_defragment_fill_factor_n_recs = "abc"; 38ERROR 42000: Incorrect argument type to variable 'innodb_defragment_fill_factor_n_recs' 39SELECT @@global.innodb_defragment_fill_factor_n_recs; 40@@global.innodb_defragment_fill_factor_n_recs 41100 42SET @@global.innodb_defragment_fill_factor_n_recs = @start_innodb_defragment_fill_factor_n_recs; 43