mysql> show status like 'Created_tmp%';
+-------------------------+-------+
| Variable_name           | Value |
+-------------------------+-------+
| Created_tmp_disk_tables | 14574 |
| Created_tmp_files       | 2440  |
| Created_tmp_tables      | 14595 |
+-------------------------+-------+
3 rows in set (0.00 sec)