Database Insights
Expert insights on database management, performance optimization, and reliability engineering from industry professionals
Popular Searches
Latest Articles
Showing 3 of 27 articles
MySQL Full-Text Search: FULLTEXT Indexes, MATCH AGAINST, and Boolean Mode
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.
Advanced Indexing Strategies for Database Scalability
Deep dive into advanced database indexing strategies including composite indexes, covering indexes, and partial indexes. Optimize query performance with expert indexing techniques.
Descending Indexes in MySQL 8.0: When and How to Use Them
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.
Get the latest database insights and expert tips delivered to your inbox.
Subscribe to our RSS feed for instant updates.
RSS Feed