MySQL study note 8

Show status like 'value'; query the performance of the MySQL database.
Value Parameter
• Connections: Number of times the MySQL server is connected
• Uptime: MySQL Server launch time
• Slow_queries: Number of slow queries
• Com_lelect: number of queries
• Com_insert: Number of insert operations
• Com_delete: Number of delete operations
1. Query the connection times of the MySQL server: show status like 'connections ';
2. Optimize Query
3. Index impact on query speed
4. Use index Query

Optimize database structure

Analysis table
Basic Syntax: analyze table name 1 [TABLE name 2...];

Checklist
Basic Syntax: check table name 1 [, TABLE name 2] [option]
Check whether errors exist in tables of the InnoDB and MyISAM types. In addition, this statement can also check whether errors exist in views.

Optimization table
Use the optimize table statement in MySQL to OPTIMIZE the TABLE. Basic Syntax: optimize tables table Name 1 [TABLE name 2...];
The optimize table statement can be used to eliminate disk fragments caused by deletion and update, thus reducing the waste of space. This statement also adds a read-only lock to the table during execution.

Query high-speed cache

Optimize multi-table queries

Optimize Table Design