MySQL chashes almost every day

Discussion in 'General' started by telvenes, Jun 28, 2016.

  1. telvenes

    telvenes Member

    Like i sad, my Mysql server crashing somethimes every day and sometimes once a week, and somethimes once a month.

    today i saw this in mysql.log
    140124 17:29:01 InnoDB: Completed initialization of buffer pool 140124 17:29:01 InnoDB: Fatal error: cannot allocate memory for the buffer pool 140124 17:29:01 [ERROR] Plugin 'InnoDB' init function returned error. 140124 17:29:01 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140124 17:29:01 [ERROR] Unknown/unsupported storage engine: InnoDB 140124 17:29:01 [ERROR] Aborting 140124 17:29:01 [Note] /usr/sbin/mysqld: Shutdown complete

    I have installed my server folowing the totorial on this site for ubuntu
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    I guess the she server has not enough ram.
     
  3. telvenes

    telvenes Member

    anything i can check? i have 3gb ram
     
  4. telvenes

    telvenes Member

    Do i have a memory leak?

    First i had 2gb ram then i upgraded to 3gb...

    or is this a solution?
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    Install munit and monin to check your server and restart services when nescessary.
     
  6. Jesse Norell

    Jesse Norell Active Member

    Do you have any swap space, or just physical ram? Add some swap space if you don't have any. Also see what innodb_buffer_pool_size is set to and reduce it if it's quite large.
     
  7. telvenes

    telvenes Member

    Code:
                 total       used       free     shared    buffers     cached
    Mem:          2997       2353        644        378         27       1242
    -/+ buffers/cache:       1083       1914
    Swap:          379          0        379
    
    cant find "innodb_buffer_pool_size" in my.cnf

    This starting to be a big problem for me now.
     
  8. Jesse Norell

    Jesse Norell Active Member

  9. telvenes

    telvenes Member

    Any suggestions to what i can do? last 3 days it has crashed up from 1 to 2 times a day
     
  10. telvenes

    telvenes Member

     
  11. Jesse Norell

    Jesse Norell Active Member

    Try increasing that 379M of swap (to around 2G - 4G)
     
  12. telvenes

    telvenes Member

    hope this helps...
    Code:
    [email protected]:~# free -h
                  total        used        free      shared  buff/cache   available
    Mem:           2.9G        971M        1.4G         62M        542M        1.9G
    Swap:          4.4G          0B        4.4G
    
     
  13. telvenes

    telvenes Member

    upgraded also to 16.04 mabey that helps also
     

Share This Page