mysql占用大量CPU

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/