increase innodb_buffer_pool_size mariadb

Discussion in 'Installation/Configuration' started by etken, Nov 9, 2019.

  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 Staff Member Howtoforge Staff

    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.
  5. etken

    etken New Member

    thanks for replay,
    this is the output of
    systemctl status mariadb.service
  6. Jesse Norell

    Jesse Norell Well-Known Member Staff Member Howtoforge Staff

    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?
  7. etken

    etken New Member

    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.

Share This Page