show processlist;
show full processlist;
find Converting HEAP to MyISAM and Copying to tmp table on disk in processlist
SHOW GLOBAL STATUS LIKE 'Created_tmp_tables';
SHOW GLOBAL STATUS LIKE 'Created_tmp_disk_tables';
show variables like "tmp_table_size";
show variables like "max_heap_table_size ";
http://www.mysqlab.net/knowledge/kb/detail/topic/myisam/id/6149
http://www.cnblogs.com/sunss/archive/2011/01/10/1932004.html
http://www.orczhou.com/index.php/2010/01/mysql-slow-log-1/