Too many MySql connections

灰暗的星星灰暗的星星灰暗的星星灰暗的星星灰暗的星星
 
I had a few problems with a test site Im creating ive contacted the host and they have said
We have a limit of 10 concurrent MySQL connections and for database, it appears like you have exceeded the above limit and so you are receiving the error message. To over come by exceeding the maximum concurrent connections, please close all open connections in your script when there is no scope for fetching data from database?

The maximum number of concurrent MySQL connections per user is 10. The limits are based per database login, not Control Panel log in or MySQL CNAME. It’s solely based on database login i.e. if you have one username connecting to 50 databases, there will be 50 connections, per database. You should use mysql_close () to close a normal connection at the end of the script or else the session with the database will be kept open. If you are using mysql_pconnect(), then such persistent connections are closed when the script finishes.



Does anyone have any idea how or where im supposed to change those connections?
Top
 
User avatar
AMurray
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3853
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: Too many MySql connections

Post by AMurray » Fri Sep 26, 2014 1:52 am

It sounds like a third party extension is causing this (otherwise more people would report it if it were the Joomla core installation only.

Can you please provide additional information, such as:

1) Is this a clean install of Joomla (core only) or have you added third party extensions?

2) When did this error start occuring - has Joomla worked correctly at any point? Does this occur when accessing administrator or front-end of the site?


Suggested solutions:

1) Perhaps try disabling extensions until the error does not occur?

2) If you managed to find the trouble extension, ask the extension developer for assistance in providing a fix, or pointing you to the file required to change. Ask on the developer's website/forum etc if applicable.

3) Duplicate the installation of Joomla in a separate folder and database; if you can use Akeeba Backup then us it to backup and restore with Kickstart, otherwise use the stand-alone edition of Akeeba.

4) Install WAMPServer or equivalent on your PC and restore the site with Kickstart to your own computer. Your PC running Apache, MYsql, PHP won't be an exact match for your live host but it will determine if Joomla can run correctly without the error which could just mean the number of connections is set higher than your host's restrictions - doesn't exactly resolve the issue but points you in the right direction.
Regards,

提交评论


安全码
刷新

 

自1996年以来,公司一直专注于域名注册、虚拟主机、服务器托管、网站建设、电子商务等互联网服务,不断践行"提供企业级解决方案,奉献个性化服务支持"的理念。作为戴尔"授权解决方案提供商",同时提供与公司服务相关联的硬件产品解决方案。
 

联系方式

地址:河南省郑州市经五路2号

电话:0371-63520088 

QQ:76257322

网站:800188.com

电邮:该邮件地址已受到反垃圾邮件插件保护。要显示它需要在浏览器中启用 JavaScript。

微信:用企业微信联系