e.myodbc
Sent: Friday, May 21, 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 eve
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
