Question
lower InnoDB buffer pool on centos 8
Hi I had run into mysql crash issue , I would like to lower the InnoDB buffer pool.
but there is no setting inside /etc/my.cnf
I added innodbbufferpool_size = 20M insdide the my.cnf is not working.
my question is where is innodbbufferpool_size setting is ? and how I can change this setting thanks
how its done in ubuntu
https://www.digitalocean.com/community/questions/mysql-server-keeps-stopping-unexpectedly
this is what currently inside the /etc/my.cnf
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
innodb_buffer_pool_size = 20M
once i restart mysqld
Job for mysqld.service failed because the control process exited with error code.
See "systemctl status mysqld.service" and "journalctl -xe" for details.
its out of memory error
mmap(137363456 bytes) failed; errno 12
Cannot allocate memory for the buffer pool
thanks
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×