BestHub
Sign in
Tag

Batch Delete

0 views collected around this technical thread.

IT Services Circle
IT Services Circle
May 6, 2025 · Databases

Efficient Strategies for Deleting Massive Data from Large Tables

This article explains the risks of bulk deletions on million‑row tables and provides a step‑by‑step guide—including pre‑deletion planning, indexing, backup, batch deletion, partitioning, table recreation, TRUNCATE, and post‑deletion verification—to safely and quickly remove large volumes of data while minimizing lock contention, log growth, CPU spikes, replication lag, and rollback complications.

BackupBatch DeleteSQL
0 likes · 11 min read
Efficient Strategies for Deleting Massive Data from Large Tables
Selected Java Interview Questions
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
Wukong Talks Architecture
Wukong Talks Architecture
Sep 27, 2022 · Databases

MySQL Large Table Index Optimization and Delete Performance Tuning

This article analyzes a MySQL large‑table performance issue caused by slow queries and full‑table scans, demonstrates using pt‑query‑digest, explains execution plans, proposes index redesign, shows backup and restore with mydumper, compares online DDL and pt‑osc, and presents batch delete strategies to reduce latency.

BackupBatch DeleteDDL
0 likes · 13 min read
MySQL Large Table Index Optimization and Delete Performance Tuning
Laravel Tech Community
Laravel Tech Community
May 18, 2020 · Databases

MySQL Large‑Table Index Optimization and Delete Performance Improvement

This article analyzes a MySQL master‑slave instance with a massive arrival_record table, identifies slow‑query causes using pt‑query‑digest and tcpdump, proposes index redesign, demonstrates backup/restore with mydumper, compares online DDL and pt‑osc, and presents batch‑delete strategies that dramatically reduce SLA‑triggering latency.

BackupBatch DeleteIndex Optimization
0 likes · 14 min read
MySQL Large‑Table Index Optimization and Delete Performance Improvement