Hi.
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)
and
http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#InnoDB_File_space
(second link does not work in the searchable doc, whyever)
> and TRUNCATE TABLE is very slow ...
See http://www.mysql.com/doc/T/R/TRUNCATE.html
and http://www.mysql.com/doc/I/n/InnoDB_restrictions.html
(in short: because it's InnoDB on 3.23, it's deleting all rows
seperately)
> MySQL 3.23.51+InnoDB
> OS: Linux 2.4.18/ReiserFS
If those pages do not fit to your problem, elaborate.
Greetings,
Benjamin.
--
benjamin-mysql@stripped
