Copying to tmp table SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' ORDER BY rand() LIMIT 9 Copying to tmp table SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' ORDER BY rand() LIMIT 9 Copying to tmp table SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' ORDER BY rand() LIMIT 9 Copying to tmp table SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' ORDER BY rand() LIMIT 9 Copying to tmp table SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' ORDER BY rand() LIMIT 9 Copying to tmp table SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' ORDER BY rand() LIMIT 9 Copying to tmp table SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' ORDER BY rand() LIMIT 9 Copying to tmp table SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' ORDER BY rand() LIMIT 9 Copying to tmp table SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' ORDER BY rand() LIMIT 9 Copying to tmp table SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' ORDER BY rand() LIMIT 9 Copying to tmp table SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' ORDER BY rand() LIMIT 9
经常出现大批量的copying to tmp table 和sort results 导致服务器负载过载,无法连接数据库,求解决方案
