Server suddenly problem
my server: Release 8.0.0.GA.5434.UBUNTU12.64 UBUNTU12_64 FOSS edition, memory: 2GB
Have been running about 1-2 month, there was no problem. Today there was a problem with log like this:
130128 13:03:32 mysqld_safe Starting mysqld daemon with databases from /opt/zimbra/db/data
130128 13:03:32 InnoDB: The InnoDB memory heap is disabled
130128 13:03:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130128 13:03:32 InnoDB: Compressed tables use zlib 18.104.22.168
130128 13:03:32 InnoDB: Initializing buffer pool, size = 1.1G
InnoDB: mmap(1240563712 bytes) failed; errno 12
130128 13:03:32 InnoDB: Completed initialization of buffer pool
130128 13:03:32 InnoDB: Fatal error: cannot allocate memory for the buffer pool
130128 13:03:32 [ERROR] Plugin 'InnoDB' init function returned error.
130128 13:03:32 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130128 13:03:32 [ERROR] Unknown/unsupported storage engine: InnoDB
130128 13:03:32 [ERROR] Aborting
130128 13:03:32 [Note] /opt/zimbra/mysql/bin/mysqld: Shutdown complete
130128 13:03:32 mysqld_safe mysqld from pid file /opt/zimbra/db/mysql.pid ended
mysql.server is not running.
i have follow mysql crash on wiki, after follow that wiki server running well, but in 5 minutes next, the server crash again. I don't know what is the problem cause.
Thank you for help, i appreciate your help.
1. From your services log, you have memcached services running? Memcached not required for single server. You should disable memcached and proxy for single server
2. How about increasing the memory from 2 GB into 4 GB or more due to this log : Fatal error: cannot allocate memory for the buffer pool.
Thank you Mr. Vavai.
thank you for your feedback, i will try your suggestion (memcached i have install and i will increase the memory)
i appreciate that