MySQL Viewing Status and simple Optimization

Use the show status Command

Meaning:
Number of times the aborted_clients client has been disconnected illegally
Aborted_connects connection failure count
The number of times the com_xxx xxx command is executed. There are many
Number of connections from connections to mysql
Created_tmp_disk_tables temporary table created on the disk
Created_tmp_tables temporary table created in memory
Created_tmp_files temporary files
Key_read_requests The number of requests to read a key block from the cache
Key_reads The number of physical reads of a key block from disk
Number of connections simultaneously used by Max_used_connections
Open_tables open tables
Open_files files
Opened_tables Open Table
Number of queries submitted by Questions to the server
Sort_merge_passes if the value is large, you should increase the sort_buffer value in my. cnf.
The number of seconds that the Uptime server has been working on.

Suggestions for improving performance:
1. If opened_tables is too large, increase table_cache in my. cnf.
2. If Key_reads is too large, you should increase the key_buffer_size in my. cnf. You can use Key_reads/Key_read_requests to calculate the cache failure rate.
3. If Handler_read_rnd is too large, many of the SQL statements you write need to scan the entire table, but do not use the index key.
4. If Threads_created is too large, you need to increase the value of thread_cache_size in my. cnf. You can use Threads_created/Connections to calculate the cache hit rate.
5. If Created_tmp_disk_tables is too large, you need to increase the value of tmp_table_size in my. cnf and replace the disk-based temporary table with a memory-based temporary table.