Repository navigation
A fix for the top queries view (t), reported by u/Anakin19901 on r/linuxadmin. Thanks!
Fixed
- An empty top queries list no longer looks healthy. When
performance_schemawas on but statement digests weren't being collected (statement instruments or thestatements_digestconsumer disabled), the view showed "No statements recorded" with a green tick, which reads as "no slow queries". It now warns that an empty list doesn't mean that, and gives the runtimeUPDATEstatements to enable collection. - With
performance_schemaoff (MariaDB's default), the warning explains that it can't be enabled at runtime and gives themy.cnfchange instead. - On a freshly started server, the view now says so, without a tick.
Added
- Health check for statement digests in the health view (
h), with the same advice, so the problem shows up without openingt. - Health advice now wraps onto the next line instead of being cut off at the screen edge.
Install
curl -O https://raw.githubusercontent.com/haydenjames/mysqlmonitor-script/main/mysqlmonitor.sh && chmod +x mysqlmonitor.sh && ./mysqlmonitor.sh