MySQL Enterprise Monitor or MEM is a tool to watch over one instance to a farm of MySQL servers, to warn you of problems, and can advise you on fixing problems.But what does it take it get it running? How much can it show me about my server?
Start by downloading MEM from the Oracle Software Delivery Cloud (And it is still free for a 30 day trial). In addition to the monitor, make sure you download the monitor agent. For my 32-bit Ubuntu test box, there were named mysqlmonitor-220.127.116.114-linux-x86-installer.bin and mysqlmonitoragent-18.104.22.1684-linux-x86-installer.bin.
Executing mysqlmonitor-22.214.171.1244-linux-x86-installer.bin will get the monitor software installed. You can pick to use an existing database instance or a new one that comes with MEM. Please note the installer was picky and did not want to work with my 5.6 Instance previously installed. Be sure to note down the answers you enter to the install screens.
Then run mysqlmonitoragent-126.96.36.1994-linux-x86-installer.bin and start it as per the directions. And you should end up with a display like you see above.
Ideally you would run the agent on the system you want to watch and the monitor on a dedicated box.
Next time: What is MEM trying to tell me??