At 10:36 -0800 11/26/02, Pae Choi wrote:
>First of all, thanks for your reply as well as a pointer to the Doc.
>I tried the "OPTIMIZE" command as follows:
>mysql> optimize table gallery;
>mysql> optimize table gallery2;
>Both does not contain any entry since I deleted the BLOB data.
>But the size of tables, "gallery.db" and "gallery2.db" does not
>decresed. It remains as it was.
>Any comments? Thanks.
>P.S.: The table is created with "type=bdb" option as:
> CREATE TABLE ... TYPE=BDB;
OPTIMIZE performs defragmentation only for MyISAM tables.
You can shrink your tables by dumping and reloading them:
mysqldump --opt db_name gallery gallery2 > dump.sql
mysql db_name < dump.sql