BestHub
Sign in
Tagged articles
10 articles
Page 1 of 1
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.

Batch DeletePartitioningSQL
0 likes · 11 min read
Efficient Strategies for Deleting Massive Data from Large Tables
Liangxu Linux
Liangxu Linux
Feb 6, 2025 · Operations

Batch Delete Linux Users with UID ≥ 1000 Using awk and xargs

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 DeleteLinuxShell
0 likes · 5 min read
Batch Delete Linux Users with UID ≥ 1000 Using awk and xargs
Open Source Tech Hub
Open Source Tech Hub
Sep 25, 2024 · Databases

How to Safely Delete Large Log Tables and Resolve MySQL Read‑Replica Lag

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 MaintenanceRDS
0 likes · 6 min read
How to Safely Delete Large Log Tables and Resolve MySQL Read‑Replica Lag
Architect
Architect
Apr 29, 2024 · Databases

How to Slash MySQL Slow Queries on a 100M‑Row Table: Index Tuning and Batch Deletion

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
How to Slash MySQL Slow Queries on a 100M‑Row Table: Index Tuning and Batch Deletion
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.

Batch DeleteDDLDatabase Performance
0 likes · 13 min read
MySQL Large Table Index Optimization and Delete Performance Tuning
21CTO
21CTO
Jul 9, 2020 · Databases

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

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
How to Optimize Large MySQL Tables: Index Tuning, Online DDL, and Efficient Deletion
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
Java Backend Technology
Java Backend Technology
Apr 5, 2020 · Databases

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

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 DeleteOnline DDLSlow query analysis
0 likes · 16 min read
How to Optimize Massive MySQL Tables: Index Tuning, Online DDL, and Batch Deletion