List:General Discussion« Previous MessageNext Message »
From:Benjamin Pflugmann Date:July 26 2002 3:16am
Subject:Re: TRUNCATE TABLE
View as plain text  
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
Thread
TRUNCATE TABLEAndrew Sitnikov25 Jul
  • Re: TRUNCATE TABLEDicky Wahyu Purnomo26 Jul
  • Re: TRUNCATE TABLEBenjamin Pflugmann26 Jul
    • Re[2]: TRUNCATE TABLEAndrew Sitnikov26 Jul
      • Re: Re[2]: TRUNCATE TABLEBenjamin Pflugmann26 Jul
    • Re[2]: TRUNCATE TABLEAndrew Sitnikov26 Jul
      • Re: Re[2]: TRUNCATE TABLEBenjamin Pflugmann26 Jul
        • Re[4]: TRUNCATE TABLEAndrew Sitnikov28 Jul
          • Re: Re[4]: TRUNCATE TABLEBenjamin Pflugmann29 Jul