, 2004 4:59 AM
Subject: Mysql 4.1.1, InnoDB - Slow TRUNCATE operations with Multiple
Tablespaces
--=_NextPart_000_0050_01C43F2A.002F6960
Content-Type: text/plain;
charset=us-ascii
Content-Transfer-Encoding: 7bit
Hi everybody,
I'm experiencing that the command TRUNCATE TABLE
Hi everybody,
I'm experiencing that the command TRUNCATE TABLE with InnoDB takes an
extraordinary amount of time on large ( 400MB) tables - ie about 3-4
minutes. In comparison, performing a DROP TABLE then recreating it
takes about 2 seconds. When the truncate operation is performed