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