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