MySQL, Query, Optimization, Web Performance, Database.
3, binary log 4, the process list SHOW FULL PROCESSLIST; . . . 3. Query optimization basic analysis command 1, EXPLAIN {PARTITIONS|EXTENDED} 2, SHOW CREATE TABLE tab; 3, SHOW INDEXS FROM tab; 4, SHOW TABLE STATUS LIKE ‘tab’; 5, SHOW [GLOBAL|SESSION] STATUS LIKE ‘’; 6, SHOW VARIABLES . . . . 4.