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


Monitor MySQL current connections

Votes:

0

Your Vote:

Up

Down

Hey everyone.

We're monitoring a MySQL database (which is running on Windows 2003 if that matters?) and we're gathering information on the response time, etc.

What do we need to do in order to monitor the current / open connections to the MySQL server?

connections database mysql

Created on Aug 21, 2013 10:54:01 AM by  Rich (50) 1 1



2 Replies

Accepted Answer

Votes:

0

Your Vote:

Up

Down

  1. Create a monitoring user account in the database you wish to query
  2. Add the MySQL database sensor to the host that you wish to monitor
  3. Populate the database you wish to query, the user credentials, and the query:
    1. select count(*) from information_schema.PROCESSLIST
  4. Process Numerical Result

This is from my experience. Also reference http://blog.dennis-schneider.com/2012/11/24/useful-commands-tools-and-tips-for-mysql-and-postgres-databases.html

Created on Aug 24, 2013 2:06:33 AM by  Randolfini (270) 2 1



Votes:

0

Your Vote:

Up

Down

Excellent, exactly what I needed to know thanks!

Created on Sep 2, 2013 8:37:23 AM by  Rich (50) 1 1



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.