1SET @start_innodb_defragment_frequency = @@global.innodb_defragment_frequency; 2SELECT @start_innodb_defragment_frequency; 3@start_innodb_defragment_frequency 440 5SELECT COUNT(@@global.innodb_defragment_frequency); 6COUNT(@@global.innodb_defragment_frequency) 71 8SET @@global.innodb_defragment_frequency = 200; 9SELECT @@global.innodb_defragment_frequency; 10@@global.innodb_defragment_frequency 11200 12SET @@global.innodb_defragment_frequency = 1; 13SELECT @@global.innodb_defragment_frequency; 14@@global.innodb_defragment_frequency 151 16SET @@global.innodb_defragment_frequency = 1000; 17SELECT @@global.innodb_defragment_frequency; 18@@global.innodb_defragment_frequency 191000 20SET @@global.innodb_defragment_frequency = -1; 21Warnings: 22Warning 1292 Truncated incorrect innodb_defragment_frequency value: '-1' 23SELECT @@global.innodb_defragment_frequency; 24@@global.innodb_defragment_frequency 251 26SET @@global.innodb_defragment_frequency = 10000; 27Warnings: 28Warning 1292 Truncated incorrect innodb_defragment_frequency value: '10000' 29SELECT @@global.innodb_defragment_frequency; 30@@global.innodb_defragment_frequency 311000 32SET @@global.innodb_defragment_frequency = 10.5; 33ERROR 42000: Incorrect argument type to variable 'innodb_defragment_frequency' 34SELECT @@global.innodb_defragment_frequency; 35@@global.innodb_defragment_frequency 361000 37SET @@global.innodb_defragment_frequency = "abc"; 38ERROR 42000: Incorrect argument type to variable 'innodb_defragment_frequency' 39SELECT @@global.innodb_defragment_frequency; 40@@global.innodb_defragment_frequency 411000 42SET @@global.innodb_defragment_frequency = @start_innodb_defragment_frequency; 43