maria-discuss team mailing list archive

[Reindl Harald <h.reindl@xxxxxxxxxxxxx>]

looks more like similar to 
https://www.percona.com/blog/2009/11/20/rare-evil-mysql-bug/ which is 
really old but who knows

Am 17.07.2017 um 14:48 schrieb Reindl Harald:
> 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)