Mysql not being monitored via the apps Nan Nan

hey guys , im having an issue with monitoring my mysql server via the app.
everything it was working , according to the graph till 2 weeks ago.

its okay under the CLI where i get the values if i do php mysql (under the server itself) or from pulling it from librenms server (always CLI) but there is no graph.

Librenms is on the latest version

bash-4.2$ ./validate.php

Component Version
LibreNMS 22.4.0-21-g738ed53
DB Schema 2022_04_08_085504_isis_adjacencies_table_add_index (236)
PHP 7.4.29
Python 3.6.8
MySQL 10.5.15-MariaDB
RRDTool 1.4.8
SNMP 5.7.2
====================================

[OK] Composer Version: 2.3.5
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct

the only change i introduced recently is under the config.php
$config[‘snmp’][‘exec_timeout’] = 7200; (cause i was having another postfix service going in timeout , but this was like 3 days ago) mysql app has around 2 weeks that had stopped working.

FYI:

php mysql
a0:1432
a1:33
a2:0
a3:0
a4:33
a5:15052833045
a6:0
a7:1
a8:-1
a9:-1
aa:524224
ab:8197
ac:499616
ad:41253
ae:34598926
af:1604135
ag:181810817
ah:200842923
ai:34600246
aj:357955887
ak:151329003
al:0
am:0
an:0
ao:-1
ap:0
aq:0
ar:-1
as:0
at:0
au:-1
av:-1
aw:-1
ax:0
ay:0
az:0
b0:1490914081176
b1:82144929
b2:2967613
b3:107216967641063
b4:1458
b5:31048865
b6:0
b7:0
b8:2000
b9:114962
ba:2000
bb:5000
bc:2000
bd:27
be:1
bf:152
bg:0
bh:8
bi:1
bj:3904886
bk:1
bl:151
bm:9
bn:174778656
bo:-1
bp:-1
bq:-1
br:-1
bs:0
bt:1
bu:1031832
bv:0
bw:0
bx:0
by:10553744930
bz:0
c0:1
c1:1048576
c2:11666191662
c3:38914926
c4:141877998
c5:10611212738
c6:545243
c7:0
c8:0
c9:0
ca:4084
cb:0
cc:0
cd:43202
ce:6
cf:833593673
cg:0
ch:1870957414
ci:191799623
cj:899614379
ck:716602484294
cl:837428324
cm:1475249602
cn:949930052
co:178470413
cp:86831398455403
cq:7953657370550
cr:16777216
cs:16777216
ct:105898507216
cu:105898507231
cv:-1
cw:32768
cx:0
cy:0
cz:-1
d0:-1
d1:0
d2:-1
d3:-1
d4:-1
d5:-1
d6:-1
d7:-1
d8:-1
d9:-1
da:-1
db:-1
dc:-1
dd:-1
de:-1
df:-1
dg:-1
dh:1
di:10704400292
dj:2967613
dk:0
dl:0
dm:2218062958
dn:7890918203697
do:101654234605985
dp:16210222920
dq:615025677069
dr:4151161641763
ds:8933
dt:0
du:0
dv:401488526722
dw:758717369605
dx:-1
dy:-1
dz:2365241
e0:0
e1:-1
e2:-1
e3:11962993
e4:1
e5:1130
e6:1132
e7:420286912
e8:1107112
e9:39395672
ea:969024
eb:21251704
ec:0
ed:-1
ee:-1
ef:-1
eg:0
eh:1529856
ei:8388608
ej:80193
ek:458143

for those who are having the same issue , try to change the max_connection values on your mysql servers. it helped on my server.

using the following command :
mysql> set global max_connections = 512;
fixed the issue

to make that change permanent , add on /etc/my.cnf this line :
max_connections = 512

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.