New Question
 
 
PRTG Network Monitor

Intuitive to Use.
Easy to manage.

200.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free PRTG
Download >>

 

What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

 

Top Tags


View all Tags


Monitoring MYSQL stat's

Votes:

0

Your Vote:

Up

Down

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 by  Aaron Street (0) 1



1 Reply

Votes:

0

Your Vote:

Up

Down

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]



Please log in or register to enter your reply.


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.