It also checked the performance of the machine itself, it has not changed (SSD DISK)

[root@observium2 ~]# sudo hdparm -Tt /dev/sda

/dev/sda:

 Timing cached reads:   12828 MB in  1.99 seconds = 6442.45 MB/sec

Timing buffered disk reads: 3478 MB in  3.00 seconds = 1159.04 MB/sec

[root@observium2 ~]# ^C

[root@observium2 ~]# ^C

[root@observium2 ~]#

Pozdrawiam

Jacek Dąbrowski
Koordynator Administratorów IT


Transgourmet Polska Sp. z o.o.
Zamenhofa 133, 61-131, Poznań, Polska
tel.: +48 61 874 20 17
kom.: +48 604 069 933
E-mail: Jacek.Dabrowski@selgros.pl
www.selgros.pl
www.selgros24.pl
www.transgourmet.pl

Transgourmet Polska Sp. z o.o. jest zarejestrowana w Sądzie Rejonowym Poznań-Nowe Miasto i Wilda w Poznaniu, Wydział VIII Gospodarczy Krajowego Rejestru Sądowego pod nr KRS: 0000045597.
NIP: PL 781-10-11-998, REGON 630375413. Wysokość kapitału zakładowego: 310.000.000,00 złotych.
Zapraszamy do korzystania z aplikacji HELPDESK...

From: observium <observium-bounces@observium.org> On Behalf Of Jacek Dąbrowski via observium
Sent: Tuesday, September 3, 2019 4:52 PM
To: michiel@klaver.it; observium@observium.org
Cc: Dąbrowski Jacek <Jacek.Dabrowski@selgros.pl>
Subject: Re: [Observium] DB Error

It did not help but I see that even RRDtool does not work properly.

Pozdrawiam

Jacek Dąbrowski

From: Michiel Klaver <michiel@klaver.it>
Sent: Tuesday, September 3, 2019 9:28 AM
To: Observium <observium@observium.org>
Cc: Dąbrowski Jacek <Jacek.Dabrowski@selgros.pl>
Subject: Re: [Observium] DB Error

Login as root user to your MySQLd and run this statement:
show variables like "max_connections";
Result would look something like this:
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 100   |
+-----------------+-------+
Increase that number to allow more concurrent connections, for example run this statement:
set global max_connections = 200;

To make this change permanent, locate your my.cnf file (often in /etc or /etc/mysql) and add this under the [mysqld] section:
max_connections = 200
After a restart of the mysqld service this setting will be the new default.

Or maybe try a tool like mysqltuner.pl to find the optimised advised configuration setting for the max_connection limit:
https://github.com/major/MySQLTuner-perl

Jacek Dąbrowski via observium wrote at 2019-09-02 10:54:

Hello,

Yesterday I turned off Observium after turning on the message DB Error 1040 appears, which I can do with it ???

Pozdrawiam

Jacek Dąbrowski

_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium