首页> 开发问题 >后端问题 后端问题
PHP查询报错, Fatal error: Allowed memory size of 134217728 bytes exhausted
作者:小萝卜 2019-04-09 【 PHP TP5 】 浏览 2193
简介PHP查询报错, Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 69632 bytes) in
PHP查询报错, Fatal error: Allowed memory size of 134217728 bytes exhausted
$time = time();
echo $time;
db('article')->where('id>0')->order('num asc,id desc')->limit(10000)->select();
$time1 = time();
echo $time1;
$stime = $time1-$time;
echo '查询主表10000条数据的时间'.$stime.' '; $otime = time();
echo $otime.;
db('article_bak')->where('id>0')->order('num asc,id desc')->limit(10000)->select(); $otime1 = time();
echo $otime1.;
$sotime = $otime1-$otime;
echo ' 查询之前表10000条数据的时间'.$sotime;
博主通过查询来测试两张表的性能时,终端报出了Allowed memory size of 134217728 bytes exhausted错误,而且重启电脑再次执行仍然是一样。上网查了查,是因为php默认内存限制是128M,所以需要修改php.ini文件。
1、打开php.ini,查找到memory_limit = 128M这一行,将128M改大点,我这里直接是改成了1048M。
2、重启服务器,通过sudo /usr/sbin/apachectl restart来重启apache服务器,当然其实用终端执行php的话,不重启服务器也是可以的。
3、重新执行php文件,成功,OK
很赞哦! (0)
相关文章
- 错误400-The request sent by the client was syntactically incorrect
- 使用mysql_list_tables()方法报错
- MYSQL5.7版本sql_mode=only_full_group_by报错解决方案
- laravel通过composer安装报错了The 'https://repo.packagist.org/p/laravel/laravel.json' file could not be downloaded: failed to open stream
- [vs code] 运行go包提示:Code is already running!
- Site error: the ionCube PHP Loader needs to be installed.
- windows下mysql中文乱码, 配置解决方法
- 语法解析错误: syntax error, unexpected 'unset' (T_UNSET)
- 网站打不开错误提示:ERR_CONTENT_DECODING_FAILED
- tp3.2插入数据时SQLSTATE[HY000]: General error