[debian-mysql] Bug#976652: Bug#976652: mariadb-server-10.3: Could not increase number of max_open_files to more than 16384 (request: 32191)

[Richard van den Berg]

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