Hi.
On Fri 2002-07-26 at 11:03:26 +0300, [EMAIL PROTECTED] wrote:
> Hello Benjamin,
>
> >> Why after TRUNCATE TABLE data file with indexes not freed ?
> BP> See http://www.mysql.com/doc/A/d/Adding_and_removing.html (2nd paragraph)
> BP> and
>http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#InnoDB_File_space
> BP> (second link does not work in the searchable doc, whyever)
> >> and TRUNCATE TABLE is very slow ...
> BP> See http://www.mysql.com/doc/T/R/TRUNCATE.html
> BP> and http://www.mysql.com/doc/I/n/InnoDB_restrictions.html
> BP> (in short: because it's InnoDB on 3.23, it's deleting all rows
> BP> seperately)
> All my tables has MyISAM type, but server running with InnoDB support.
Then this section still applies, because the behaviour was compiled in
regarding InnoDB support, not InnoDB tables (don't know anymore where
I read it, probably some release notes).
Greetings,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
