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

Monitor MySQL current connections

Votes:

0

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



2 Replies

Accepted Answer

Votes:

0

  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



Votes:

0

Excellent, exactly what I needed to know thanks!

Created on Sep 2, 2013 8:37:23 AM




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.