如何解决508资源限制在PHP MySQL中达到 [英] How to fix 508 Resource Limit is reached in PHP MySQL

问题描述

如何修复 PHP MySQL

How to fix 508 Resource Limit is reached in PHP MySQL

• 我的网站是使用MySQL和javascript ajax在PHP中开发的.
• 我的网站已被封锁，
• 如何立即纠正此问题，任何人都可以快速帮助我请.

但是出现了以下错误

Resource Limit Is Reached

The website is temporarily unable to service your request as it exceeded resource limit. Please try again later.
Apache/2.4.12 (Unix) OpenSSL/1.0.1e-fips mod_bwlimited/1.4 Server at domain.co.in Port 80

• 什么是并发连接
• 如何设置与MySQL的最大并发连接数
• 任何解决此问题的方法

推荐答案

什么是数据库并发连接?

并发连接是同时建立到数据库的连接.

Concurrent connections are the connections which are made simultaneously to the database.

在共享主机上，存在一些限制.根据您的提供者，它可能会振荡.每次访问者进入您的网站时，都会建立与数据库的连接(如果该网页已连接到mysql).

On shared hosting, there are some limits. Depending on your provider it could oscilate. Every time a visitor enters on your website, then it makes a connection to the database (if the webpage is connected to mysql).

因此，如果有一些访问者同时访问该网站，则数据库连接数将与访问者一样多.

So, if there are some visitors accessing the website at same time, there would be as many db connections as visitors.

在大多数情况下，托管服务提供商会说对连接有限制(未指定数据库")，这与HTML进程有关.

如何增加并发连接数?

如果拥有VPS或专用服务器，则可以转到MySQL服务器并更改 max_concurrent_connections .如果您使用共享主机，则很可能无法.

If you have a VPS or dedicated, then you can go to your MySQL server and change max_concurrent_connections. If you are on shared hosting most probably you cannot.

我该怎么办?

您的托管服务提供商会告诉您升级到VPS或其他功能更强大的计划，其价格要比共享托管更为昂贵.

Your hosting provider will tell you to upgrade to VPS or other more-power plan with is more expensive than a Shared Hosting.

我不建议您购买VPS.我建议您更改托管服务提供商.

I would not recommend you to buy a VPS yet. I would recommend you to change your hosting provider.

请提供您的网站网址，托管位置，计划，以帮助您更好.

这篇关于如何解决508资源限制在PHP MySQL中达到的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！