BestHub
Sign in
Tagged articles

Batch Deletion

7 articles · Page 1 of 1
Java Tech Enthusiast
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.

Batch DeletionIndex OptimizationMySQL
0 likes · 14 min read
MySQL Large Table Index Optimization and Batch Deletion Strategies
Java High-Performance Architecture
Java High-Performance Architecture
Oct 5, 2022 · Databases

How to Optimize Massive MySQL Tables: Index Tuning, Online DDL, and Batch Deletion Strategies

This article analyzes a large MySQL table with frequent SLA alerts, demonstrates how to identify slow queries using pt‑query‑digest, proposes index redesign and online DDL versus pt‑osc methods, and shows testing, implementation, and batch‑delete techniques to dramatically reduce query time and maintenance overhead.

Batch DeletionDatabase MaintenanceIndex Optimization
0 likes · 17 min read
How to Optimize Massive MySQL Tables: Index Tuning, Online DDL, and Batch Deletion Strategies
21CTO
21CTO
Sep 28, 2022 · Databases

How to Optimize Large MySQL Tables: Index Tuning, Online DDL, and Batch Deletion

This article walks through diagnosing slow‑query problems on a massive MySQL table, reveals index misuse, proposes dropping the old composite index, adding targeted indexes, using online DDL or pt‑osc for schema changes, and applying batch‑delete techniques to reduce latency and storage fragmentation.

Batch DeletionIndex OptimizationMySQL
0 likes · 14 min read
How to Optimize Large MySQL Tables: Index Tuning, Online DDL, and Batch Deletion
Java Backend Technology
Java Backend Technology
Sep 27, 2022 · Databases

Optimizing Massive MySQL Tables: Index Tuning, Online DDL & Batch Deletion

Facing SLA alerts due to slow queries on a billion‑row MySQL table, the article analyzes slow‑query logs, reveals index misuse, and demonstrates how removing a poor composite index, adding targeted indexes, employing online DDL or pt‑osc, and using batch deletions dramatically reduce query times and maintenance overhead.

Batch DeletionMySQLOnline DDL
0 likes · 16 min read
Optimizing Massive MySQL Tables: Index Tuning, Online DDL & Batch Deletion
IT Services Circle
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.

Batch DeletionDatabase OptimizationSQL
0 likes · 8 min read
Safely Deleting Massive Tables: Avoid Long Transactions with Batch SQL and Insert‑Instead Strategies