Re: Why MySql doesn't free space when erasing BLOB fields?

From: Date: Sun, 23 Nov 2003 09:50:13 +0000
Subject: Re: Why MySql doesn't free space when erasing BLOB fields?
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-170713@lists.php.net to get a copy of this message
OPTIMIZE TABLE tbl_name M wrote:
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


« previous php.general (#170713) next »