This is likely caused by your system being quite close to the limit for performance for the number of devices you're monitoring.

If it gets overloaded, poller processes won't end quickly enough, more poller processes will be started causing everything to get slower and slower, and you end up with a snowball  effect that consumes all of the mysql connections.

We do have some limiters to help prevent this, but it's not easily possible to totally prevent it, given the massive range of installations we have.

It shouldn't be the case that MySQL was significantly faster than Mariadb, but more likely that the act of upgrading and starting/stopping the database caused the issue.

It might also be a warning to increase resources on the polling server.

adam.

Arnoldo Vidal Bravo via observium wrote on 15/03/2023 18:23:
ok. thanks

El mié, 15 mar 2023 a las 15:22, Adam Armstrong via observium (<observium@lists.observium.org>) escribió:
If it's running 39 wrappers, it's going to be running a bazillion pollers.

Reboot the machine and see if it behaves better after that (or kill all *.php and *.py processes, but reboot is easier)

Arnoldo Vidal Bravo via observium wrote on 15/03/2023 18:15:
ps aux | wc -l ->533
ps aux | grep wrapper | wc -l ->39

El mié, 15 mar 2023 a las 15:08, Adam Armstrong via observium (<observium@lists.observium.org>) escribió:
"ps aux" on the server console

adam.

Arnoldo Vidal Bravo via observium wrote on 15/03/2023 17:37:
I'm not sure where to see that information. We have configured Observium according to the help for installation in Centos 7

El mié, 15 mar 2023 a las 14:30, Adam Armstrong via observium (<observium@lists.observium.org>) escribió:
That's not what I asked.

How many of those processes are running on the system when it is complaining about connections?

Arnoldo Vidal Bravo via observium wrote on 15/03/2023 17:25:
observium had 45 processes configured and was running fine. Previously we had mysql 5.7

El mié, 15 mar 2023 a las 14:12, Adam Armstrong via observium (<observium@lists.observium.org>) escribió:
how many poller.php / poller-wrapper.py and discovery.php processes are running?

adam.

Arnoldo Vidal Bravo via observium wrote on 15/03/2023 14:17:
Hi 

We perform an update to our DB to mariadb 10.11, but now it show this message
DB not connected, please check database connection configuration.DB Error 1040: Too many connections.

By defaults, Mariadb support only 100 connections, 

How  much connections we must enabled (recommended)?

pd: we changed to 500 connections but the message shows again


--

Saluda cordialmente

 




_______________________________________________
observium mailing list -- observium@lists.observium.org
To unsubscribe send an email to observium-leave@lists.observium.org

--
Sent from Postbox
_______________________________________________
observium mailing list -- observium@lists.observium.org
To unsubscribe send an email to observium-leave@lists.observium.org


--

Saluda cordialmente

 




_______________________________________________
observium mailing list -- observium@lists.observium.org
To unsubscribe send an email to observium-leave@lists.observium.org

--
Sent from Postbox
_______________________________________________
observium mailing list -- observium@lists.observium.org
To unsubscribe send an email to observium-leave@lists.observium.org


--

Saluda cordialmente

 




_______________________________________________
observium mailing list -- observium@lists.observium.org
To unsubscribe send an email to observium-leave@lists.observium.org

--
Sent from Postbox
_______________________________________________
observium mailing list -- observium@lists.observium.org
To unsubscribe send an email to observium-leave@lists.observium.org


--

Saluda cordialmente

 




_______________________________________________
observium mailing list -- observium@lists.observium.org
To unsubscribe send an email to observium-leave@lists.observium.org

--
Sent from Postbox
_______________________________________________
observium mailing list -- observium@lists.observium.org
To unsubscribe send an email to observium-leave@lists.observium.org


--

Saluda cordialmente

 




_______________________________________________
observium mailing list -- observium@lists.observium.org
To unsubscribe send an email to observium-leave@lists.observium.org

--
Sent from Postbox