Why MySql doesn't free space when erasing BLOB fields?
This is a discussion on Why MySql doesn't free space when erasing BLOB fields? within the PHP General forums, part of the PHP Programming Forums category; Hello, sorry this mysql question here, but I cant't answer this one. I have database with BLOB fields to ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
11-23-2003
|
|||
|
|||
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 
|
|
11-23-2003
|
|||
|
|||
|
Re: [PHP] Why MySql doesn't free space when erasing BLOB fields?
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 >
|
Linear Mode
