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

[Olaf van der Spek]

Hi,

https://mariadb.com/kb/en/server-system-variables/#open_files_limit

> If set to 0, then MariaDB will calculate a limit based on the following:

> MAX(max_connections*5, max_connections +table_open_cache*2)

max_connections: 151
table_open_cache: 2000

This doesn't add up to 32186.

https://mariadb.com/docs/reference/mdb/system-variables/open_files_limit/

> SkySQL Analytical 10.5; Default: 32186

This however, is about the value we're seeing. Could the docs be out-of-date?

Grtz,

Olaf