Please expose more of the my.cnf options in the GUI

Feature Requests
1

I am requesting you expose the configuration options for the mariadb addon in the my-server.cnf file so I can tweak the memory settings. I have an 8gb RAM pi 4 I would like to dedicate more of the memory to mariadb to get better performance.
If I do it now, its a docker so my changes are reverted.

2

Please be specific about what options you need available. The addon is not going to provide an “insert your my.cnf file here” option as that’s not supportable. The addon devs can’t possibly test every combination of all the options mariadb makes available to ensure everything users can do works. But if you ask for specific options to be exposed in addon config, that is possible.

Alternatively if you just want to write your own my.cnf file then consider running a Mariadb container on another machine and having HA talk to it. Or copying the MariaDB addon to your own addon repo or the /addons folder and maintaining your own version with the my.cnf file you need.

3

Or copying the MariaDB addon to your own addon repo

I tried, but when I went to import it as a new add-on it said that it wasn’t a valid add-on.
Since the repo its self contains a dozen or so addons in total.

4

innodb_buffer_pool_size
innodb_log_file_size

I need to set both of these to 2gb

Or copying the MariaDB addon to your own addon repo or the /addons folder and maintaining your own version with the my.cnf file you need.

How do I do this?

5

metod 1
i found temporary solution i install phpmyadmin and set by sql

2GB

SET GLOBAL innodb_buffer_pool_size=(2 * 1024 * 1024 * 1024);
#32MB
SET GLOBAL query_cache_size=32777216;
SET GLOBAL query_cache_type = ON;

need to run again after restart

method 2
install Advanced SSH & Web Terminal addon

in terminal run
mariadb -e ‘SET GLOBAL innodb_buffer_pool_size=(2 * 1024 * 1024 * 1024)’
mariadb -e ‘SET GLOBAL query_cache_size=32777216’
mariadb -e ‘SET GLOBAL query_cache_type = ON’

need to run again after restart