RE: [PHP] Why MySql doesn't free space when erasing BLOB fields?
| From: | Nigel Jones | Date: | Sun, 23 Nov 2003 05:04:08 +0000 |
| Subject: | RE: [PHP] Why MySql doesn't free space when erasing BLOB fields? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-170707@lists.php.net to get a copy of this message | ||
ummm Flush maybe
_________________
Nigel Jones
njonez@ihug.co.nz
>> -----Original Message-----
>> From: M [mailto:meu@meucat.com]
>> Sent: Sunday, November 23, 2003 5:57 PM
>> To: php-general@lists.php.net
>> Subject: [PHP] Why MySql doesn't free space when erasing BLOB fields?
>>
>>
>> Hello, sorry this mysql question here, but I cant't answer this one.
>>
>> I have database with BLOB fields to hold pictures (60-90 kb each).
>> Actually I am erasing these BLOB fields (move '' into and update rcord)
>> to free some space from my DB, but space is not released by mysql. I
>> verified BLOB fields really were erased.
>>
>> How can I tell mysql recover these space?
>>
>> Thanks
>>
>> Miguel
>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>