High MySQLd CPU Usage / connection rate since upgrade to 1.2.19

[Helmut Schneider]

Hi,

I just upgraded Cacti from 1.2.17 to 1.2.19 on FreeBSD 12.2. Since the upgrade the connections from Cacti to the database almost trippled (from ~40 to ~120) and mysqld is under heavy load (mostly 100%). The MySQL server (8.0.27) has 4 CPUs and 16GB of RAM, I have ~400 data sources so not that much.

[attachment=1]CPU.jpg[/attachment]
[attachment=0]Connections.jpg[/attachment]

It also seems that the Poller (1m) is not existing correctly:

[helmut@BSDHelmut ~]$ ps auxww | grep cacti
root 70584 4.0 0.2 53212 41288 - SNs 10:38 0:00.80 /usr/local/bin/php /var/www/cacti/poller.php
root 60565 0.0 1.0 180448 168448 - SNs 10:22 0:55.17 /usr/local/bin/php /var/www/cacti/poller.php
root 61230 0.0 0.9 168160 155552 - SNs 10:23 0:44.93 /usr/local/bin/php /var/www/cacti/poller.php
root 61768 0.0 0.8 137440 125760 - SNs 10:24 0:35.12 /usr/local/bin/php /var/www/cacti/poller.php
root 62310 0.0 0.6 110816 99588 - SNs 10:25 0:24.49 /usr/local/bin/php /var/www/cacti/poller.php
root 62822 0.0 0.5 88288 77060 - SNs 10:26 0:15.02 /usr/local/bin/php /var/www/cacti/poller.php
root 63395 0.0 0.4 73692 63248 - SNs 10:27 0:09.41 /usr/local/bin/php /var/www/cacti/poller.php
root 63948 0.0 0.3 67548 55468 - SNs 10:28 0:06.25 /usr/local/bin/php /var/www/cacti/poller.php
root 64634 0.0 0.3 63452 52416 - SNs 10:29 0:04.84 /usr/local/bin/php /var/www/cacti/poller.php
root 65195 0.0 0.3 63452 51384 - SNs 10:30 0:04.79 /usr/local/bin/php /var/www/cacti/poller.php
root 66818 0.0 0.3 61404 49924 - SNs 10:31 0:04.30 /usr/local/bin/php /var/www/cacti/poller.php
root 67369 0.0 0.3 59356 48048 - SNs 10:32 0:03.59 /usr/local/bin/php /var/www/cacti/poller.php
root 68003 0.0 0.3 57308 45676 - SNs 10:33 0:02.61 /usr/local/bin/php /var/www/cacti/poller.php
root 68533 0.0 0.3 55260 44156 - RNs 10:34 0:01.95 /usr/local/bin/php /var/www/cacti/poller.php
root 69041 0.0 0.3 55260 43264 - SNs 10:35 0:01.52 /usr/local/bin/php /var/www/cacti/poller.php
root 69531 0.0 0.3 55260 43144 - SNs 10:36 0:01.72 /usr/local/bin/php /var/www/cacti/poller.php
root 70071 0.0 0.2 53212 41136 - SNs 10:37 0:00.76 /usr/local/bin/php /var/www/cacti/poller.php

I tried with cmd and spine.

Number of PHP Script Servers: 2
Data Collector Processes: 2
Threads per Process: 2

Any ideas?