MySql tmp tables
Get flash to fully experience Pearltrees
© 2012, Oracle Corporation and/or its affiliates
MySQL :: MySQL 5.1 Reference Manual :: 7.5.10 How MySQL Uses Int
MySQL Performance: MySQL => Created_tmp_disk_tables
Questions & Discussions - Topics about MySQL and related software. Thu, 15 March 2012 By: xaprb Tue, 10 April 2012Optimising MySql
Generaly you have a lot of mysql process that are sleeping because wait_timeout are not set low. So I make sure that the wait_timeout is set to a very low value: 15 seconds (for me) . That means MySQL would close any connection that was idle for more than 15 seconds. The problem is you also have to increment your max_connexion (mine is set to 300) to be sure there is not a lot of idle clients holding connections and blocking out new clients from connecting and getting real work done.
Finding what Created_tmp_disk_tables with log_slow_filter | MySQ
Log only the queries that followed certain execution plan. Multiple flags allowed in a comma-separated string. [qc_miss, full_scan, full_join, tmp_table, tmp_table_on_disk, filesort, filesort_on_disk] So now all I had to do was set the filter to “tmp_table_on_disk,filesort_on_disk†and I would get only those which use on-disk temporary storage for intermediate results.