On Thu 2002-07-25 at 22:27:50 +0300, sitnikov@stripped wrote:
> Hello mysql,
> Why after TRUNCATE TABLE data file with indexes not freed ?
See http://www.mysql.com/doc/A/d/Adding_and_removing.html (2nd paragraph)
(second link does not work in the searchable doc, whyever)
> and TRUNCATE TABLE is very slow ...
(in short: because it's InnoDB on 3.23, it's deleting all rows
> MySQL 3.23.51+InnoDB
> OS: Linux 2.4.18/ReiserFS
If those pages do not fit to your problem, elaborate.