Re[2]: TRUNCATE TABLE

2002-07-27 Thread Andrew Sitnikov
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 th

Re: Re[2]: TRUNCATE TABLE

2002-07-26 Thread Benjamin Pflugmann
Hi. First, when you start an independend question, please start a new thread, but at least change the subject accordingly. On Fri 2002-07-26 at 11:07:17 +0300, [EMAIL PROTECTED] wrote: [...] > If table recreated from table.frm why it not recreate indexes file? Because this is the documented beh

Re: Re[2]: TRUNCATE TABLE

2002-07-26 Thread Benjamin Pflugmann
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/