List:General Discussion« Previous MessageNext Message »
From:Pae Choi Date:November 26 2002 10:31pm
Subject:Re: [MySQL v3.23.53a] BLOB Data and Table Size
View as plain text  
Paul,

It really did the trick. Thanks.

Regards,


Pae

----- Original Message -----
From: "Paul DuBois" <paul@stripped>
To: "Pae Choi" <paechoi@stripped>; "Keith C. Ivey" <keith@stripped>;
<mysql@stripped>
Sent: Tuesday, November 26, 2002 10:59 AM
Subject: Re: [MySQL v3.23.53a] BLOB Data and Table Size


> 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