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.

Backup MYSQL Too many connections

Discussion in 'General Discussion' started by hostserver, Jun 23, 2005.

  1. hostserver

    hostserver Active Member

    Joined:
    May 27, 2005
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    HI!
    Server A:
    WHM 10.1.0 cPanel 10.2.0-R82
    RedHat 9 i686 - WHM X v3.1.0
    Webhosting
    Server B:
    RedHat 9 i686
    Mysql 4.0.24-standard
    Database for webhosting

    Server A = 100Mb = Server B

    Server B:
    [root@domen root]# mysqladmin -u root processlist
    mysqladmin: connect to server at 'localhost' failed
    error: 'Too many connections'
    [root@domen root]

    service mysql stop
    ..... no stopped!!!

    killall -9 mysqld
    service mysql start
    Started OK.

    0 6 * * * /scripts/cpbackup
    Hangs only when it is started /scripts/cpbackup

    That do?
    thank you.
     
  2. nickb

    nickb Well-Known Member

    Joined:
    Feb 25, 2005
    Messages:
    347
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
  3. hostserver

    hostserver Active Member

    Joined:
    May 27, 2005
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Too many connections

    ......
    mysqld actually allows max_connections+1 clients to connect. The extra connection is reserved for use by accounts that have the SUPER privilege. By granting the SUPER privilege to administrators and not to normal users (who should not need it), an administrator can connect to the server and use SHOW PROCESSLIST to diagnose problems even if the maximum number of unprivileged clients are connected.

    ......

    [root@domen root]# mysqladmin -u root processlist
    mysqladmin: connect to server at 'localhost' failed
    error: 'Too many connections'
    [root@domen root]

    ????
     
  4. nickb

    nickb Well-Known Member

    Joined:
    Feb 25, 2005
    Messages:
    347
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    default value for max_connections is 100 try increasing this value..
     
  5. hostserver

    hostserver Active Member

    Joined:
    May 27, 2005
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    my.cnf
    ------------
    [mysqld]
    set-variable = wait_timeout=60
    set-variable = max_connections=900
    set-variable = max_connect_errors=10000
    set-variable = max_user_connections=100
    safe-show-database

    port = 3306
    socket = /var/lib/mysql/mysql.sock
    skip-locking
    key_buffer = 256M
    max_allowed_packet = 1M
    table_cache = 512
    sort_buffer_size = 1M
    read_buffer_size = 1M
    myisam_sort_buffer_size = 64M
    thread_cache = 8
    query_cache_size = 16M
    thread_concurrency = 2

    [safe_mysqld]
    open-files-limit=8192

    ----------------

    Today again there was too the most
    :confused:

    That do?
    thank you.
     
Loading...

Share This Page