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

This article mainly introduces the common functions of Navicat Premium, which has a certain reference value, friends who need can refer to it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

Explanation of common functions of Navicat Premium

1. Shortcut key

(1) F8 quickly returns to the current object list

(2) Ctrl + Q opens the query interface

(3) Ctrl + d quickly modify the current table structure

(4) Ctrl + r runs the sql statement in the current query interface

(5) Ctrl + shift + r runs the currently selected sql statement

2. Quickly view the table structure

(1) right-click table information-> Select object information

(2) right-click table information-> Select object information-> Select DDL information

3. Tools

(1) data transfer: to copy the data from one database to another.

(2) data synchronization: as the name implies, the data of the two databases are kept synchronized.

(3) structural synchronization: the name matter is to keep the data structure of the two databases consistent.

(4) copy the current record as an insert statement

4. Monitoring function

(1) turn on monitoring

(2) check the mysql database that you need to monitor

(3) monitor the status of the current server and find out the sql statements that take a long time.

5. Performance analysis of sql statements.

(1) if you look at the execution time of the sql statement, there must be a problem if the time is too long. In general, the execution time of a sql statement should be controlled within 0.01s. If it is longer than this time, then the sql statement or the table structure of the table needs to be optimized, as shown in the following figure:

(2) look at the execution plan of the sql, that is, whether the index is used in the execution of the sql, and so on.

(3) look at the general situation of sql and see the time-consuming proportion of each process in the implementation of this sql.

(4) check the execution process of mysql and deal with the situation of locking table. Command show PROCESSLIST,state is LOCKED, indicating that lock table is generated, ID is process id, and you can stop this process by executing kill ID directly.

Thank you for reading this article carefully. I hope the editor will share what the common functions of Navicat Premium are helpful to you. 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.