Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_fsync_threshold_basic.test

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