You are here

MySQL Performance Monitor installation guide for Windows

To install the FromDual's MySQL Performance Monitor (mpm) on Windows we first have to install Perl. We recommend to use ActiveState Perl but Strawberry Perl may work as well. The installation is straight forward.

For querying MySQL we have to install some additional Perl modules. You can follow either the official MySQL documentation (which is a bit out of date) or just run the following command:

C:\Perl64\bin\ppm.bat

Then you have to install the modules:

  • DBI
  • DBD-mysql

Now you can already run the MySQL Performance Monitor!

Important: The current release (v0.9) does NOT work yet on Windows without patching the file FromDualMySQLagent.pm. For more details see here.

Run the mpm every minute

To run the mpm every minute we need the Windows Task Scheduler. You can schedule your task either by using the command line:

schtasks /create /sc minute /mo 1 /tn "MySQL Performance Monitor" \
/tr "C:\mpm\FromDualMySQLagent.pl C:\mpm\mpm.conf"

or by using the GUI. Go to:

Computer (right click) > Manager > System Tools > Task Scheduler > Crate Task...

MPM modules which work

The modules which seem to work at least partially at the moment are:

  • master
  • mpm
  • myisam
  • mysql
  • slave

Other modules might work as well...

The modules server and process will not work for sure!