Hi Faustin, On 07/12/2020 18:56, Faustin Lammler wrote:
This can not be considered as a bug and you are asking to make default an increase of the max_open_files option because your setup needs it.
This is a very small home server with only 2 databases and 2 users. I assumed this was a general warning, not a parameter that needs tuning for my particular setup.
Why not consider instead overriding the systemd unit default option with what you think is the best value for your setup?
I did and set it to 32191 as recommended by the warning.
If you really think that this value should be increased and become the default value for every MariaDB default installation, then I suggest you open an issue directly upstream (https://jira.mariadb.org):
Ok, so the 16384 limit in /lib/systemd/system/mariadb.service is actually the default from upstream? That seems odd to me as it warns it needs more in a simple small setup like mine. I suppose that mariadb asking for more open files is the bug here then. I'll open it upstream if it persists.
Kind regards, Richard
