Large Tables | BestHub

Java Tech Enthusiast

Apr 4, 2025 · Databases

MySQL Large Table Index Optimization and Batch Deletion Strategies

By dropping a low‑selectivity composite index, adding targeted indexes on product_id‑sequence‑station_no and receive_time, and using online DDL with pt‑osc, the team reduced row scans and replication lag, then implemented batch deletions by primary‑key ranges, cutting delete time from minutes to seconds on a 100‑million‑row table.

Index OptimizationLarge TablesMySQL

0 likes · 14 min read

MySQL Large Table Index Optimization and Batch Deletion Strategies

Top Architect

Apr 11, 2024 · Databases

MySQL Slow Query Analysis and Index Optimization for Large Tables

This article presents a detailed investigation of a MySQL master‑slave instance suffering from nightly SLA alerts due to slow‑query latency, analyzes the root causes with pt‑query‑digest and execution plans, proposes index redesign, demonstrates backup and restore with mydumper, compares online DDL and pt‑osc, and finally shows batch‑delete techniques to reduce load on large tables.

Index OptimizationLarge TablesMySQL

0 likes · 16 min read

MySQL Slow Query Analysis and Index Optimization for Large Tables

Code Ape Tech Column

Feb 22, 2023 · Databases

Managing Large MySQL Tables: Evaluation, Root Causes, and Optimization Strategies

This article explains how to assess MySQL table size, why massive tables degrade performance due to B+‑tree depth, and presents three practical solutions—table partitioning, database sharding, and hot‑cold data archiving—along with guidance on selecting the appropriate approach.

Cold ArchivingLarge TablesMySQL

0 likes · 14 min read

Managing Large MySQL Tables: Evaluation, Root Causes, and Optimization Strategies

Selected Java Interview Questions

Nov 12, 2022 · Databases

MySQL Large‑Table Index Optimization and Maintenance Strategies

This article analyzes performance problems of a massive MySQL table, demonstrates how to use pt‑query‑digest and EXPLAIN to identify inefficient composite indexes, proposes index redesign, compares online DDL with pt‑osc for index rebuilding, and presents batch‑delete techniques to reduce SLA‑impacting latency.

Batch DeleteDDLIndex Optimization

0 likes · 14 min read

MySQL Large‑Table Index Optimization and Maintenance Strategies

IT Services Circle

Jul 8, 2022 · Databases

Safely Deleting Massive Tables: Avoid Long Transactions with Batch SQL and Insert‑Instead Strategies

This article explains why executing a single DELETE on a half‑billion‑row table can cause long‑running transactions, lock contention, and replication lag, and demonstrates how to split the operation into indexed batch deletes or replace it with an insert‑into‑new‑table workflow to improve safety and performance.

Database OptimizationLarge TablesSQL

0 likes · 8 min read

Safely Deleting Massive Tables: Avoid Long Transactions with Batch SQL and Insert‑Instead Strategies

Architect's Tech Stack

Mar 15, 2021 · Databases

Optimizing a 20‑Million‑Row MySQL Table: Design, Indexing, Partitioning, and Migration Strategies

This article describes how to improve the performance of a massive MySQL 5.6 user‑log table by redesigning schema, applying proper indexes, using partitioning, considering table sharding, and evaluating upgrade paths to compatible cloud or big‑data databases, with concrete SQL examples and cost analysis.

Cloud DatabasesDatabase OptimizationIndexing

0 likes · 16 min read

Optimizing a 20‑Million‑Row MySQL Table: Design, Indexing, Partitioning, and Migration Strategies

Nightwalker Tech

Sep 26, 2016 · Databases

[Interview Question] How to Add an Index to a Tens‑Millions‑Row Table Without Downtime

The discussion explores practical strategies for adding an index to a MySQL table containing tens of millions of rows without stopping service, covering intermediate tables, double‑write syncing, rename operations, traffic considerations, lock types, and tooling such as Percona.

IndexingLarge TablesMySQL

0 likes · 8 min read

[Interview Question] How to Add an Index to a Tens‑Millions‑Row Table Without Downtime