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!

    Joined:
    Apr 8, 2003
    Messages:
    902
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Norfolk, 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. udee

    The system failed to drop the MySQL user error

    udee, Jul 14, 2018 at 4:11 AM, in forum: Database Discussion
    Replies:
    2
    Views:
    54
    cPanelMichael
    Jul 16, 2018 at 12:09 PM
  2. Sunlander

    MySQL Error in WHM Service Status Daily Process Log

    Sunlander, Jun 28, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    93
    cPanelMichael
    Jun 29, 2018
  3. RobNH

    MySQLi - Too Many Connections Error due to Amazon AWS

    RobNH, Jun 21, 2018, in forum: Database Discussion
    Replies:
    5
    Views:
    83
    Infopro
    Jun 21, 2018
  4. cosmin

    MySQL InnoDB errors after upgrade to 5.7

    cosmin, Jun 20, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    120
    cPanelMichael
    Jun 21, 2018
  5. Skin

    SOLVED MySQLMyMonLite Error 3167 feature is disabled?

    Skin, Jun 18, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    95
    Skin
    Jun 19, 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