Tag: Optimization
6 articles
MySQL Slow Query Analysis and Optimization Guide
Slow query log, mysqldumpslow, EXPLAIN analysis, common optimization solutions. This article provides in-depth analysis of principles and practical applications.
MySQL Index and Sorting: Filesort and Index Sort
filesort sorting, index sorting, two-pass sorting, single-pass sorting, clustered index and secondary index sorting. This article provides in-depth analysis of principles and practical applications.
MySQL Index Optimization: Table Lookup, Covering Index, L...
Table lookup queries, covering index, leftmost prefix principle, LIKE queries, NULL value handling. This article provides in-depth analysis of principles and practical applications.
MySQL EXPLAIN: Index Analysis and Query Optimization
EXPLAIN command: select_type, type, possible_keys, key, rows, key_len, Extra. This article provides in-depth analysis of principles and practical applications.
MySQL Index Types: BTree, Hash, FULLTEXT, RTree Explained
Index types: BTree, Hash, FULLTEXT, RTree, regular index, unique index, primary key index, composite index, clustered index. This article provides in-depth analysis of principles and practical appl...
MySQL Connection, Thread, Query Cache and Optimizer Deep ...
MySQL connection mechanism, half-duplex communication, query cache, query optimizer explained. This article provides in-depth analysis of principles and practical applications.