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. ejde

    Error in MySQL upgrade from 5.6 to 5.7

    ejde, Aug 27, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    134
    cPanelMichael
    Aug 28, 2018
  2. LaLi

    mysqldump: [ERROR] unknown option '--skip-name-resolve'

    LaLi, Jul 28, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    135
    cPanelLauren
    Jul 30, 2018
  3. udee

    The system failed to drop the MySQL user error

    udee, Jul 14, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    140
    cPanelMichael
    Jul 16, 2018
  4. Sunlander

    MySQL Error in WHM Service Status Daily Process Log

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

    MySQLi - Too Many Connections Error due to Amazon AWS

    RobNH, Jun 21, 2018, in forum: Database Discussion
    Replies:
    5
    Views:
    174
    Infopro
    Jun 21, 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