SET GLOBAL innodb_adaptive_flushing_method='0';
SELECT @@GLOBAL.innodb_adaptive_flushing_method;
@@GLOBAL.innodb_adaptive_flushing_method
0
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='innodb_adaptive_flushing_method';
VARIABLE_NAME VARIABLE_VALUE
INNODB_ADAPTIVE_FLUSHING_METHOD 0
SELECT * FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='innodb_adaptive_flushing_method';
VARIABLE_NAME VARIABLE_VALUE
INNODB_ADAPTIVE_FLUSHING_METHOD 0
SET GLOBAL innodb_ adaptive_ flushing_ method= '0'; innodb_ adaptive_ flushing_ method; innodb_ adaptive_ flushing_ method SCHEMA. GLOBAL_ VARIABLES WHERE VARIABLE_ NAME='innodb_ adaptive_ flushing_ method' ; ADAPTIVE_ FLUSHING_ METHOD 0 SCHEMA. SESSION_ VARIABLES WHERE VARIABLE_ NAME='innodb_ adaptive_ flushing_ method' ; ADAPTIVE_ FLUSHING_ METHOD 0
SELECT @@GLOBAL.
@@GLOBAL.
0
SELECT * FROM INFORMATION_
VARIABLE_NAME VARIABLE_VALUE
INNODB_
SELECT * FROM INFORMATION_
VARIABLE_NAME VARIABLE_VALUE
INNODB_
It should be s/0/native instead.