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:
Then you have to install the modules:
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:
Other modules might work as well...
process will not work for sure!