Shulou(Shulou.com)06/01 Report--

[PangApps] introduction to MySQL Monitoring

Do you know when the database used is capped?

Do you know when the database needs to be expanded?

Do you know the amount of data received and output by the database?

Is it because the database buffer space is too small, resulting in performance degradation?

It would be nice to have convenient monitoring and monitoring anytime and anywhere when the database is in operation.

In that case, how can you monitor your database?

Free monitoring software is not only troublesome but also the service is not very good.

The charge for monitoring software is expensive.

The monitoring tools used now are inconvenient or have poor performance and have a price burden, so it is recommended to use our https://pangdata.com monitoring software.

Installation method of MySQL Monitoring Application

You can experience it.

Account number: pang-demo-cn

Password: panghenhao

The objects of the basic monitoring we provide are

Database traffic (In/Out), invitations per second (read/write) queries, number of linked servers, buffer utilization, provide real-time monitoring.

As long as any device is linked to the network, the device can be monitored in real time.

Now the state management of the database is that the status of the database can be known in real time in the computer room or in the office. (the real-time monitoring function of Pang data is really powerful ~ ^ ^)

The dashboard is shown in the following screen. You can add dashboard parts as needed. (purchase enterprise authorization that provides user demand settings)

Real-time database monitoring dashboard screen

Mobile users also support

In the company, home, travel, anywhere in the world, through the mobile phone, 100% tablet can be used

Trigger

If the database wants to get the notification information in the abnormal situation, such as when the buffer usage is more than 50% and the communication volume reaches more than 20MB, it is convenient to get the notification in time through the trigger

Database performance resume management

If there is a problem in the database, if there is a fault, find the state of the database at the time of the failure and analyze it.

Some faults are higher than the previous average or much higher than the previous maximum, and the cause of the failure can be found when comparing and analyzing the data.

Ability to manage data from the first few seconds to years ago

As can be seen, according to the average of each period, maximum, minimum, average deviation and other data.

For some kind of monitoring object, you can also browse the past data at any time.

You can also compare various monitoring objects.

DIY (Do It Yourself) monitoring

If you only look at the traffic or buffer rate, you can monitor the relevant content. You can query the types of queries in each database, or monitor more detailed information. Very easy to set up, you can add and delete monitoring at will.

MySQL 5.7State variable specification

Https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html

MariaDB state variable specification

Https://mariadb.com/kb/en/mariadb/server-status-variables/

Adding method of state variable monitoring object

Enter the Pang data application to download the following settings

..

Status.Handler_read_first=false

Status.Innodb_buffer_pool_wait_free=false

Status.Threads_connected = true

Status.Max_used_connections = true

Status.Cpu_time = false

...

Status. State change name = true

You can see this pattern ~

For example, if you want to query the number of update matches, you can find the Com_update status variable in the directory.

Status.Com_update = true

If only the above article is added and restarted, the device user interface is automatically monitored. That is, real-time monitoring can be achieved by registering unregistered devices in the overview.

Health check of database

The most important thing in the process of database monitoring is to understand the life and death status of the database.

Even if it is not checked frequently, as long as the database is not operating properly, the manager will be notified immediately by SMS or email.

Even if the database stops working, it will be notified by text message or email.

Health examination method

Enter the device screen and enter the logged-in device group

An example of selecting a representative from a device

Click the settings in the upper right corner to enter

Activate the health check and set the time to save.

Everyone's database can be turned into an intelligent database at a low price.

Although it has this function, it can be used cheaply compared with other fee-based databases.

A price of about 50 yuan a month

(the number of basic monitoring equipment per month is 8 units of 30 seconds, and the monitoring period can also be set to 1 second as units)

Registration can be used for free for 3 months

Here's how to install it. Try it now.

Installation method of MySQL Monitoring

Database monitoring video

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.