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.

Innodb crashing again and again

Discussion in 'Workarounds and Optimization' started by ravijas, Dec 19, 2014.

  1. ravijas

    ravijas Member

    Joined:
    Jul 24, 2014
    Messages:
    13
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    Hello,

    We are facing issue with mysql-innodb. Innodb crashing 2/3 times in a month on a server. My.cnf is as follows.

    Code:
    [mysqld]
    performance_schema=off
    default-storage-engine=MyISAM
    skip-external-locking
    key_buffer_size=3G
    max_allowed_packet=8M
    max_connections=350
    max_user_connections=25
    wait_timeout=40
    connect_timeout=10
    table_cache=2048
    join_buffer_size=512K
    sort_buffer_size=2M
    read_buffer_size=2M
    read_rnd_buffer_size=8M
    myisam_sort_buffer_size=64M
    thread_cache_size=128
    query_cache_size=128M
    tmp_table_size=256M
    max_heap_table_size=256M
    server-id = 1
    innodb_fast_shutdown=0
    innodb_buffer_pool_size=2G
    innodb_file_per_table=1
    open_files_limit=50000
    
    [mysqldump]
    quick
    max_allowed_packet = 16M
    
    [mysql]
    no-auto-rehash
    
    [myisamchk]
    key_buffer = 256M
    sort_buffer_size = 256M
    read_buffer = 2M
    write_buffer = 2M
    
    [mysqlhotcopy]
    interactive-timeout
    
    Code:
    Server/WHM version
    WHM 11.46.1
    CloudLinux Server release 5.11
    x86_64
    Please help us to stop such issue and the possible reasons to crash the innodb?

    Thanks,

    RaviJas.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,787
    Likes Received:
    665
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  3. ravijas

    ravijas Member

    Joined:
    Jul 24, 2014
    Messages:
    13
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    Hi,

    Logs:

     
  4. cPanelPeter

    cPanelPeter Technical Analyst III
    Staff Member

    Joined:
    Sep 23, 2013
    Messages:
    569
    Likes Received:
    15
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Twitter:
  5. ravijas

    ravijas Member

    Joined:
    Jul 24, 2014
    Messages:
    13
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    Hi,

    Yes we can repair it no doubt, but its happening 3/4 time in a month. Thats our problem.
    Why this is happening? Also seen many recent post with the same issue on the forum.

    Not sure what exactly going with mysql 5.5 version.

    Thanks,

    Ravijas.
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,787
    Likes Received:
    665
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page