Mysql/mariadb increase innodb_buffer_pool_size

Support
1

NethServer Version: NS7
Module: mysql

hello everyone.
I have a query with the mysql configuration. I am using mariadb and I need to increase the innodb_buffer_pool_size parameter that by default of nethserver comes in 128Mb and I need to increase it to 4.7Gb.
I have tried many ways and it has not been possible

2

google: increase the innodb_buffer_pool_size parameter
2nd URL => https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-resize.html.

Michel-André

3

I have made the configuration through a terminal in mysql but it does not allow the size change since the parameter would not have write permission

I have used this command.
mysql> SET GLOBAL innodb_buffer_pool_size=…;

4

Hi @Eugenio_Melo1

You would need to run the command with the correct permissions (root user of mysql/mariadb).
This data can be found under /var/lib/nethserver/secrets/.

Another Option would be to install the PHPMyAdmin module from Stephdl
See here, there are several versions, depending on the MariaDB version you are using:

https://wiki.nethserver.org/doku.php?id=modules

These operate with the correct permissions.

My 2 cents
Andy

1 Like
5

I have made the configuration through a terminal in mysql but it does not allow the size change since the parameter would not have write permission

I have used this command.
mysql> SET GLOBAL innodb_buffer_pool_size= …;