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


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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: