BestHub
Sign in
Tag

Drop Table

0 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 26, 2024 · Databases

Performance Issues of TRUNCATE/DROP TABLE in MySQL and Their Historical Fixes

This article reviews the long‑standing performance problems of TRUNCATE and DROP TABLE in MySQL, tracing their origins through official manuals and historical bugs, summarizing the optimizations introduced in MySQL 5.5.23, 5.7, 8.0, and 8.4, and offering practical guidance for mitigating remaining latency.

Adaptive Hash IndexDrop TableInnoDB
0 likes · 12 min read
Performance Issues of TRUNCATE/DROP TABLE in MySQL and Their Historical Fixes
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 19, 2023 · Databases

Analysis of Slow TRUNCATE and DROP TABLE Operations in MySQL 5.7 and 8.0

This article investigates why TRUNCATE and DROP TABLE statements appear in MySQL slow‑query logs, analyzes the internal execution paths and performance bottlenecks in MySQL 5.7 and 8.0, and proposes configuration‑based optimizations and debugging techniques to mitigate the latency.

Database OptimizationDrop TableInnoDB
0 likes · 13 min read
Analysis of Slow TRUNCATE and DROP TABLE Operations in MySQL 5.7 and 8.0
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 20, 2023 · Databases

Safely Dropping a Large MySQL history_str Table to Reclaim Disk Space

This article describes a step‑by‑step procedure for safely dropping a massive MySQL history_str table—including creating a new table, renaming, using hard links, staged drops, and a truncate script—to avoid instance hangs, replication lag, and I/O pressure while freeing disk space.

DBADisk SpaceDrop Table
0 likes · 9 min read
Safely Dropping a Large MySQL history_str Table to Reclaim Disk Space
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 14, 2022 · Databases

Performance Impact of Dropping Large Tables in MySQL 5.7 and 8.0: Bug Analysis and Mitigation

This article investigates a historical MySQL bug where dropping large tables with a sizable buffer pool and Adaptive Hash Index (AHI) can cause severe latency, presents test configurations for 5.7.29 and 8.0.28, compares AHI‑on/off results, shows stack traces, and explains the lazy‑delete fix introduced in 8.0.23.

Adaptive Hash IndexBuffer PoolDrop Table
0 likes · 24 min read
Performance Impact of Dropping Large Tables in MySQL 5.7 and 8.0: Bug Analysis and Mitigation
Tencent Database Technology
Tencent Database Technology
Dec 14, 2017 · Databases

Performance Bottlenecks and Mitigation Strategies for MySQL DROP TABLE on Large InnoDB Tables

The article analyzes why dropping large InnoDB tables in MySQL can drastically degrade overall database performance due to buffer‑pool mutex and file‑system I/O bottlenecks, and presents both operational work‑arounds and source‑code modifications to alleviate the issue.

Buffer PoolDatabase OptimizationDrop Table
0 likes · 10 min read
Performance Bottlenecks and Mitigation Strategies for MySQL DROP TABLE on Large InnoDB Tables