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



> On 26 Nov 2002, at 8:52, Pae Choi wrote:
> 
> > Q: How come the size of table does not decrease
> >     after deletion?
> 
> MySQL will reuse that space when you insert new records.  To recover 
> the space, you need to optimize the table:
> 
> http://www.mysql.com/doc/en/OPTIMIZE_TABLE.html
> 
> 
> > P.S.: MySQL, SQL, and Query(to clarify that it's not
> > spam nor OT).
> 
> 
> -- 
> Keith C. Ivey <keith@stripped>
> Tobacco Documents Online
> http://tobaccodocuments.org
> Phone 202-667-6653

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