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 down every few hours, in log every time same errors, please help...

Discussion in 'General Discussion' started by x-man, Jun 1, 2006.

  1. x-man

    x-man Well-Known Member

    Joined:
    Jan 25, 2004
    Messages:
    118
    Likes Received:
    0
    Trophy Points:
    16
    Hi,
    in last few days my MySQL stoping to work and WHM starting again every few hours and I can`t find what is problem!
    Every time MySQL stoping to work after toooo much errors like this:

    060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529489 user: ''

    060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529488 user: ''

    060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529486 user: ''

    060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529485 user: ''

    060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529484 user: ''

    060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529472 user: ''

    060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529466 user: ''

    060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529465 user: ''

    060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529460 user: ''

    060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529459 user: ''

    060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529454 user: ''

    060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529453 user: ''

    060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529450 user: ''

    060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529446 user: ''

    060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529444 user: ''

    060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529441 user: ''

    060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529437 user: ''

    this killing MySQL, after restart again all working fine few hours (without errors like this) but after few hours again errors like this and again MySQL restart...somebody know why???

    This is on server with:
    mysql (4.0.27-standard)
    WHM 10.8.0 cPanel 10.8.1-S114
    RedHat Enterprise 4

    I must tell that ./mysqlup --force and ./upcp don`t helping to me!!!!

    What now? This is very very big problem for me because this MySQL server must be stable...

    Thanks.
     
  2. mOdY

    mOdY Well-Known Member

    Joined:
    Dec 25, 2004
    Messages:
    80
    Likes Received:
    0
    Trophy Points:
    6
    can you cat here your my.cnf? would be much easy to help you through
     
  3. x-man

    x-man Well-Known Member

    Joined:
    Jan 25, 2004
    Messages:
    118
    Likes Received:
    0
    Trophy Points:
    16
    OK, here is my.cnf but I must tell that all worked fine in past with this my.cnf:

    [mysqld]
    set-variable = max_connections=1000
    safe-show-database
    skip-innodb
    key_buffer = 150M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 1M
    read_buffer_size = 1M
    sort_buffer_size = 2M
    table_cache = 1024
    thread_cache_size = 80
    wait_timeout = 30
    connect_timeout = 10
    tmp_table_size = 32M
    max_allowed_packet = 16M
    max_connect_errors = 10000
    query_cache_limit = 1M
    query_cache_size = 32M
    query_cache_type = 1
    query_prealloc_size = 16384
    query_alloc_block_size = 16384

    [mysqld_safe]
    open_files_limit = 8192

    [mysqldump]
    quick
    max_allowed_packet = 16M

    [myisamchk]
    key_buffer = 64M
    sort_buffer = 64M
    read_buffer = 16M
    write_buffer = 16M
     
  4. jackie46

    jackie46 BANNED

    Joined:
    Jul 25, 2005
    Messages:
    537
    Likes Received:
    0
    Trophy Points:
    0

    my,cnf? It doesnt have anything to do with my.cnf at all.
     
Loading...

Share This Page