What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general.

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags


View all Tags

Monitoring MYSQL stat's

Votes:

0

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?

database mysql performance

Created on Sep 12, 2017 10:40:32 AM



1 Reply

Votes:

0

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

Created on Sep 13, 2017 11:47:55 AM by Felix Saure [Paessler Support]




Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.