The JusDB Database Engineering Blog

Master MySQL index data structures and optimization strategies. Learn B+ tree internals, index selection, covering indexes, and real-world performance case studies.

Build full-text search with MongoDB Atlas Search — analyzers, scoring, autocomplete, and relevance tuning

A production guide to MySQL full-text search — FULLTEXT index creation, MATCH AGAINST in natural language and boolean modes, the 50% rule, InnoDB vs MyISAM FTS, combining with B-tree indexes, and comparison against Elasticsearch.

Deep dive into advanced database indexing strategies including composite indexes, covering indexes, and partial indexes. Optimize query performance with expert indexing techniques.

MySQL 8.0 finally supports true descending indexes — eliminating the filesort that MySQL 5.7 required when sorting results in descending order. Here's how descending indexes work and when to add them.