SQL Performance Archives - ITFROMZERO

A Guide to Configuring Table Partitioning in MySQL: Boosting Large Table Performance with RANGE and LIST

By IT From Zero October 25, 2026

Are tables over 50 million rows causing sluggish queries and crushing your database during DELETE operations? Table Partitioning (RANGE & LIST) in MySQL isolates data across partitions, accelerates query speeds, and reclaims disk space in seconds.

MySQL

MySQL Prefix Indexes: The ‘Weight Loss’ Secret for Indexes Without Sacrificing Speed

By IT From Zero August 18, 2026

Don't let indexes become a burden on your hard drive. Discover how to use Prefix Indexes in MySQL to speed up queries and save memory for long data columns.

MySQL

MySQL Hash Join: A Lifesaver for Queries Lacking Indexes on MySQL 8.0.18+

By IT From Zero July 30, 2026

What is MySQL Hash Join? Learn how it works, how to configure join_buffer_size, and practical tips to significantly speed up JOIN queries lacking indexes.

MySQL

MySQL 8: Leveraging Functional and Invisible Indexes to Handle Millions of Records

By IT From Zero April 22, 2026

Discover how to optimize MySQL 8 with Functional and Invisible Indexes. Speed up JSON and date queries while safely testing indexes in production environments.