• Too many MySql connections

    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年,是经工商行政管理局批准的专业互联网络公司。公司经营范围主要包括政府、企业和事业单位上网工程、计算机网络工程、域名注册、虚拟主机、beplay体育在线建设、电子商务和互联网增值服务等。

    联系方式

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

    电话:0371-63520088 

    QQ:76257322

    beplay体育在线:www.800188.com

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