Navicat Premium common functions

Navicat Premium common functions

Navicat Premium common functions

1. Shortcut Keys
1.1. F8 quickly returns to the current Object List
1.2. Press Ctrl + q to open the query interface
1.3. Ctrl + d quickly modify the current table structure
1.4. Ctrl + r run the SQL statement on the current query interface
1.5. Ctrl + shift + r run the selected SQL statement

2. view the table structure quickly
2. 1. Right-click table information-> select Object Information

2. Right-click the table information and choose object information. Select DDL information.

3. Tools
3. 1. Data Transmission: copying data from one database to another
. Data Synchronization: As the name implies, the data of the two databases is synchronized.
3. structure synchronization: the data structure of the two databases must be consistent.

3. 4. Copy the current record as an insert statement

4. Monitoring
. Enable monitoring

. Select the mysql database you want to monitor
. Monitor the status of the current server to find the SQL statements that are currently taking a long time

5. SQL statement Performance Analysis
5. 1. check the SQL statement execution time. If the execution time is too long, it is definitely a problem. Generally, the execution time of an SQL statement should be controlled within 0.01 seconds. If the execution time is later than this time, this SQL statement or the table structure of the table needs to be optimized, as shown in

. Check the SQL Execution Plan, that is, whether the index is used during the SQL Execution.

. Check the SQL overview and the time consumption ratio of each process during SQL Execution.

Of course, there are many other optimization methods, such as creating indexes for tables and partitioning tables ..., You need to find the answer carefully.

This article permanently updates the link address: