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

[Olaf van der Spek]

Op vr 11 dec. 2020 om 12:22 schreef Faustin Lammler <faustin at fala.red>:
>
> > > syslog.6.gz:Dec  5 18:56:49 dev mysqld[694]: 2020-12-05 18:56:49 0 [Warning] Could not increase number of max_open_files to more than 16384 (request: 32183)
> Are you having this message too?

Yes, aren't you? ;)

> > Where does the 32183 come from? I don't see it in any conf file and it's not a value I'd set myself..
> So you grep /etc for this value? I have no idea where it could come
> from.

$ sudo grep -r 32183 /etc
$

Nothing

I think it's just the MariaDB default. I don't remember seeing the
warning before though, was it introduced in a security update?

> Can you maybe describe your setup so we can maybe find correlations with
> Richard's setup?
>
> Would that maybe come from a particular DB installation where this value
> is setup directly in the DB by the installer?

It's a Digital Ocean VM, initially installed as Debian 9 (or 8?), now 10.

I'll do a fresh Debian 10 install in a new VM to see if the warning
occurs there too.


-- 
Olaf