Optimizing Small‑Scale Product Title Search with MySQL FULLTEXT and Ngram Indexing

This article explains how to efficiently search product titles in a few‑million‑row MySQL table by using built‑in FULLTEXT indexes, jieba‑php tokenization, and the ngram parser, avoiding unnecessary external search engines and providing practical code examples.

FullTextNGramPHP

0 likes · 5 min read

Optimizing Small‑Scale Product Title Search with MySQL FULLTEXT and Ngram Indexing

Code Ape Tech Column

Aug 28, 2020 · Databases

Mastering MySQL Indexes: Types, Pros, Cons, and Implementation Details

This article explains what database indexes are, outlines their advantages and disadvantages, advises when to create or avoid them, compares common index data structures such as B+Tree, Hash, and FullText, and details MySQL's MyISAM and InnoDB index implementations.

B+TreeDatabase PerformanceFullText

0 likes · 17 min read

Mastering MySQL Indexes: Types, Pros, Cons, and Implementation Details

Senior Brother's Insights

Aug 7, 2020 · Databases

Master MySQL Indexes: Syntax, Types, and Optimization Strategies

This comprehensive guide covers MySQL index creation syntax, various index types—including primary, unique, full‑text, and composite—explains their advantages and drawbacks, details underlying B‑Tree and B+Tree structures, and provides practical strategies and optimization tips for effective index usage.

BTreeFullTextindex

0 likes · 19 min read

Master MySQL Indexes: Syntax, Types, and Optimization Strategies