MySQL is 100% over the past week, no idea why, details below


Component Version
LibreNMS 21.11.0-70-ge803fa57a
DB Schema 2021_11_29_165436_improve_ports_search_index (229)
PHP 7.4.3
Python 3.8.10
MySQL 10.3.32-MariaDB-0ubuntu0.20.04.1
RRDTool 1.7.2
SNMP 5.8

[OK] Composer Version: 2.1.14
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct
[WARN] Your local git contains modified files, this could prevent automatic updates.
You can fix this with ./scripts/github-remove
Modified Files:

I’m trying to work out why MySQL is hitting 100% over the past week:

It’s a server that does network/server monitoring called LibreNMS.

Top: top -

Here I access MySQL and look at the processes: show processlist -

and full processes show full processlist -

I then found a tool called MySQLTuner, but I’m not experienced enough to understand the results: mysqltuner -

Any advice would be most appreciated.

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