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,
10.5 and the upstream versions seem affected too.
# grep mariadb syslog
Dec 13 10:10:28 debian mariadbd[535]: 2020-12-13 10:10:28 0 [Note]
/usr/sbin/mariadbd (mysqld 10.5.8-MariaDB-1:10.5.8+maria~sid) starting
as process 535 ...
Dec 13 10:10:28 debian mariadbd[535]: 2020-12-13 10:10:28 0
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
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.
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]:
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]: 2020-12-11 13:08:46 0 [Warning] Could not
increase number of
Package: mariadb-server-10.3
Version: 1:10.3.27-0+deb10u1
Followup-For: Bug #976652
Dear Maintainer,
Debian 10 server @ Linode:
$ zgrep max_open_files syslog*
syslog:Dec 11 12:36:58 ln0 mysqld[699]: 2020-12-11 12:36:58 0 [Warning] Could
not increase number of max_open_files to more than 16384
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
Package: mariadb-server-10.3
Version: 1:10.3.27-0+deb10u1
Followup-For: Bug #976652
Hi Faustin,
Debian 10 server @ Linode:
$ zgrep max_open_files syslog*
syslog:Dec 11 12:36:58 ln0 mysqld[699]: 2020-12-11 12:36:58 0
[Warning] Could not increase number of max_open_files to more than
16384
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
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 max_open_files to more than 16384 (request:
> 32183)
Where does the 32183 come
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
Package: mariadb-server-10.3
Version: 1:10.3.27-0+deb10u1
Severity: normal
When starting the mariadb service it warns:
Dec 6 07:01:05 myhost mysqld[24031]: 2020-12-06 7:01:05 0 [Warning] Could not
increase number of max_open_files to more than 16384 (request: 32191)
This warning is because
17 matches
Mail list logo
