Tag: Optimization

6 articles

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.