Published on 12 August 2020 by Florian Gabon
In this article we will show you how:
- To configure MySQL so Bleemeo automatically collects metrics with auto-detection
- To configure a dashboard to better understand your server and what's going on:
- An automatic dashboard
- A custom dashboard
What is MySQL ?
The MySQL is an open-source relational database server and it was officially released in 1995. Nowadays, it's one of the most used databases for web applications in the world, many organizations such as Twitter, Facebook, and YouTube use it. MySQL belongs to the Oracle foundation in 2010, at the same time Michael Windenius one of the founders of MySQL leaves the company to create MariaDB, it's a fork of the open-source project.
How to configure MySQL to Bleemeo?
Once the agent is installed, normally by default it connects alone.
If you need more information, you can consult our documentation.
Default dashboard
Once the Bleemeo agent has been able to MySQL access, a new default dashboard appears. This looks like:
How to customize your dashboard?
Now let's see how to make custom dashboards that cans better meet your specific expectations. For example, we will monitor metrics:
- Number of queries per second
- Number of threads connected, running and cached
- Status of MySQL
- Number of select per second.
If you want more MySQL metrics, here is a link to our documentation.
This type of dashboard allows you to better know when there are people connected and how many, and also what is happening on your server. You can also add other metrics, if you run your server on a Docker for example you can add:
- Status of the MySQL container
- Memory used by applications in percent
- CPU used in percent.
It will allow you to have a single dashboard for several types to monitor and therefore a dashboard is infinitely customizable, which can be useful for what you need exactly to monitor.
With Bleemeo, you can start monitoring MySQL metrics and create custom dashboards in a few minutes.
If you don't have a Bleemeo account yet, start monitoring your MySQL today in 30s.