MySQL Enterprise Monitor Part II

Last time, I installed the MySQL Enterprise Monitor and the Monitor Agent on an Ubuntu system. I was able to get both parts to talk to each other and get the graphs to display.

Two systems being monitored
Two system being monitored with MySQL Enterprise Monitor

I installed the Agent on a Mac and had it displaying data in literally less time than it took to type this sentence.

I could information on both systems or dig down into each server. The dashboard has red, yellow, or green icons on various status items.

What — two alerts on my Ubuntu box?  I clicked on the link and found I had CPU Usage Excessive and CPU I/O Usage Excessive during a time I was bulk loading data.  I was able to mark those off the ‘to be worried about’ list.  There are other advisors so you can watch for things like In-memory temporary table size limited by Maximum Heap Table Size, users being dropped, or Slave SQL Thread Stopped

Next time: Digging Deeper

Published by


Dave Stokes is a MySQL Community Manager for Oracle and previously was the MySQL Certification Manager for MySQL AB and Sun Microsystems. He has a MBA from the University Of San Diego.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s