大网数据广告活动
服务器运维问答

Does TRUNCATE take a long time on huge tables 10gig+

· 52CE 我爱测

I wonder if it is a good idea to use phpMyAdmin's empty feature on a table with ~12gb on a production server. I don't want to cause too much lag but need to free some disk space. This needs to be done on a Debian powered DELL Ser…

问题原文

原帖链接 · bobble bubble · CC BY-SA 4.0

I wonder if it is a good idea to use phpMyAdmin's empty feature on a table with ~12gb on a production server. I don't want to cause too much lag but need to free some disk space.

This needs to be done on a Debian powered DELL Server:

MySQL 5.1.49 Intel Xeon X3430 @ 2.40Ghz 4GB Memory

Assuming that phpMyAdmin uses TRUNCATE to empty the table. Can I expect several minutes or even hours to truncate the table or is it a rather quick process similar dropping a table?

已采纳解答

原帖链接 · anx · CC BY-SA 4.0

If there are zero transactions locking the table schema, the TRUNCATE TABLE command will finish near-instantaneously. The most i have waited so far was 0.1 seconds for truncating a 25GB table.

In any case, a TRUNCATE TABLE command does not have undesirable side-effects on anything but other maintenance operations. If the server is unable to acquire the necessary exclusive locks, it will block - but not because it requires a large amount of IO or processing - its merely awaiting its turn.

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2018-08-23)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 4.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。