mysql 查询 卡死_查询数据超过10000条的时候,数据库就卡死.

CREATE TEMPORARY TABLE tmp_table2

select isname,sex,isage,'3',telphone,g.illid,a1.mediaid,a2.doctorid,ordertime,remark,

edittime,state,a3.ysid,usertype,a4.kefuid,addtime,visittime,1,0,askedinfo,a4.kefuid as userid from yuyue2014.sickinfo as b

inner join yyghsys.gh_ill as g on g.illname=b.istype

inner join yyghsys.gh_media as a1 on a1.medianame=b.infofrom

inner join yyghsys.gh_doctor as a2 on a2.doctorname=b.zhuanjia

inner join yyghsys.mz_ys as a3 on a3.ysname=b.admit

inner join yyghsys.gh_kefu as a4 on a4.kefuname=b.kefu

where a1.hosid=1 and a2.hosid=1 and a3.hosid=1 and a4.hosid=1 limit 10000,5000;

这是我的SQL,我用临时表,当数据从10000开始的时候,查询就卡死.不知道为什么.