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,
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,
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
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 -- supposed to
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 to
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
Paul,
It really did the trick. Thanks.
Regards,
Pae
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Pae Choi [EMAIL PROTECTED]; Keith C. Ivey [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, November 26, 2002 10:59 AM
Subject: Re: [MySQL v3.23.53a] BLOB Data and Table