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: