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.

dbgovernor crashing mysql tables and requiring restores

Discussion in 'CloudLinux' started by fightforfreedom, Jan 31, 2013.

  1. fightforfreedom

    Joined:
    Jan 21, 2013
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    anyone else noticing mysql randomly crashing or tables becoming corrupt needing more advanced repairs?

    this is looking to be a common thing.

    Code:
    [mysqld]
    core-file
    default-storage-engine=MyISAM
    local-infile=0
    symbolic-links=0
    skip-networking
    max_connections = 500
    max_user_connections = 40
    key_buffer = 500M
    myisam_sort_buffer_size = 32M
    join_buffer_size = 256M
    read_buffer_size = 2M
    sort_buffer_size = 2M
    read_rnd_buffer_size = 2M
    table_cache = 1024
    thread_cache_size = 16K
    wait_timeout = 20
    connect_timeout = 10
    tmp_table_size = 256M
    max_heap_table_size = 256M
    max_allowed_packet = 160M
    max_connect_errors = 10
    query_cache_limit = 1M
    query_cache_size = 64M
    query_cache_type = 1
    low_priority_updates=1
    concurrent_insert=ALWAYS
    log-error=/var/log/mysql/error.log
    myisam_repair_threads=4
    [mysqld_safe]
    core-file-size = unlimited
    open_files_limit = 8192
    log-error=/var/log/mysql/error.log
    
    [mysqldump]
    quick
    max_allowed_packet = 512M
    
    [myisamchk]
    key_buffer = 64M
    sort_buffer = 64M
    read_buffer = 16M
    write_buffer = 16M
     
  2. iseletsk

    iseletsk Well-Known Member

    Joined:
    Mar 3, 2010
    Messages:
    163
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Princeton, New Jersey, United States
    Which version are you running?
    Could you submit a ticket to helpdesk.cloudlinux.com so our developers can take a look?
     
  3. fightforfreedom

    Joined:
    Jan 21, 2013
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    im running all the latest versions that you have.

    I noticed this before MySQL crashed:

     

Share This Page