Topic: MySQL did not start under load

CentOS 6.7
mysql-5.5.38-1.el6.remi.x86_64

If I stop mysqld and then try to start I receive this error.

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

If I stop my monitoring system(zabbix) which write to db, I can start mysqld successfuly.

Is it possible to do somthing?

Re: MySQL did not start under load

> If I stop my monitoring system(zabbix) which write to db, I can start mysqld successfuly.

Seems the better/simpler way.

Perhaps you should try to update to latest version which is 5.5.47.

It's also a good idea to not stop mysql, and keep it running, so it can keep statistics and improve perf (which are lost on restart).

Sorry, no other idea...

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Re: MySQL did not start under load

It seems I found problem.
innodb_buffer_pool_size = 3G
with only 1.6G of swap
I decrease innodb_buffer_pool_size  to 1G and restart stay stable.
Now I think about increase swap space, I believe it would be better solution.

Re: MySQL did not start under load

> Now I think about increase swap space, I believe it would be better solution.

If you go to swap, you will have perf issues.

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi