Linux Memory Pools reporting wrong

What are those? I’m not very familiar with mariadb. Why would it have so many processes? A process per connection?

I have no idea, I asked earlier and they mention to split off my mysql database to another vm. I haven’t done so yet but those processes are eating up my ram. I figure if I gave the machine 128GB RAM it would solve the problem but seems like in 6 days it fills up

@murrant I just tried looking at my small test machine of librenms for a small offline network. It seems to have those same processes multiple times. Does yours not have that?

This is ps during poller run, which completes < 5 min. I only have 210 devices and 2410 ports.

ps aux|egrep 'poller.php|mysqld'
mysql     1398  0.0  0.0 113260  1592 ?        Ss   Sep20   0:00 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
mysql     1767  2.1  1.8 2747292 268712 ?      Sl   Sep20  44:25 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock
librenms 30705  0.0  0.0 113128  1208 ?        S    22:25   0:00 /bin/sh -c /usr/bin/env php /opt/librenms/poller.php -h 49 >> /dev/null 2>&1
librenms 30707  0.0  0.0 113128  1204 ?        S    22:25   0:00 /bin/sh -c /usr/bin/env php /opt/librenms/poller.php -h 43 >> /dev/null 2>&1
librenms 30708  2.2  0.1 419796 17964 ?        S    22:25   0:00 php /opt/librenms/poller.php -h 49
librenms 30709  0.0  0.0 113128  1204 ?        S    22:25   0:00 /bin/sh -c /usr/bin/env php /opt/librenms/poller.php -h 44 >> /dev/null 2>&1
librenms 30710  2.0  0.1 419796 17836 ?        S    22:25   0:00 php /opt/librenms/poller.php -h 43
librenms 30711  0.0  0.0 113128  1204 ?        S    22:25   0:00 /bin/sh -c /usr/bin/env php /opt/librenms/poller.php -h 83 >> /dev/null 2>&1
librenms 30713  2.2  0.1 419796 18156 ?        S    22:25   0:00 php /opt/librenms/poller.php -h 44
librenms 30715  0.0  0.0 113128  1208 ?        S    22:25   0:00 /bin/sh -c /usr/bin/env php /opt/librenms/poller.php -h 34 >> /dev/null 2>&1
librenms 30716  2.0  0.1 419796 17936 ?        S    22:25   0:00 php /opt/librenms/poller.php -h 83
librenms 30717  0.0  0.0 113128  1208 ?        S    22:25   0:00 /bin/sh -c /usr/bin/env php /opt/librenms/poller.php -h 30 >> /dev/null 2>&1
librenms 30719  0.0  0.0 113128  1208 ?        S    22:25   0:00 /bin/sh -c /usr/bin/env php /opt/librenms/poller.php -h 48 >> /dev/null 2>&1
librenms 30720  2.0  0.1 419796 17908 ?        S    22:25   0:00 php /opt/librenms/poller.php -h 34
librenms 30721  2.2  0.1 419796 18216 ?        S    22:25   0:00 php /opt/librenms/poller.php -h 30
librenms 30723  0.0  0.0 113128  1204 ?        S    22:25   0:00 /bin/sh -c /usr/bin/env php /opt/librenms/poller.php -h 51 >> /dev/null 2>&1
librenms 30726  2.0  0.1 419796 17904 ?        S    22:25   0:00 php /opt/librenms/poller.php -h 48
librenms 30727  0.0  0.0 113128  1208 ?        S    22:25   0:00 /bin/sh -c /usr/bin/env php /opt/librenms/poller.php -h 108 >> /dev/null 2>&1
librenms 30729  0.0  0.0 113128  1208 ?        S    22:25   0:00 /bin/sh -c /usr/bin/env php /opt/librenms/poller.php -h 107 >> /dev/null 2>&1
librenms 30730  2.2  0.1 419796 18152 ?        S    22:25   0:00 php /opt/librenms/poller.php -h 108
librenms 30732  0.0  0.0 113128  1208 ?        S    22:25   0:00 /bin/sh -c /usr/bin/env php /opt/librenms/poller.php -h 5 >> /dev/null 2>&1
librenms 30734  2.0  0.1 419796 17908 ?        S    22:25   0:00 php /opt/librenms/poller.php -h 51
librenms 30736  0.0  0.0 113128  1208 ?        S    22:25   0:00 /bin/sh -c /usr/bin/env php /opt/librenms/poller.php -h 202 >> /dev/null 2>&1
librenms 30738  0.0  0.0 113128  1208 ?        S    22:25   0:00 /bin/sh -c /usr/bin/env php /opt/librenms/poller.php -h 176 >> /dev/null 2>&1
librenms 30739  4.1  0.1 421844 19836 ?        R    22:25   0:00 php /opt/librenms/poller.php -h 176
librenms 30743  2.2  0.1 419796 18540 ?        S    22:25   0:00 php /opt/librenms/poller.php -h 5
librenms 30746  2.0  0.1 419796 18124 ?        S    22:25   0:00 php /opt/librenms/poller.php -h 202
librenms 30747  2.1  0.1 419796 18148 ?        S    22:25   0:00 php /opt/librenms/poller.php -h 107
librenms 30757  0.0  0.0 113128  1208 ?        S    22:25   0:00 /bin/sh -c /usr/bin/env php /opt/librenms/poller.php -h 55 >> /dev/null 2>&1
librenms 30761  3.8  0.1 421844 19696 ?        S    22:25   0:00 php /opt/librenms/poller.php -h 55
librenms 30762  0.0  0.0 113128  1208 ?        S    22:25   0:00 /bin/sh -c /usr/bin/env php /opt/librenms/poller.php -h 39 >> /dev/null 2>&1
librenms 30770  3.5  0.1 421844 19084 ?        S    22:25   0:00 php /opt/librenms/poller.php -h 39
librenms 31077  0.0  0.0 113128  1208 ?        S    22:25   0:00 /bin/sh -c /usr/bin/env php /opt/librenms/poller.php -h 65 >> /dev/null 2>&1
librenms 31079  4.8  0.1 421844 19640 ?        S    22:25   0:00 php /opt/librenms/poller.php -h 65
root     31635  0.0  0.0 112796   996 pts/1    S+   22:25   0:00 grep -E --color=auto poller.php|mysqld

@murrant its always there, so i do a ps aux and come back with a line like

your 2nd line looks similar to mine. It looks like it takes up the most memory. Im not sure why Htop shows all those processes separately.

mysql 1101 24.7 0.4 10648076 630884 ? Sl Sep15 2419:57 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock

Which looks like its taking up a lot of memory