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.
>> MySQL 3.23.51+InnoDB >> OS: Linux 2.4.18/ReiserFS Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM : (+372) 56491109 --------------------------------------------------------------------- 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
