Table Partitioning 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

Table Partitioning in MySQL: Accelerating Queries and Efficiently Managing Large Datasets

By IT From Zero March 21, 2026

MySQL Table Partitioning is key to improving query performance and efficiently managing massive datasets. This article shares practical implementation experience on MySQL 8.0, along with step-by-step guidance and essential considerations.