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

From: Date: Sun, 23 Nov 2003 04:56:38 +0000
Subject: Why MySql doesn't free space when erasing BLOB fields?
Groups: php.general 
Request: Send a blank email to php-general+get-170705@lists.php.net to get a copy of this message
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 (#170705) next »