List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 26 2002 6:59pm
Subject:Re: [MySQL v3.23.53a] BLOB Data and Table Size
View as plain text  
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.
>
>
>Pae
>
>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

Thread
[MySQL v3.23.53a] BLOB Data and Table SizePae Choi26 Nov
  • Re: [MySQL v3.23.53a] BLOB Data and Table SizeKeith C. Ivey26 Nov
    • Re: [MySQL v3.23.53a] BLOB Data and Table SizePae Choi26 Nov
      • Re: [MySQL v3.23.53a] BLOB Data and Table SizePaul DuBois26 Nov
    • Re: [MySQL v3.23.53a] BLOB Data and Table SizePae Choi26 Nov
  • re: [MySQL v3.23.53a] BLOB Data and Table SizeEgor Egorov26 Nov
  • Re: [MySQL v3.23.53a] BLOB Data and Table SizeJohn Ragan26 Nov