increase innodb_buffer_pool_size mariadb

Discussion in 'Installation/Configuration' started by etken, Nov 9, 2019 at 9:30 PM.

  1. etken

    etken New Member

    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
    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
    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

  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Try Internet Search Engines with
    Code: How to Change innodb_buffer_pool_size using MariaDB?
  3. etken

    etken New Member

    I tried before posting...
    thanks for replay, but it not helping me
  4. Jesse Norell

    Jesse Norell Well-Known Member

    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.

Share This Page