优化相关参数： 

tmp_table_size

max_tmp_tables

max_heap_table_size

sort_buffer_size

max_length_for_sort_data

查看缓存表状态： 

show status like 'create%';

查看表锁争用状态： 

show status like 'table%';