In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-28 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
This article mainly introduces the method of query optimization by navicat, which has certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.
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.
One of the main complaints of database administrators (DBA) about general and slow query logs is that their contents are difficult to read. The solution is to use navicat monitor for mysql/mariadb logs. Its query Analyzer tool provides a graphical representation of query logs, enabling you to monitor and optimize query performance, visualize query activity statistics, analyze SQL statements, and quickly identify and resolve long-running queries.
Query Analyzer
To start using Query Analyzer, select the instance you want to analyze in the left pane:
You can also narrow the list to the instance you are looking for by entering a name in the search field:
After selecting an instance, the analysis begins immediately. After a short period of time, the analysis results are displayed:
The screen is divided into the following sections:
Latest Deadlock Query: displays the transaction information for the latest Deadlocks detected in the selected instance.
Process List: displays the total number of processes running on the selected instance and lists the last five processes, including ID, command type, user, database, and time information.
Query Analyzer: displays information about query statements with customizable and sortable sequences.
Latest Deadlock Query
If you want to see more than just latest deadlock, you can click the View all button. This 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 results in a Deadlocks for that instance. You can filter the list by providing a value in the Search for a deadlock text box.
By default, the Deadlocks 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 Rows to Display drop-down menu.
Schedule
You can click View all to view all processes.
The Process List page displays all processes currently running on the selected instance. You can check the query that is currently executing. The process list provides the following details:
(1) ID: thread ID.
(2) User@Host: the user who issued the statement.
(3) DB: the database currently used by the user.
(4) Command: the type of command issued by the user.
(5) Time: the time in seconds that the thread is in its current state.
(6) State: indicates the status of the operation being performed by the thread.
(7) Info: a statement issued by the user.
Like Deadlocks, all monitored instances are displayed in the left pane, where you can select an instance to display a list of its processes. Like Deadlocks, the process list is automatically refreshed every 5 seconds. It also includes a refresh time drop-down menu to change the automatic refresh time. Click the pause button to pause the automatic refresh.
You can filter and sort the list of threads. Simply enter a search string in the search thread box to filter the list, and then click the column name to sort the list. In addition, clicking the row to display and selecting a predefined number changes the number of threads displayed per page.
Terminate the process
In addition to displaying the currently running processes, you can stop the thread immediately by clicking the Action column and then clicking End Process in the pop-up dialog box:
Thank you for reading this article carefully. I hope it will be helpful for everyone to share the methods and contents of navicat query optimization. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!
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.
Views: 263
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.