Video

Real-time MySQL Performance & Availability Monitoring in MySQL Enterprise Monitor (with video demo)

One of the reasons why you should use MySQL Enterprise Monitor is that it allows you to track the performance and health of your MySQL servers and how easy it is to do so.

Once you log into your MySQL Enterprise Monitor, you will see the overview screen where you could get a quick view of your entire monitored infrastructure.  So it is very easy to check on the overall health of everything you are monitoring.

Alternately, you can just select a certain group that you are concerned with.

For example, you can select the production replication group and see:

  1. That group’s long-term availability
  2. What servers are included in this group
  3. How many connections are handled by the group
  4. The general database activity including select, updates, insert, replace, delete and call statements
  5. The average query response times
  6. Problematic MySQL instances, or those that are not running or have critical alerts
  7. Problematic host machines, and
  8. The list of unhandled critical events in your group

My SQL Enterprise Monitor allows you to get all of these information in just one screen, making the overview screen a great, convenient and easy way to monitor the health of your assets.

[expand title=”Click here to read more about this article”]

Here’s the video demo with its script below it:

Welcome! In this presentation I’ll demonstrate how you can conveniently monitor the health and performance of your MySQL servers using MySQL Enterprise Monitor or MEM version 3.0.

 

When you login, by default you’ll be taken to the overview screen, which you can see here. Now you can use this to get a quick idea of the overall health of your entire monitored infrastructure or just one of a select group. For example, I can select my production replication group, as that’s the group that I’m typically most concerned with. At first I can see the long-term overall availability of the servers in this group.

 

I can see how many connections are being handled. And this is an easy way to look for big connection spikes in my group. I can see the overall database activity, as measured in DML statements – so Selects, Inserts, Updates, Deletes and so on.

 

I can see the query response time averages for my group. And please look for the additional video demo where I go into exactly what QRTI is – how it’s calculated and why it’s extremely useful.

 

I can see what my current problematic MySQL instances are. Problematic meaning that they’re not running or they have unaddressed critical alerts. I can also see what my problematic cause or machines are. Again, meaning that they’re not running or they have unaddressed critical alerts.

 

And finally, I can see a full list to the unhandled critical events for all the servers in this group. So as you can see, the overview screen is a nice and easy way to see, gauge and monitor the overall health of your monitored assets.

 

That’s all for this video. Thank you for watching and please be sure to look for our other video demos on MEM 3.0, where I’ll show you how you can dive deeper into the data that’s available here on the overview screen.

[/expand]

Cloud Blog

4 Ways To Benefit from…

One of the benefits you get when you work with cloud applications is that you often have quarterly updates that are packed with features. This...

Keep Reading

Artificial Intelligence

Data and Analytics: Cross the…

  Artificial intelligence is a manna sent from digital heaven. That’s how blessed your business can get if you immerse into the AI of things....

Keep Reading

Business Intelligence Blog

How Brand Names Survive in…

  The age of digital marketplace has made it possible for unknown and smaller companies to compete with better-known and well-established brands. Take for example...

Keep Reading

Artificial Intelligence

The Phenomenon That Is Artificial…

  Artificial intelligence is when a machine does cognitive functions that are more associated with humans, such as thinking, learning, problem solving, and reasoning. As...

Keep Reading

Cloud

Digital Transformation in Banking: Shift…

  The start of a new decade is already shaping up to be exciting for financial services, especially for banks as they continue to compete...

Keep Reading

Business Intelligence Blog

Data Science and Its Economic…

It would seem that artificial intelligence is the focus of businesses that are looking to future proof their organizations and stay competitive. And why not?...

Keep Reading

Data Blog

Ensure Efficient Data Science and…

In an ever-expanding landscape called Internet of Things and the exploding development of artificial intelligence, we are bombarded with complex methods of integrating data science...

Keep Reading

Business Intelligence Blog

Cybersecurity: The Top 5 Expectations…

  If you think about it, cybersecurity is closely tied to human rights, privacy, freedom, and even basic safety. As a whole, we have become...

Keep Reading

Business Intelligence Blog

Tech Security Should Be Easy…

  IT professionals know that tech security is important in everything that they do. And that there are a lot of products, tools, innovations, and...

Keep Reading

Business Intelligence Blog

The Top 6 Success Stories…

Nearly nine out of 10 digital transformation initiatives fail. Digital transformation projects fail for a variety of reasons. It can be because of a lack...

Keep Reading

Live Chat | Emergency