mysql 查询copy to tmp table造成堵塞

show full PROCESSLIST;

show VARIABLES like 'tmp_table_size' set GLOBAL tmp_table_size=629145600;

SHOW VARIABLES LIKE 'max_heap_table_size%'; SET GLOBAL max_heap_table_size=1073741824;

posted @ 2016-07-07 10:26  水晶糖  阅读(4312)  评论(0编辑  收藏  举报