List:General Discussion« Previous MessageNext Message »
From:shamubro@gmail.com Date:April 7 2010 9:45pm
Subject:How to View MySQL Temp Files and Temp Tables in Linux
View as plain text  
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/  |
+-------------------+----------+

Thread
How to View MySQL Temp Files and Temp Tables in Linuxshamubro@gmail.com7 Apr
  • Re: How to View MySQL Temp Files and Temp Tables in LinuxJohan De Meersman8 Apr