) however we can not see it in show variables command, how do i know which is current flush method?
mysql> show global variables like ‘innodb_flush_method’;
±--------------------±------+
| Variable_name | Value |
±--------------------±------+
| innodb_flush_method | |
±--------------------±------+
Also explicitly adding innodb_flush_method=fdatasync in my.cnf gives error
[ERROR] InnoDB: Unrecognized value fdatasync for innodb_flush_method
[ERROR] Plugin ‘InnoDB’ init function returned error.
We can configure innodb_flush_method=O_DIRECT or innodb_flush_method=O_DSYNC and the same we can see in show variables command
mysql> show global variables like ‘innodb_flush_method’;
±--------------------±---------+
| Variable_name | Value |
±--------------------±---------+
| innodb_flush_method | O_DIRECT |
±--------------------±---------+
Why we can not set innodb_flush_method=fdatasync in my.cnf?