Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Mysql error: 'Too many connections'

Discussion in 'General Discussion' started by CamronFry, Jan 4, 2005.

  1. CamronFry

    CamronFry BANNED

    Joined:
    Jan 1, 2005
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    156
    How can I get mysql to support more connections?
    # mysqladmin processlist
    mysqladmin: connect to server at 'localhost' failed
    error: 'Too many connections'
     
    #1 CamronFry, Jan 4, 2005
  2. kris1351

    kris1351 Well-Known Member

    Joined:
    Apr 18, 2003
    Messages:
    963
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Lewisville, Tx
    Do a search for mysyql tuning will provide you with some good templates for starting your tuning process. By default there isn't much defined in most mysql setups. Look in /etc/my.cnf and up the max connections. If it isn't there then find one of the templates here that people have posted and adjust it to fit your needs.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 kris1351, Jan 4, 2005
  3. CamronFry

    CamronFry BANNED

    Joined:
    Jan 1, 2005
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    156
    If I have a bunch of sleeping queries from the same user does that mean they are using persistant mysql connections?
     
    #3 CamronFry, Jan 4, 2005
  4. GOT

    GOT Get Proactive!
    PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,021
    Likes Received:
    34
    Trophy Points:
    178
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    Yes, that is what that means.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 GOT, Jan 4, 2005
(You must log in or sign up to post here.)
Loading...
Similar Threads - Mysql error 'Too
  1. lahmar amine

    New Thread mysql error

    lahmar amine, Nov 17, 2018 at 3:56 PM, in forum: Database Discussion
    Replies:
    0
    Views:
    26
    lahmar amine
    Nov 17, 2018 at 3:56 PM
  2. cPanelAlex

    SOLVED [Defect] MySQL Connection Failures and 500 Errors; CloudLinux + Imunify360

    cPanelAlex, Nov 15, 2018 at 6:45 AM, in forum: General Discussion
    Replies:
    2
    Views:
    540
    HostXNow_Chris
    Nov 15, 2018 at 12:17 PM
  3. ronaldst

    SOLVED MySQL errors - password and plugin authentication specified

    ronaldst, Nov 7, 2018, in forum: Database Discussion
    Replies:
    5
    Views:
    94
    cPanelLauren
    Nov 9, 2018
  4. maestroc

    sqlite and pdo_mysql errors after Apache 4 upgrade

    maestroc, Oct 3, 2018, in forum: EasyApache
    Replies:
    1
    Views:
    91
    cPanelLauren
    Oct 8, 2018
  5. Deker

    mysql-connectors-community No more mirrors to try error

    Deker, Sep 30, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    173
    cPanelLauren
    Oct 4, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice