Hello I’ve InnoDB buffer pool size error. And ı must decrease its value.
But How can I do this? What can I change on my system? What is the file directory etc.
Could u hlep me please?
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.
Click below to sign up and get $100 of credit to try our products over 60 days!
@cagkana9f5cd873f5b8188e469
On CentOS, your MySQL/MariaDB configuration directory is located here:
In that directory there’s a file called
server.cnf
which is where you’dset or modify that variable. By default, onmariadb
when installed withyum
, that file doesn’t contain any specific config so you’d need to define it yourself.I’d take a look at the following to make sure it’s set correctly as there’s some useful information that applies to modifying those specific variables.