Pada Thu, 25 Jul 2002 22:27:50 +0300
Andrew Sitnikov <sitnikov@stripped> menulis :
> Hello mysql,
>
> Why after TRUNCATE TABLE data file with indexes not freed ?
> and TRUNCATE TABLE is very slow ...
>
> MySQL 3.23.51+InnoDB
> OS: Linux 2.4.18/ReiserFS
it's better (faster) to do it this way :
- mysqldump -d -p <DB> <table> > file.sql
- cd <mysql_data_dir>/<db_dir>
- rm <table_name>.* ....... or
- mv <table_name>.* <to_somewhere_else>
- mysql -p <DB> < file.sql
--
printk("??? No FDIV bug? Lucky you...\n");
2.2.16 /usr/src/linux/include/asm-i386/bugs.h
MySQL 3.23.51 : up 34 days, Queries : 354.789 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web : http://1rstwap.com