Debian Codegraph @

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

raw
1 Valid values are between 0 and 1024
2 SELECT @@global.innodb_sync_array_size between 0 and 1024;
3 @@global.innodb_sync_array_size between 0 and 1024
4 1
5 SELECT @@global.innodb_sync_array_size;
6 @@global.innodb_sync_array_size
7 1
8 SELECT @@session.innodb_sync_array_size;
9 ERROR HY000: Variable 'innodb_sync_array_size' is a GLOBAL variable
10 SHOW GLOBAL variables LIKE 'innodb_sync_array_size';
11 Variable_name Value
12 innodb_sync_array_size 1
13 SHOW SESSION variables LIKE 'innodb_sync_array_size';
14 Variable_name Value
15 innodb_sync_array_size 1
16 SELECT * FROM performance_schema.global_variables
17 WHERE variable_name='innodb_sync_array_size';
18 VARIABLE_NAME VARIABLE_VALUE
19 innodb_sync_array_size 1
20 SELECT * FROM performance_schema.session_variables
21 WHERE variable_name='innodb_sync_array_size';
22 VARIABLE_NAME VARIABLE_VALUE
23 innodb_sync_array_size 1
24 SET GLOBAL innodb_sync_array_size=10;
25 ERROR HY000: Variable 'innodb_sync_array_size' is a read only variable
26 SET SESSION innodb_sync_array_size=10;
27 ERROR HY000: Variable 'innodb_sync_array_size' is a read only variable
28 SELECT @@global.innodb_sync_array_size;
29 @@global.innodb_sync_array_size
30 1