Gleam Lab · Tag Archive

Tag: 优化

6 articles collected by topic for tutorials, cases, engineering practice, and research notes.

MySQL Slow Query Analysis and Optimization Guide

Slow query log, mysqldumpslow, EXPLAIN analysis, common optimization solutions.

MySQL Index and Sorting: Filesort and Index Sort

filesort sorting, index sorting, two-pass sorting, single-pass sorting, clustered index and secondary index sorting.

MySQL Index Optimization: Table Lookup, Covering Index, Leftmost Prefix and LIKE

Table lookup queries, covering index, leftmost prefix principle, LIKE queries, NULL value handling.

MySQL EXPLAIN: Index Analysis and Query Optimization

EXPLAIN command: selecttype, type, possiblekeys, key, rows, key_len, Extra.

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.

MySQL Connection, Thread, Query Cache and Optimizer Deep Dive

MySQL connection mechanism, half-duplex communication, query cache, query optimizer explained.