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