Report this

What is the reason for this report?

MySQL Daemon failed to start.

Posted on November 28, 2013

Recently I started working on a very basic Drupal website for a friend, by doing that it sadly seems that it has overloaded mysql. Can it really be that 1 Drupal install on a 512mb droplet eats up all the swap?

Anyway, I’m running CentOS with NginX, php-fpm, mysqld.

I’ve checked the mysqld.log and every time I try “service mysqld restart” this is what shows up in the log:


131128 22:05:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 131128 22:05:57 [Note] Plugin ‘FEDERATED’ is disabled. 131128 22:05:57 InnoDB: The InnoDB memory heap is disabled 131128 22:05:57 InnoDB: Mutexes and rw_locks use GCC atomic builtins 131128 22:05:57 InnoDB: Compressed tables use zlib 1.2.3 131128 22:05:57 InnoDB: Using Linux native AIO 131128 22:05:57 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 131128 22:05:57 InnoDB: Completed initialization of buffer pool 131128 22:05:57 InnoDB: Fatal error: cannot allocate memory for the buffer pool 131128 22:05:57 [ERROR] Plugin ‘InnoDB’ init function returned error. 131128 22:05:57 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed. 131128 22:05:57 [ERROR] Unknown/unsupported storage engine: InnoDB 131128 22:05:57 [ERROR] Aborting

131128 22:05:57 [Note] /usr/libexec/mysqld: Shutdown complete

131128 22:05:57 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

To my knowledge, it seems that it can’t load into swap or something similar to that, but I could be wrong.

Anyone know how I can solve this?

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Start building today

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.