Fresh librenms container on Ubuntu 22.04 under Proxmox hypervisor. Imported over rrd files and database from previous Centos 7 install. After around 18 hours it keeps falling over.
in /etc/mysql/my.cnf I’ve increased max_connections but this hasn’t helped.
[mysqld]
max_connections = 1000
librenms@librenms:~$ ./validate.php
===========================================
Component | Version
--------- | -------
LibreNMS | 23.2.0-44-g0a889ad36 (2023-03-24T14:29:53+13:00)
DB Schema | Not Connected (0)
PHP | 8.1.2
Python | 3.10.4
Database | Not Connected
RRDTool | 1.7.2
SNMP | 5.9.1
===========================================
[OK] Composer Version: 2.5.4
[OK] Dependencies up-to-date.
Could not connect to database, check logs/librenms.log.
MariaDB [(none)]> SHOW VARIABLES LIKE 'max_connections';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 2048 |
+-----------------+-------+
1 row in set (0.001 sec)
MariaDB [(none)]> SHOW STATUS WHERE `variable_name` = 'Threads_connected';
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Threads_connected | 165 |
+-------------------+-------+
1 row in set (0.001 sec)
You can also setup some snmpd and script so you get some basic stats in
So far so good. I’ve got SNMP monitoring. rrdcached has massively reduced diskIO. I had ran MySQLTuner on previous Centos hosted LibreNMS but I just want it stable first before tweaking.
MariaDB [(none)]> show variables like 'max_connections';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 1000 |
+-----------------+-------+
1 row in set (0.000 sec)
MariaDB [(none)]> show status where 'variable_name' = 'Threads_connected';
Empty set (0.000 sec)