maria-discuss team mailing list archive

[Reindl Harald <h.reindl@xxxxxxxxxxxxx>]

Am 17.07.2017 um 14:39 schrieb Reinis Rozitis:
> > > > mysqld as well as httpd had "LimitNOFILE=infinity" in the
> > > > systemd-unit, the connection type is unix socket, so that all should
> > > > not be a problem on a i7-3770 CPU @ 3.40GHz with 32 GB RAM
>
> Could it be you are hitting this https://github.com/systemd/systemd/issues/3211  (also https://news.ycombinator.com/item?id=11675129 ) - besides the open files limit some systemd versions (before it was bumped to a relative value) are screwed with the default 512 tasks limit.

for sure not, i read systemd news and adjust my services

LimitNOFILE=infinity
LimitMEMLOCK=infinity
OOMScoreAdjust=-1000
TasksMax=2048

[root@srv-rhsoft:~]$ systemctl status mysqld
? mysqld.service - MariaDB Database
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; 
vendor preset: disabled)
   Active: active (running) since Mo 2017-07-17 14:04:39 CEST; 43min ago
 Main PID: 24897 (mysqld)
   Status: "Taking your SQL requests now..."
    Tasks: 238 (limit: 2048)