On Thu, Jan 30, 2020 at 6:53 PM stakanov <stakanov@eclipso.eu> wrote:
stakanov composed on 2020-01-30 11:18 (UTC+0100):
I did create a paste in
https://paste.opensuse.org/22334414
I am not good enough to understand what the system actually complains. I do not think it is a memory problem, could be related to the OS instead.
Since the first crash appears shortly after mysqld: page allocation stalls for 21920ms, mysqld cpuset=/ mems_allowed=0 CPU: 0 PID: 4130 Comm: mysqld Not tainted I would try disabling mysqld to see if the crashing stops and swap stays unused.
In data giovedì 30 gennaio 2020 12:42:26 CET, Felix Miata ha scritto: this is a bit difficult since akonadi is used on two users for mail.
But I can try, although that would mean, to have a typical example, to leave the machine running over night, with akonadi shut down I guess (or do I have to end msql actively) to see if it swaps at all.
Hi, As someone who get in touch with database daily (mainly PostgreSQL), seems to me there is something wrong with MySQL. Do you check your physical RAM? Try memtester or memtest86+ (https://www.memtest.org/). Anyway I try to avoid disk swap on my database, and push it to use hugepages and TLB extensively. I also use zram and change the unused RAM become swap. best, -- Edwin -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org