Dev.to

Lessons from the Trenches: Indexing a 200M Row Table in MySQL [MySQL part 2]

TL;DR Slow queries? Check your indexes first. Use EXPLAIN and the slow query log to guide indexing decisions. Composite indexes only help if you use leading columns. Covering indexes =

Apr 20, 2025 - 07:47
 0
Lessons from the Trenches: Indexing a 200M Row Table in MySQL [MySQL part 2]

TL;DR

  • Slow queries? Check your indexes first.
  • Use EXPLAIN and the slow query log to guide indexing decisions.
  • Composite indexes only help if you use leading columns.
  • Covering indexes =
Read More

Tags:

Previous Article

What creating a simple todo list taught me?

Next Article

Serving Open Graph to Bots at hey.xyz: Our Client-Side SPA Approach

Related Posts

Wireframing: The Blueprint of Digital Design

Wireframing: The Blueprint of Digital Design

Feb 13, 2025  0

Study Notes 4.1.2: What is dbt?

Study Notes 4.1.2: What is dbt?

Feb 25, 2025  0

What is phpMyAdmin

What is phpMyAdmin

Mar 12, 2025  0