Debian Codegraph @

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

raw
1 # 2010-01-27 - Added
2
3
4 # Exists as global only
5 #
6 --echo Valid values are between 0 and 1024
7 SELECT @@global.innodb_sync_array_size between 0 and 1024;
8 SELECT @@global.innodb_sync_array_size;
9 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
10 SELECT @@session.innodb_sync_array_size;
11
12 SHOW GLOBAL variables LIKE 'innodb_sync_array_size';
13 SHOW SESSION variables LIKE 'innodb_sync_array_size';
14 --disable_warnings
15 SELECT * FROM performance_schema.global_variables
16 WHERE variable_name='innodb_sync_array_size';
17 SELECT * FROM performance_schema.session_variables
18 WHERE variable_name='innodb_sync_array_size';
19 --enable_warnings
20
21 #
22 # Show that it's read-only
23 #
24 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
25 SET GLOBAL innodb_sync_array_size=10;
26 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
27 SET SESSION innodb_sync_array_size=10;
28 SELECT @@global.innodb_sync_array_size;