hi, I installed ispconfig 3 with apache over centos 7 , my question is how to change the value of innodb_buffer_pool_size for mariadb, even though I do the following: I am trying to increase innodb_buffer_pool_size for mariadb by 2 ways and failed 1. i add the following line under [mysqld] in /etc/my.cnf Code: innodb_buffer_pool_size = xxxxxxxxx #(in bytes) but failed to restart mariadb service and got this message Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. 2. I execute this command at mysql bash Code: MariaDB [(none)]> SET GLOBAL innodb_buffer_pool_size= xxxxxxxxx; and failed with this error message ERROR 1238 (HY000): Variable 'innodb_buffer_pool_size' is a read only variable thanks.
Try Internet Search Engines with Code: site:howtoforge.com How to Change innodb_buffer_pool_size using MariaDB?
Run "systemctl status mariadb.service" and/or "journalctl -xe" to see the error, maybe you had a typo or something. That is expected behavior, you must set that variable in my.cnf.
I don't see any useful error in that offhand, try 'journalctl -xe' and/or look at log files to see what might be found. Maybe in /var/log/syslog (or whatever log filenames centos uses) or /var/log/mariadb/mariadb.log. If you comment out that line in my.cnf it does start up correctly? Maybe paste the full my.cnf here?
thanks for replay I finally I found the solution, its about the size of memory, the innodb_buffer_pool_size option is MUST -I thought that this is as recommended- be less than 2/3 of total memory size.