Thanks Olaf, your help is very appreciated!
Can I kindly ask you to open an issue directly on jira.mariadb.org then
(and forward this BR when it's open).
I have already searched for such issue on jira but nothing cames out.
Regards,
Faustin
signature.asc
Description: PGP signature
Hi Olaf!
Olaf van der Spek ,
11/12/2020 – 14:21:16 (+0100):
> 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?
This can of course happen, I'll
Olaf van der Spek ,
11/12/2020 – 13:11:40 (+0100):
> Package: mariadb-server-10.3
> Version: 1:10.3.27-0+deb10u1
> Followup-For: Bug #976652
>
> Dear Maintainer,
>
> Fresh Debian 10 install, fresh mariadb-server install:
>
> # zgrep max_open_files syslog*
>
> Dec 11 13:08:46 xyz mysqld[1695]:
Olaf van der Spek ,
11/12/2020 – 12:35:37 (+0100):
> Yes, aren't you? ;)
Nope :-)
> I think it's just the MariaDB default. I don't remember seeing the
> warning before though, was it introduced in a security update?
No idea. But as you can see on a previous message, this is still the
same value
Op vr 11 dec. 2020 om 12:22 schreef Faustin Lammler :
>
> > > 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? ;)
> >
Hi Olaf!
Olaf van der Spek ,
11/12/2020 – 11:50:53 (+0100):
> Package: mariadb-server-10.3
> Version: 1:10.3.27-0+deb10u1
> Followup-For: Bug #976652
>
> Dear Maintainer,
>
> > syslog.6.gz:Dec 5 18:56:49 dev mysqld[694]: 2020-12-05 18:56:49 0
> > [Warning] Could not increase number of
On 07/12/2020 19:34, Faustin Lammler wrote:
Or maybe a configuration error? Check for open_files_limit in your
configuration files or directly in mariadb with:
| SHOW GLOBAL VARIABLES LIKE 'open_files_limit';
It seems fine now:
MariaDB [mysql]> SHOW GLOBAL VARIABLES LIKE 'open_files_limit';
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
Richard van den Berg ,
07/12/2020 – 19:20:12 (+0100):
> Ok, so the 16384 limit in /lib/systemd/system/mariadb.service is actually
> the default from upstream?
Yes, see:
https://github.com/MariaDB/server/blob/10.6/support-files/mariadb.service.in#L146
> That seems odd to me as it warns it needs
Hi Richard!
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.
Why not consider instead overriding the systemd unit default option with
what you think is the best value for your setup?
Search for
10 matches
Mail list logo