真让我呆住了, 我怎写成这语句,一下子没想到,发现limit 怎没了,我以直以为有, 啊。。。难怪叫内存不
select a.domainid, a.domain, a.registerdate, a.expireddate, b.resellername, e.name, e.username, a.reserved, a.isalexa,a.isseo,d.statusname, a.domainid FROM domain a left join domain_reseller b on a.resellerid = b.resellerid left join domain_status d on a.statusid = d.statusid left join user e on a.designerid=e.userid where a.statusid IN ('1' ,'1' )
这条语名句问题还在,重复值也要去掉。。
改成:
select a.domainid, a.domain, a.registerdate, a.expireddate, b.resellername, e.name, e.username, a.reserved, a.isalexa,a.isseo,d.statusname, a.domainid FROM domain a left join domain_reseller b on a.resellerid = b.resellerid left join domain_status d on a.statusid = d.statusid left join user e on a.designerid=e.userid where a.statusid IN ('1' )
这怎写的语句,我的limit 呢, 难怪叫。。。内存不,
Allowed memory size of xxx bytes exhausted at xxx:xxx (tried to allocate xxx bytes)
我查了半天都没想到自己SQL错了,因为当时以为有limit
这小错成了大错, 导致整个程序不能用, 眼睛花了一下,
当警告内存不够时:
(1) 检查SQL语句没问题,要确定
(2)检查php.ini memory_limit给的空间也够用,
其他就暂时没遇到。。