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 Well-Known 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 Well-Known 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 Well-Known 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