Debian Codegraph @

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

raw
1 #
2 # Checking min, max and incorrect values of innodb_fsync_threshold status variable
3 #
4 SET @orig_fsync_threshold = @@global.innodb_fsync_threshold;
5 SELECT @orig_fsync_threshold;
6 @orig_fsync_threshold
7 0
8 SET GLOBAL innodb_fsync_threshold = 1024*1024*1024;
9 SELECT @@global.innodb_fsync_threshold;
10 @@global.innodb_fsync_threshold
11 1073741824
12 # min value
13 SET GLOBAL innodb_fsync_threshold = 0;
14 SELECT @@global.innodb_fsync_threshold;
15 @@global.innodb_fsync_threshold
16 0
17 # invalid value - too small
18 SET GLOBAL innodb_fsync_threshold = -1;
19 Warnings:
20 Warning 1292 Truncated incorrect innodb_fsync_threshold value: '-1'
21 SELECT @@global.innodb_fsync_threshold;
22 @@global.innodb_fsync_threshold
23 0
24 # invalid value - not bound to page size
25 SET GLOBAL innodb_fsync_threshold = 12345;
26 Warnings:
27 Warning 1292 Truncated incorrect innodb_fsync_threshold value: '12345'
28 SELECT @@global.innodb_fsync_threshold;
29 @@global.innodb_fsync_threshold
30 0
31 SET GLOBAL innodb_fsync_threshold = @orig_fsync_threshold;