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?

Article Comments

Attention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.

  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


Aug, 2013 - Permalink

Excellent, exactly what I needed to know thanks!


Sep, 2013 - Permalink