The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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:
    0
    How can I get mysql to support more connections?
    # mysqladmin processlist
    mysqladmin: connect to server at 'localhost' failed
    error: 'Too many connections'
     
  2. kris1351

    kris1351 Well-Known Member

    Joined:
    Apr 18, 2003
    Messages:
    963
    Likes Received:
    0
    Trophy Points:
    16
    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.
     
  3. CamronFry

    CamronFry BANNED

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

    GOT Get Proactive!

    Joined:
    Apr 8, 2003
    Messages:
    900
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Norfolk, VA
    cPanel Access Level:
    DataCenter Provider
    Yes, that is what that means.
     
Loading...

Share This Page