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:
    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.
     
    #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.
     
    #4 GOT, Jan 4, 2005
(You must log in or sign up to post here.)
Loading...
Similar Threads - Mysql error 'Too
  1. Leee-John

    Mysql process error log

    Leee-John, May 22, 2017, in forum: Database Discussions
    Replies:
    1
    Views:
    98
    cPanelMichael
    May 23, 2017
  2. willrijo

    Error upgrading mysql 5.5 to MariaDB 10.1

    willrijo, May 15, 2017, in forum: Database Discussions
    Replies:
    4
    Views:
    219
    rpvw
    May 16, 2017
  3. Terry Bogard

    Mysql error : Access denied for user '[cpaneluser]'@'localhost' (using password: NO)

    Terry Bogard, May 8, 2017, in forum: Database Discussions
    Replies:
    1
    Views:
    189
    cPanelMichael
    May 9, 2017
  4. Sametto Chan

    Mysqli statement execute error: Connection was killed

    Sametto Chan, May 5, 2017, in forum: Database Discussions
    Replies:
    6
    Views:
    205
    Sametto Chan
    May 29, 2017
  5. zambara

    Legacy backup restoration mysql error

    zambara, Apr 30, 2017, in forum: Data Protection
    Replies:
    2
    Views:
    230
    cPanelMichael
    May 2, 2017

Share This Page