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 <[EMAIL PROTECTED]>
> Tobacco Documents Online
> http://tobaccodocuments.org
> Phone 202-667-6653
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
