Below is my MySQL Server's status and configuration. But I can not see anything under /tmpfs/, it is showing empty to me.
here is the result of "ls -al" drwxrwxrwx 2 mysql mysql 60 Apr 7 17:43 tmpfs Could anyone tell me how to check the status of temp files and temp tables on disk? Thanks. ---- mysql> SHOW global STATUS LIKE 'created_tmp%'; +-------------------------+-------+ | Variable_name | Value | +-------------------------+-------+ | Created_tmp_disk_tables | 4682 | | Created_tmp_files | 291 | | Created_tmp_tables | 10997 | +-------------------------+-------+ mysql> SHOW variables LIKE '%tmp%'; +-------------------+----------+ | Variable_name | Value | +-------------------+----------+ | bdb_tmpdir | /tmpfs/ | | max_tmp_tables | 32 | | slave_load_tmpdir | /tmpfs/ | | tmp_table_size | 67108864 | | tmpdir | /tmpfs/ | +-------------------+----------+
