查询量一大经常出现502 bad Gateway-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

查询量一大经常出现502 bad Gateway

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 23, 2016 pm 01:55 PM

gatewayInquire

查了几百万条数据就直接nginx 502 Bad Gateway了。另一台服务器好好的。我不能登录服务器查看配置。请教各位弄过nginx+php的同志。你们服务器的设置都是啥样的？我发给硬件部的瞅瞅

回复讨论(解决方案)

502通常就是php-fpm歇菜了。这可能是由于fpm的连接数过大，或者程序的执行时间较长。
不过就凭你一句查了几百万条数据就直接nginx 502 Bad Gateway了。轻描淡写，没人能做到对症下药

内存不足，连接数太高，cpu满载以至于无法及时处理新连接，都可能导致这个502
就你这一句的确没办法知道具体情况

么有办法啊。服务器是硬件那边架设的，我去问情况没人鸟我··现在只能把数据拆分成一小块一小块的返回

你们技术部的也太菜了吧！一次查几百万的数据

我这刷新的时候也出现502，也是nginx+php ，，配置的时候nginx里面也有设置：访问时间（如下）等几个参数把这几个参数的时间  设置长一些，再一个可能是你在nginx 搭建的时候资源可能不够，希望对你有帮助！
我这是偶尔出现这种情况，让运维重启一下服务就行了

fastcgi_buffer_size           128k;
fastcgi_buffers             8 128k;
fastcgi_busy_buffers_size     128k;
fastcgi_temp_file_write_size  128k;

php慢了，nginx请求半天得不到回应，自然会超时。看看有没有timeout的配置，关于fastcgi的

fastcgi_connect_timeout 120;
   fastcgi_send_timeout 120;
   fastcgi_read_timeout 120;
   fastcgi_buffer_size 64k;
   fastcgi_buffers 4 64k;
   fastcgi_busy_buffers_size 128k;
   fastcgi_temp_file_write_size 128k;
   fastcgi_intercept_errors on;
服务器上的配置。一直没改过  不行哎

配置改一下（改大一些），服务重启一下也不行吗，记得 php里面也有这个参数，你看一下

都没用。我想是服务器设置的原因了。不改了。单方面改没用

这个....应该系统管理那边先查....他们查出是代码的问题才轮到你...

已经确定是服务器问题。。哎，无语

楼主能详细描述下吗？后来确认是服务器什么问题啊，怎么查出的？如何解决的？多谢啊！

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

How does PHP type hinting work, including scalar types, return types, union types, and nullable types?Apr 17, 2025 am 12:25 AM

PHP type prompts to improve code quality and readability. 1) Scalar type tips: Since PHP7.0, basic data types are allowed to be specified in function parameters, such as int, float, etc. 2) Return type prompt: Ensure the consistency of the function return value type. 3) Union type prompt: Since PHP8.0, multiple types are allowed to be specified in function parameters or return values. 4) Nullable type prompt: Allows to include null values and handle functions that may return null values.

How does PHP handle object cloning (clone keyword) and the __clone magic method?Apr 17, 2025 am 12:24 AM

In PHP, use the clone keyword to create a copy of the object and customize the cloning behavior through the \_\_clone magic method. 1. Use the clone keyword to make a shallow copy, cloning the object's properties but not the object's properties. 2. The \_\_clone method can deeply copy nested objects to avoid shallow copying problems. 3. Pay attention to avoid circular references and performance problems in cloning, and optimize cloning operations to improve efficiency.

PHP vs. Python: Use Cases and ApplicationsApr 17, 2025 am 12:23 AM

PHP is suitable for web development and content management systems, and Python is suitable for data science, machine learning and automation scripts. 1.PHP performs well in building fast and scalable websites and applications and is commonly used in CMS such as WordPress. 2. Python has performed outstandingly in the fields of data science and machine learning, with rich libraries such as NumPy and TensorFlow.

Describe different HTTP caching headers (e.g., Cache-Control, ETag, Last-Modified).Apr 17, 2025 am 12:22 AM

Key players in HTTP cache headers include Cache-Control, ETag, and Last-Modified. 1.Cache-Control is used to control caching policies. Example: Cache-Control:max-age=3600,public. 2. ETag verifies resource changes through unique identifiers, example: ETag: "686897696a7c876b7e". 3.Last-Modified indicates the resource's last modification time, example: Last-Modified:Wed,21Oct201507:28:00GMT.

Explain secure password hashing in PHP (e.g., password_hash, password_verify). Why not use MD5 or SHA1?Apr 17, 2025 am 12:06 AM

In PHP, password_hash and password_verify functions should be used to implement secure password hashing, and MD5 or SHA1 should not be used. 1) password_hash generates a hash containing salt values to enhance security. 2) Password_verify verify password and ensure security by comparing hash values. 3) MD5 and SHA1 are vulnerable and lack salt values, and are not suitable for modern password security.

PHP: An Introduction to the Server-Side Scripting LanguageApr 16, 2025 am 12:18 AM

PHP is a server-side scripting language used for dynamic web development and server-side applications. 1.PHP is an interpreted language that does not require compilation and is suitable for rapid development. 2. PHP code is embedded in HTML, making it easy to develop web pages. 3. PHP processes server-side logic, generates HTML output, and supports user interaction and data processing. 4. PHP can interact with the database, process form submission, and execute server-side tasks.

PHP and the Web: Exploring its Long-Term ImpactApr 16, 2025 am 12:17 AM

PHP has shaped the network over the past few decades and will continue to play an important role in web development. 1) PHP originated in 1994 and has become the first choice for developers due to its ease of use and seamless integration with MySQL. 2) Its core functions include generating dynamic content and integrating with the database, allowing the website to be updated in real time and displayed in personalized manner. 3) The wide application and ecosystem of PHP have driven its long-term impact, but it also faces version updates and security challenges. 4) Performance improvements in recent years, such as the release of PHP7, enable it to compete with modern languages. 5) In the future, PHP needs to deal with new challenges such as containerization and microservices, but its flexibility and active community make it adaptable.

Why Use PHP? Advantages and Benefits ExplainedApr 16, 2025 am 12:16 AM

The core benefits of PHP include ease of learning, strong web development support, rich libraries and frameworks, high performance and scalability, cross-platform compatibility, and cost-effectiveness. 1) Easy to learn and use, suitable for beginners; 2) Good integration with web servers and supports multiple databases; 3) Have powerful frameworks such as Laravel; 4) High performance can be achieved through optimization; 5) Support multiple operating systems; 6) Open source to reduce development costs.

See all articles