Tagged articles
Batch Delete
10 articles · Page 1 of 1
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.
Batch DeletePartitioningSQL
0 likes · 11 min read

This guide explains how to identify Linux accounts whose UID is 1000 or higher by parsing /etc/passwd with awk, then pipe the resulting usernames to xargs to invoke userdel ‑r for safe, automated removal of those users and their home directories.
Batch DeleteLinuxawk
0 likes · 5 min read

This guide explains how to regularly purge oversized log tables using time‑based DELETE statements, interprets related cloud RDS and ECS alerts, and offers troubleshooting steps and batch‑deletion techniques to address MySQL read‑replica synchronization delays caused by large transactions.
Batch DeleteDatabase MaintenanceMySQL
0 likes · 6 min read

The article walks through a real‑world MySQL performance case where a 100‑million‑row table caused SLA alerts, analyzes slow‑query logs, demonstrates index redesign, compares online DDL with pt‑osc, and shows how batch deletions by primary key dramatically reduce delete time and replication lag.
Batch DeleteIndex OptimizationLarge Table
0 likes · 15 min read

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

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.
Batch DeleteDDLDatabase Performance
0 likes · 13 min read


21CTOJul 9, 2020 · Databases
This article walks through diagnosing severe SLA alerts caused by slow queries on a massive MySQL table, analyzes query patterns with pt‑query‑digest, redesigns indexes, applies online DDL and pt‑osc for index changes, and demonstrates batch‑delete techniques that dramatically reduce execution time and replication lag.
Batch DeleteIndex OptimizationLarge Tables
0 likes · 15 min read

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.
Batch DeleteIndex OptimizationLarge Table
0 likes · 14 min read

This article walks through diagnosing severe SLA alerts caused by slow queries on a huge MySQL table, using pt‑query‑digest and tcpdump to uncover index misuse, then proposes new composite and single‑column indexes, demonstrates online DDL versus pt‑osc, and shows how batch deletions and efficient backup/restore dramatically reduce execution time and replication lag.
Batch DeleteMySQLSlow Query Analysis
0 likes · 16 min read

When a 370 GB MySQL table containing 4.7 billion rows must purge about 2 billion records matching a specific xxid value but cannot add an index, a divide‑and‑conquer strategy using primary‑key ranges and a Python script for batch deletes offers a safe, space‑saving solution.
Batch DeleteMySQLPython
0 likes · 8 min read
