Provide aurweb performance issue data
As the mysqld is using ~ 100% constantly, we would like to investigate why:
-
Investigate how much RPC usage we have in comparison to other requests -
Where does the load come from? Mysqld, but which queries -
Which SQL queries take the longest? Enable slow query log (and disable nginx cache) -
Memcached stats -
Fix aurweb-aurblup,aurweb-pkgmaint,aurweb-popupdate timers starting at the same time (causes an hourly peak of 1000 rows / sec) -
investigate prometheus metrics
Edited by Jelle van der Waa