show variables like 'innodb_flush_method'; empty
 

Hi,

when I check mysql innodb_flush_method it's empty. is it normal?

AFAIK, yes, it's normal. Here's the supporting documentation produced by running the command:

info mysql

if your mysql related files are complete and properly installed. Then navigating to:

storage-engines==>innodb==>innodb-parameters

then search for innodb_flush_method, this is the info for linux:


*Permitted Values *
*Type* (linux) `enumeration'
*Default* `fdatasync'
*Valid Values* `fdatasync',
`O_DSYNC',
`O_DIRECT'



Formerly it was possible to specify a value of `fdatasync' to
obtain the default behavior. This is no longer possible as of
MySQL 5.1.24 because it can be confusing that a value of
`fdatasync' causes use of `fsync()' rather than `fdatasync()' for
flushing.

So AFAIK, the default is to have no value for that parameter.