1SET @start_innodb_defragment_stats_accuracy = @@global.innodb_defragment_stats_accuracy; 2SELECT @start_innodb_defragment_stats_accuracy; 3@start_innodb_defragment_stats_accuracy 40 5SELECT COUNT(@@global.innodb_defragment_stats_accuracy); 6COUNT(@@global.innodb_defragment_stats_accuracy) 71 8SET @@global.innodb_defragment_stats_accuracy = 1; 9SELECT @@global.innodb_defragment_stats_accuracy; 10@@global.innodb_defragment_stats_accuracy 111 12SET @@global.innodb_defragment_stats_accuracy = 1000; 13SELECT @@global.innodb_defragment_stats_accuracy; 14@@global.innodb_defragment_stats_accuracy 151000 16SET @@global.innodb_defragment_stats_accuracy = -1; 17Warnings: 18Warning 1292 Truncated incorrect innodb_defragment_stats_accuracy value: '-1' 19SELECT @@global.innodb_defragment_stats_accuracy; 20@@global.innodb_defragment_stats_accuracy 210 22SET @@global.innodb_defragment_stats_accuracy = 1000000000000; 23Warnings: 24Warning 1292 Truncated incorrect innodb_defragment_stats_accuracy value: '1000000000000' 25SELECT @@global.innodb_defragment_stats_accuracy; 26@@global.innodb_defragment_stats_accuracy 274294967295 28SET @@global.innodb_defragment_stats_accuracy = "abc"; 29ERROR 42000: Incorrect argument type to variable 'innodb_defragment_stats_accuracy' 30SELECT @@global.innodb_defragment_stats_accuracy; 31@@global.innodb_defragment_stats_accuracy 324294967295 33SET @@global.innodb_defragment_stats_accuracy = @start_innodb_defragment_stats_accuracy; 34