问题描述
在同一系统中,我可以调用db,这没有问题,但是在某些情况下(使用最大的表),我得到了
In the same system, I can make call to db, and there is no problem, but in some case ( with the biggest table ), I get
我调试了代码,问题是一个基本查询:
I debugged the code and the problem is a basic query:
" SELECT partidascapturainfo.* FROM partidascapturainfo WHERE partidascapturainfo.partidascapturainfoid IS NOT NULL ORDER BY partidascapturainfoid asc LIMIT 0 , 10 "
当我在Mysql Client中运行查询时,查询运行时间为0.17s
When I run the query in a Mysql Client, query runs in 0.17s
我已经将memory_limit设置为2048,重新启动nginx,而我的查询仅返回10行...
I've already set memory_limit to 2048, restart nginx and my query only return 10 rows...
这是我的10行:
123044,42016,249,3762,2,,0
123045,42016,249,3761,2,,0
123046,42016,249,3764,1,,0
123047,42016,249,3765,,,0
123048,42016,249,3775,,,0
123049,42016,249,3771,3,,0
123050,42016,249,3772,3,,0
123051,42016,250,3844,HAY,,0
123052,42016,255,3852,,,0
123053,42017,249,3761,1,,0
有什么想法吗?
推荐答案
您可以尝试编辑/etc/php5/fpm/php.ini:
You can try editing /etc/php5/fpm/php.ini:
; Old Limit
; memory_limit = 512M
; New Limit
memory_limit = 2048M
您可能需要重新启动Nginx
You may need to restart nginx
您可能在某处也有无限循环.您可以张贴您正在调用的代码吗?
You may also have an infinite loop somewhere. Can you post the code you're calling?
这篇关于Laravel中允许的内存大小为536870912字节的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!