====================================
| 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.
[FIX]:
You can fix this with ./scripts/github-remove
Modified Files:
includes/definitions/rutos.yaml
rrd/.gitignore
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 - Pastebin.com
Here I access MySQL and look at the processes: show processlist - Pastebin.com
and full processes show full processlist - Pastebin.com
I then found a tool called MySQLTuner, but I’m not experienced enough to understand the results: mysqltuner - Pastebin.com
Any advice would be most appreciated.