Community Forums
Connect with us on LinkedIn
Community Notice
+ Reply to Thread
Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    Jan 2004
    Posts
    101

    Angry MySQL down every few hours, in log every time same errors, please help...

    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. #2
    Member
    Join Date
    Dec 2004
    Posts
    80

    Default

    can you cat here your my.cnf? would be much easy to help you through

  3. #3
    Member
    Join Date
    Jan 2004
    Posts
    101

    Default

    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. #4
    BANNED
    Join Date
    Jul 2005
    Posts
    537

    Default

    Quote Originally Posted by #mOdY#
    can you cat here your my.cnf? would be much easy to help you through

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

Similar Threads & Tags
Similar threads

  1. Errors in MySQL Log regarding dbs/users that don't exist
    By sneader in forum cPanel and WHM Discussions
    Replies: 5
    Last Post: 06-12-2009, 10:21 AM
  2. Email send from webmail gives a time stamp 12 hours off.
    By BianchiDude in forum cPanel and WHM Discussions
    Replies: 0
    Last Post: 11-08-2007, 05:01 PM
  3. Server Time jumped forward 12 hours.
    By westhost-neil in forum cPanel and WHM Discussions
    Replies: 62
    Last Post: 11-04-2006, 05:18 PM
  4. 9 hours install time of cpanel?
    By edvalbuena in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 03-12-2006, 04:38 PM
  5. Logs rotate 2 hours too early, error log shows less than 300 errors
    By BianchiDude in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 09-02-2005, 06:23 PM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube