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

  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