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 crashes or restart every 500 seconds

Discussion in 'General Discussion' started by alexd, Nov 11, 2004.

  1. alexd

    alexd Well-Known Member
    PartnerNOC

    Joined:
    Dec 30, 2003
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    6
    Hi:

    I see in the .err log of mysql this:

    PHP:
    041111 22:22:45  mysqld started
    041111 22
    :22:45 WarningAsked for 196608 thread stackbut got 126976
    /usr/sbin/mysqldready for connections.
    Version'4.0.22-standard-log'  socket'/var/lib/mysql/mysql.sock'  port3306  Official MySQL RPM
    041111 22
    :31:07 /usr/sbin/mysqldNormal shutdown

    041111 22
    :31:08 /usr/sbin/mysqldShutdown Complete

    041111 22
    :31:08  mysqld ended

    041111 22
    :31:09  mysqld started
    041111 22
    :31:09 WarningAsked for 196608 thread stackbut got 126976
    /usr/sbin/mysqldready for connections.
    Version'4.0.22-standard-log'  socket'/var/lib/mysql/mysql.sock'  port3306  Official MySQL RPM
    041111 22
    :39:37 /usr/sbin/mysqldNormal shutdown

    041111 22
    :39:38 /usr/sbin/mysqldShutdown Complete

    041111 22
    :39:38  mysqld ended

    041111 22
    :39:39  mysqld started
    041111 22
    :39:39 WarningAsked for 196608 thread stackbut got 126976
    /usr/sbin/mysqldready for connections.
    Version'4.0.22-standard-log'  socket'/var/lib/mysql/mysql.sock'  port3306  Official MySQL RPM
    041111 22
    :40:46 /usr/sbin/mysqldNormal shutdown

    041111 22
    :40:47 /usr/sbin/mysqldShutdown Complete

    041111 22
    :40:47  mysqld ended

    041111 22
    :40:48  mysqld started
    041111 22
    :40:48 WarningAsked for 196608 thread stackbut got 126976
    /usr/sbin/mysqldready for connections.
    Version'4.0.22-standard-log'  socket'/var/lib/mysql/mysql.sock'  port3306  Official MySQL RPM
    041111 22
    :48:01 /usr/sbin/mysqldNormal shutdown

    041111 22
    :48:02 /usr/sbin/mysqldShutdown Complete

    041111 22
    :48:02  mysqld ended

    041111 22
    :48:04  mysqld started
    041111 22
    :48:04 WarningAsked for 196608 thread stackbut got 126976
    /usr/sbin/mysqldready for connections.
    Version'4.0.22-standard-log'  socket'/var/lib/mysql/mysql.sock'  port3306  Official MySQL RPM

    It's every 500 seconds... but i don't have ANY 500 number in the my.cnf...
    Here it is...

    PHP:
    [mysqld]
    skip-innodb
    innodb_data_file_path 
    ibdata1:10M:autoextend:max:1900M
    innodb_flush_log_at_trx_commit
    =1
    innodb_lock_wait_timeout
    =50
    innodb_buffer_pool_size
    =200M
    innodb_additional_mem_pool_size
    =50M

    connect_timeout
    =100
    interactive_timeout
    =100
    join_buffer
    =1M
    key_buffer 
    384M
    key_buffer
    =16M
    log
    -bin
    max_allowed_packet
    =16M
    max_connect_errors
    =10
    max_connections
    =1000
    myisam_sort_buffer_size
    =64M
    query_cache_limit 
    1M
    query_cache_size 
    32M
    query_cache_type 
    1
    read_buffer_size
    =2M
    record_buffer
    =1M
    safe
    -show-database
    server
    -id=1
    skip
    -locking
    socket
    =/var/lib/mysql/mysql.sock
    sort_buffer_size
    =2M
    table_cache
    =1024
    thread_cache 
    8
    thread_cache_size
    =128
    thread_concurrency 
    4
    thread_stack
    =192k
    wait_timeout
    =100

    [mysqldump]
    quick
    max_allowed_packet 
    16M

    [mysql]
    no-auto-rehash
    # Remove the next comment character if you are not familiar with SQL
    #safe-updates

    [isamchk]
    key_buffer 256M
    sort_buffer_size 
    256M
    read_buffer 
    2M
    write_buffer 
    2M

    [myisamchk]
    key_buffer 256M
    sort_buffer_size 
    256M
    read_buffer 
    2M
    write_buffer 
    2M

    [mysqlhotcopy]
    interactive-timeout

    So... what can it be ?

    By the way... it's amazing, but althought I have the skip-innodb variable... the innodb is still working :P
     
  2. alexd

    alexd Well-Known Member
    PartnerNOC

    Joined:
    Dec 30, 2003
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    6
    I have upgraded to last current version (4.0.22) and still doing the same...
    any ideas?
     
  3. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
    My guess would be that chkservd is restarting it because it can't connect. Check /var/log/chkservd.log for the reason.
     
  4. alexd

    alexd Well-Known Member
    PartnerNOC

    Joined:
    Dec 30, 2003
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    6
    Your guess comes true :)
    thank you
     
  5. SACHIN

    SACHIN Guest

    mysql restarted every 120 sec.

    hello.

    we are getting same error we have checkd /var/log/chkservd.log but no luck..
    how to fix????


    :confused:
     
Loading...

Share This Page