Find out percentage of tables created on disk
mysql> show global status like 'created_tmp_disk_tables';
+-------------------------+--------+
| Variable_name | Value |
+-------------------------+--------+
| Created_tmp_disk_tables | 278571 |
+-------------------------+--------+
1 row in set (0.00 sec)