Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_segment_reserve_factor_basic.result

raw
1 SET @start_value = @@innodb_segment_reserve_factor;
2 SELECT @start_value;
3 @start_value
4 12.5
5 SET GLOBAL innodb_segment_reserve_factor=default;
6 SELECT @@innodb_segment_reserve_factor;
7 @@innodb_segment_reserve_factor
8 12.500000
9 SET GLOBAL innodb_segment_reserve_factor = 0.0;
10 Warnings:
11 Warning 1292 Truncated incorrect innodb_segment_reserve_factor value: '0'
12 SELECT @@innodb_segment_reserve_factor;
13 @@innodb_segment_reserve_factor
14 0.030000
15 SET GLOBAL innodb_segment_reserve_factor = 0.1;
16 SELECT @@innodb_segment_reserve_factor;
17 @@innodb_segment_reserve_factor
18 0.100000
19 SET GLOBAL innodb_segment_reserve_factor = 0.5;
20 SELECT @@innodb_segment_reserve_factor;
21 @@innodb_segment_reserve_factor
22 0.500000
23 SET GLOBAL innodb_segment_reserve_factor = @start_value;
24 SELECT @@innodb_segment_reserve_factor;
25 @@innodb_segment_reserve_factor
26 12.500000