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
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.
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.
It could be in another file under /etc/mysql/conf.d/, try Code: grep -R innodb_buffer_pool_size /etc/mysql/ If you don't find it at all, it looks like it defaults to 128M (at least in mysql 5.5): http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_buffer_pool_size
hope this helps... Code: root@isp1:~# 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
