Tagged articles

DROP TABLE

4 articles · Page 1 of 1

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

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.

DROP TABLEInnoDBMySQL

0 likes · 13 min read

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

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 PoolDROP TABLEIO

0 likes · 10 min read

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

MaGe Linux Operations

May 16, 2016 · Databases

How to Speed Up Dropping Large MySQL Tables and Avoid IO Bottlenecks

This article explains why dropping large MySQL tables can heavily impact server I/O, compares ext3 and ext4 file‑system behavior, and provides a step‑by‑step method using hard links and the truncate tool to minimize downtime and I/O load.

DROP TABLEDatabase operationsHard Link

0 likes · 6 min read

How to Speed Up Dropping Large MySQL Tables and Avoid IO Bottlenecks