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
[cid:image003.png@01D5627A.D3830950]http://transgourmet.pl/ 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.plhttp://selgros.pl www.selgros24.plhttp://selgros24.pl www.transgourmet.plhttp://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 HELPDESKhttp://helpdesk-it... 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.
[cid:image001.jpg@01D56277.EA372350]
Pozdrawiam
Jacek Dąbrowski From: Michiel Klaver <michiel@klaver.itmailto:michiel@klaver.it> Sent: Tuesday, September 3, 2019 9:28 AM To: Observium <observium@observium.orgmailto:observium@observium.org> Cc: Dąbrowski Jacek <Jacek.Dabrowski@selgros.plmailto: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 ???
[cid:15674956685d6e15f471539819603908@klaver.it]
Pozdrawiam
Jacek Dąbrowski
_______________________________________________ observium mailing list observium@observium.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
