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&g
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
no database manager that i know of automatically
packs the database after every record deletion.
it would be too costly.
that is one of the reasons that most of us do not
store blobs in databases, but store them
externally.
> I have two tables containing a BLOB cloumn as;
>
> -- supposed
Pae,
Tuesday, November 26, 2002, 6:52:20 PM, you wrote:
PC> I have two tables containing a BLOB cloumn as;
PC> -- supposed to be able to handle up to about 16MB
PC> CRETAE TABLE gallery1 (
PC> idINTEGER,
PC> titleVARCHAR(255),
PC> mediumimageMEDIUMBLOB
PC> );
PC> -- suppo
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" doe
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,
I have two tables containing a BLOB cloumn as;
-- supposed to be able to handle up to about 16MB
CRETAE TABLE gallery1 (
idINTEGER,
titleVARCHAR(255),
mediumimageMEDIUMBLOB
);
-- supposed to be able to handle up to about 4GB
CRETAE TABLE gallery2 (
idINTEGER,
t
