SELECT queries MySQL needs some times
the help of temporary tables. These temporary tables can be
created either in memory or on disk.
The number of creations of such temporary tables can be found with the following command:
mysql> SHOW GLOBAL STATUS LIKE 'created_tmp%tables'; …[Read more...]