Tagged articles

7 articles

Page 1 of 1

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 OptimizationLarge Tables

0 likes · 14 min read

MySQL Large Table Index Optimization and Batch Deletion Strategies

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

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 OptimizationLarge Tables

0 likes · 14 min read

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

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 DeletionLarge TablesOnline DDL

0 likes · 16 min read

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

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 OptimizationLarge Tables

0 likes · 8 min read

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

Aikesheng Open Source Community

Apr 28, 2021 · Databases

Using pt-archiver for Batch Deletion of Large MySQL Tables

The article explains why massive MySQL tables need periodic cleanup, compares risky drop/truncate approaches, and provides a step‑by‑step guide to safely delete historical data in batches using pt‑archiver with proper parameters, session handling, and post‑deletion maintenance.

Batch DeletionSQLdata cleanup

0 likes · 7 min read

Using pt-archiver for Batch Deletion of Large MySQL Tables

FunTester

Aug 20, 2020 · Backend Development

Efficiently Deleting Tens of Thousands of Records via API: Serial, Async, and Multithreaded Solutions

Faced with tens of thousands of dirty records and no bulk‑delete API, the author iteratively optimized a deletion script—starting with simple serial requests, then adding asynchronous HTTP calls, and finally employing multithreading—to achieve rapid, reliable removal of hundreds of entries per second.

APIAsynchronousBatch Deletion

0 likes · 6 min read

Efficiently Deleting Tens of Thousands of Records via API: Serial, Async, and Multithreaded Solutions