SHOW VARIABLES LIKE 'innodb_flush_method'; Variable_name Value innodb_flush_method O_DIRECT CREATE TABLE t1 (x INT) ENGINE=INNODB, DATA DIRECTORY='MYSQL_TMP_DIR'; # Contents of tmp/test directory containing .ibd file t1.ibd # Contents of the 'test' database directory containing .isl and .frm files db.opt t1.frm t1.isl DROP TABLE t1;