0

I have a Centos 7 / MariaDB, 1gig DigitalOcean Droplet with 2 low traffic Wordpress sites on. When the server gets approx 15 concurrent users MySQL runs out of memory and drops. Log below:

180806 14:43:05 InnoDB: Fatal error: cannot allocate memory for the 
buffer pool
180806 14:43:05 [ERROR] Plugin 'InnoDB' init function returned error.
180806 14:43:05 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
180806 14:43:05 [Note] Plugin 'FEEDBACK' is disabled.
180806 14:43:05 [ERROR] Unknown/unsupported storage engine: InnoDB
180806 14:43:05 [ERROR] Aborting

180806 14:43:05 [Note] /usr/libexec/mysqld: Shutdown complete

So my question here is, what can i do to stop MySQL from dropping, Apache stays up fine. So hoping some handy configuration tweaks will resolve this for me :)

Cheers all!

devools
  • 1

1 Answers1

0

Your server has limited RAM and you are probably allocating way too much memory to MySQL connections. I would suggest to review MySQL configuration and reduce buffers size.

An easy way to verify MySQL configuration and memory allocation is to run mysqltuner or another free tool.

luigif
  • 156