Question
mysql crashes have to be restarted for it to work
Hey guys, i have a cloud 20GB plan its setup with nignx server and i have just one website hosted over it.
Its a wordpress based website and uses mysql for db. The traffic is not much just 200 to 500 visitors per day.
Its been 2 weeks (a little more) and mysql has crashed 3-4 times so far. Now i am bit worried about it as its a site which deals with e-comm hence i want to find a solution and a reason for it.
here is the error log:
140707 23:37:13 mysqld_safe Number of processes running now: 0
140707 23:37:13 mysqld_safe mysqld restarted
140707 23:37:13 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be rem
oved in a future release. Please use the full name instead.
140707 23:37:13 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and
will be removed in a future release. Please use the full name instead.
140707 23:37:13 [Note] Plugin 'FEDERATED' is disabled.
140707 23:37:13 InnoDB: The InnoDB memory heap is disabled
140707 23:37:13 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140707 23:37:13 InnoDB: Compressed tables use zlib 1.2.8
140707 23:37:13 InnoDB: Using Linux native AIO
140707 23:37:13 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
140707 23:37:13 InnoDB: Completed initialization of buffer pool
140707 23:37:13 InnoDB: Fatal error: cannot allocate memory for the buffer pool
140707 23:37:13 [ERROR] Plugin 'InnoDB' init function returned error.
140707 23:37:13 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140707 23:37:13 [ERROR] Unknown/unsupported storage engine: InnoDB
140707 23:37:13 [ERROR] Aborting
140707 23:37:13 [Note] /usr/sbin/mysqld: Shutdown complete
140707 23:37:13 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140707 23:56:08 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Its crashed on 23:37 and i restarted it on 23:56 thats 19 mins of down time :(
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×