Tag

time-based partition

1 views collected around this technical thread.

Aikesheng Open Source Community

Feb 16, 2022 · Databases

Advanced MySQL Time-Based Partitioning: SQL Writing Tips and Optimization

This article extends the previous discussion on MySQL time‑based partition implementation by detailing how to write efficient SQL queries, demonstrating partition pruning with supported functions, and offering practical optimization techniques for tables that use unsupported partition functions.

Database performanceMySQLPartition Pruning

0 likes · 10 min read

Advanced MySQL Time-Based Partitioning: SQL Writing Tips and Optimization

Aikesheng Open Source Community

Dec 27, 2021 · Databases

Time-Based Partitioning Strategies in MySQL: Year, Month, and Day Granularity

This article explains how to use MySQL native partitioning to split tables by time fields—year, month, or day—detailing the SQL syntax, partition creation steps, performance impacts, and best‑practice tips for each granularity.

Database OptimizationMySQLSQL

0 likes · 13 min read

Time-Based Partitioning Strategies in MySQL: Year, Month, and Day Granularity