How to View MySQL Temp Files and Temp Tables in Linux
am 07.04.2010 23:45:33 von shamubro--0016361e7efe5f25520483ac7b80
Content-Type: text/plain; charset=ISO-8859-1
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/ |
+-------------------+----------+
--0016361e7efe5f25520483ac7b80--