MariaDB Crashing ( mysqld: Out of memory ) But its not...

Issues related to applications and software problems
Post Reply
lynxus
Posts: 26
Joined: 2009/10/17 10:23:06
Contact:

MariaDB Crashing ( mysqld: Out of memory ) But its not...

Post by lynxus » 2014/11/10 14:37:19

Hi guys, My mysql / mariadb is crashing..
It starts up fine afterwards, but is meaning my site is offline until I notice..

Anyone got any pointers here?
Disc space = plenty..
Ram = loads free..

I cant see whats crashing it.. Its only wordpress thats installed and using it..

141110 8:46:27 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137756672 bytes) failed; errno 12
141110 8:46:27 InnoDB: Completed initialization of buffer pool
141110 8:46:27 InnoDB: Fatal error: cannot allocate memory for the buffer pool
141110 8:46:27 [ERROR] Plugin 'InnoDB' init function returned error.
141110 8:46:27 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
141110 8:46:27 [ERROR] mysqld: Out of memory (Needed 128917504 bytes)
141110 8:46:27 [ERROR] mysqld: Out of memory (Needed 96681984 bytes)
141110 8:46:27 [ERROR] mysqld: Out of memory (Needed 72499200 bytes)
141110 8:46:27 [Note] Plugin 'FEEDBACK' is disabled.
141110 8:46:27 [ERROR] Unknown/unsupported storage engine: InnoDB
141110 8:46:27 [ERROR] Aborting

141110 8:46:27 [Note] /usr/libexec/mysqld: Shutdown complete

lynxus
Posts: 26
Joined: 2009/10/17 10:23:06
Contact:

Re: MariaDB Crashing ( mysqld: Out of memory ) But its not.

Post by lynxus » 2014/11/10 15:16:03

Grr ignore me.


Clearly I ran out of memory.

Annoyingly, the VPS i have didnt have a swap partition created, so by throwing a 1G swap seems to work fine now ( the server has SSD's anyway, so swap is pretty fast )

aks
Posts: 3073
Joined: 2014/09/20 11:22:14

Re: MariaDB Crashing ( mysqld: Out of memory ) But its not.

Post by aks » 2014/11/10 16:57:30

Yeah but that's probably the innodb cache and memory is still faster than SSD.

Post Reply