Skip to content

Instantly share code, notes, and snippets.

@santagada
Last active August 29, 2015 14:13
Show Gist options
  • Save santagada/b08c950b121c9f0409f8 to your computer and use it in GitHub Desktop.
Save santagada/b08c950b121c9f0409f8 to your computer and use it in GitHub Desktop.
where are my tmp_disk_tables
mysql> show global status like '%tmp%';
+-------------------------+-----------+
| Variable_name | Value |
+-------------------------+-----------+
| Created_tmp_disk_tables | 146954844 |
| Created_tmp_files | 812363 |
| Created_tmp_tables | 220784074 |
+-------------------------+-----------+
mysql> show variables like '%tmp%';
+-------------------+-----------+
| Variable_name | Value |
+-------------------+-----------+
| max_tmp_tables | 32 |
| slave_load_tmpdir | /tmp |
| tmp_table_size | 536870912 |
| tmpdir | /tmp |
+-------------------+-----------+
4 rows in set (0.00 sec)
mysql> SELECT @@tmpdir;
+----------+
| @@tmpdir |
+----------+
| /tmp |
+----------+
1 row in set (0.00 sec)
/tmp# ls -lah
total 20K
drwxrwxrwt 2 root root 16K Jan 15 15:57 .
drwxr-xr-x 24 root root 4.0K Sep 26 14:12 ..
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment