View MySQL running status

Use the show STATUS Command MySQL will give a long list Official Instructions in http://www.mysql.com/doc/e... 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.