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

Download the latest version of Navicat Monitor

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.

Query Analyzer part

The Navicat Monitor for MySQL/MariaDB's Query Analyzer tool provides a graphical representation of the query log, making it easier to interpret its contents. In addition, the query Analyzer tool enables you to monitor and optimize query performance, visualize query activity statistics, analyze SQL statements, and quickly identify and resolve long-running queries. The previous article outlined this useful feature and described how to take full advantage of the latest Deadlock Query and Process List screen sections. This article will introduce all the information about the screen section of query Analyzer.

Work flow

Query Analyzer collects information about query statements using one of three methods:

Retrieve the general query log from the server and analyze its information.

Retrieve the slow query log from the server and analyze its information.

Query the performance schema database and analyze it for specific performance information.

With regard to performance mode, it has been introduced in MySQLServer5.5.3. It normalizes the query and truncates it to a length of 1024 bytes. In addition, similar queries with the only difference in text values have been merged. Finally, use the question mark (? Replace quoted values and numbers .

The latest Deadlock Query and Process List sections discussed in the previous article find the query Analyzer section below:

The query Analyzer section itself is divided into two subsections: Top 5 Queries and Query Table. Let's take a look now.

Top 5 Queries

This section will show the top five most time-consuming queries, as well as a color-coded doughnut diagram, which will give you an instant snapshot of potential problems. You can click the Refresh button at any time to update the list of the first five queries.

The Top 5 Queries section contains the following fields:

Top 5 Queries Based on Total Time: query statement.

Count: the number of times the query was executed.

Total Time: query the cumulative execution time of all execution.

The source of the query data is displayed in the drop-down list next to the section title. You can select another source from the list.

Query Table

The query table provides summary information for all executed queries. The calculated statistics include the count, the number of queries that occurred, the total time, and many other statistics.

It has many useful features:

You can hover over the query to display the complete query statement, and then click Copy Query to copy it.

Click Show / Hide Columns and select the columns to hide. Select Restore Default to restore the table to its default settings.

You can filter and sort queries. Simply enter a search string in the search query box to filter the table, and then click the column name to sort the table.

To change the number of queries per page, click Rows to Displa, and then select a value from the list.

To change the total number of queries in the table, click Total no. Of Queries, and then select a number from the list

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.