I know you can use the MYSQL probe to monitor the performance of a single database but is it possible to monitor the following detail from a MySQL at the server level?
Aborted Connects INNODB buffer usage Tabel_open_cache_misses Lock _waits row-lock-time row lock waits selcet_full_joins Select_scans
I have been asked by the DB team to see these but not sure how best to approach this in PRTG?
Dear Aaron,
Basically, you can monitor every detail of your MySQL server by using the MySQL v2 sensor in PRTG. PRTG will perform your desired query and store the results. If you want to monitor a string value, you can follow the steps of this article.
Best regards, Felix
Sep, 2017 - Permalink