MySQL Stop repeatedly

Hello community, i have 2 time this same error my database stop repeatedly. I would like troubleshooting without use systemctl restart mariadb
Why can be this issue?

181203 03:09:08 mysqld_safe Number of processes running now: 0
181203 03:09:08 mysqld_safe mysqld restarted
181203 3:09:08 [Note] /usr/libexec/mysqld (mysqld 5.5.60-MariaDB) > starting as process 9451 …
181203 3:09:08 [ERROR] mysqld: Out of memory (Needed 128917504 bytes)
181203 3:09:08 [ERROR] mysqld: Out of memory (Needed 96681984 bytes)
181203 3:09:08 InnoDB: The InnoDB memory heap is disabled
181203 3:09:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
181203 3:09:08 InnoDB: Compressed tables use zlib 1.2.7
181203 3:09:08 InnoDB: Using Linux native AIO
181203 3:09:08 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137756672 bytes) failed; errno 12
181203 3:09:08 InnoDB: Completed initialization of buffer pool
181203 3:09:08 InnoDB: Fatal error: cannot allocate memory for the buffer pool
181203 3:09:08 [ERROR] Plugin 'InnoDB' init function returned error.
181203 3:09:08 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
181203 3:09:08 [Note] Plugin 'FEEDBACK' is disabled.
181203 3:09:08 [ERROR] Unknown/unsupported storage engine: InnoDB
181203 3:09:08 [ERROR] Aborting

181203 3:09:08 [Note] /usr/libexec/mysqld: Shutdown complete

181203 03:09:08 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended

2 Replies

181203 3:09:08 [ERROR] mysqld: Out of memory (Needed 128917504 bytes)
181203 3:09:08 [ERROR] mysqld: Out of memory (Needed 96681984 bytes)

You're running out of memory.

I wanted to jump into the conversation because I've worked with other users who've had the same issue with running out of memory.

We've put together a handy guide for troubleshooting memory issues, and I'll link you right to the part of that guide that discusses MySQL:

https://www.linode.com/docs/troubleshooting/troubleshooting-memory-and-networking-issues/#mysql-low-memory-settings

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct