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

Navicat Monitor is a secure, simple and agentless remote server monitoring tool. It has a powerful function to maximize the effectiveness of your monitoring. The monitored servers include MySQL, MariaDB and Percona Server, and are compatible with cloud databases such as Amazon RDS, Amazon Aurora, Oracle Cloud, Microsoft Azure and Aliyun. Navicat Monitor is a server-based software that can be accessed from anywhere using a web browser. Through network access, you can easily and seamlessly grasp the status of global servers around the clock.

In the previous article, "how MySQL 8 performance mode helps diagnose query deadlocks," we learned about crash courses on mutexes and threads, learned about MySQL performance patterns, and applied some queries to investigate performance bottlenecks. In today's follow-up article, I will introduce another way to use Navicat Monitor for bottleneck and deadlock investigation.

Overview of Navicat Monitor

Navicat Monitor is an agentless remote server monitoring tool for MySQL / MariaDB that makes monitoring database (DB) instances as efficient and easy as possible. The term "agentless" is key because it describes a server-based architecture that does not require any software to be installed on the server to be monitored. In addition, Navicat Monitor can be accessed from anywhere through a Web browser, giving you unhindered access, day or night, to easily and seamlessly track servers from anywhere in the world.

It has many functions. Here are some things listed by screen:

1. Overview of real-time interaction

View all registered MySQL / MariaDB instances and availability groups on a central Web-based interface

Monitor real-time MySQL / MariaDB metrics, CPU, memory, and swap usage on the host

Explore historical indicators within an hour

2. Instance details

Agentless remote monitoring

Generate a report on server performance metrics

Export the report to a PDF file

3. Alarm

More than 40 fully customizable alert policies are pre-configured

Get useful advice on how to improve server performance

Use SMTP, SMS, SNMP traps, and Slack with customizable thresholds

4. Query Analyzer

Analyze slow query log and regular query log

Find the query that has the greatest impact on your system

Store history to diagnose deadlock issu

5. Copy monitoring

Displays your replication topology and enables you to quickly view the status of each replication

Copy error history to resolve replication issu

Send an alert when any replication problems are detected

6. Security monitoring

Control access to monitoring assets and functions

Improve the security of MySQL / MariaDB by sending you an alert

Detect MySQL / MariaDB*** activity

7. User management

Role-based access control

User Integration of OpenLDAP or Active Directory

Restrict login or role access by IP address

8. Configuration export and restore

Save the latest configuration and restore it at any time

Migrate Navicat Monitor to a new host

Allow repository database migration

Find deadlock query

The query Analyzer screen displays summary information for all executing queries and helps you identify problematic queries, such as hot queries with cumulative execution time counters, slow queries, and deadlocks caused by two or more queries blocking each other. You will find the latest deadlock query at the top of the screen:

You can view previous deadlocks by clicking the View all button. Doing so opens the deadlock page. It displays all deadlocks detected on the selected instance:

All monitored instances are displayed in the left pane. Selecting an instance causes a deadlock for that instance. You can filter the list by providing a value in the search deadlock text box.

By default, the deadlock list is automatically refreshed every 5 seconds. You can change the automatic refresh time using the Refresh time drop-down menu. To pause automatic refresh, click the pause button:

You can also set the number of rows to display through the number of rows to display drop-down menu.

Conclusion

In today's article, we learned how to use Navicat Monitor to discover bottlenecks and deadlocks in MySQL 8.

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.