maria-discuss team mailing list archive
Mailing list archive
Re: DELETE Operations in MariaDB 5.5.30 do not reduce size of table files
optimize table xxxxx
will "clean" the "deleted records"
2013/10/9 Steve Afrin <safrin@xxxxxxxxx>
> To anyone who knows how the MyISAM engine works (or maybe this is
> independent of the DB engine), here’s my scenario:
> - I have a table with 180,000 rows
> - I delete 170,000 rows with a DELETE and subsequent COMMIT statement
> - The MYI table file is still the same size it was before the 170k
> rows were deleted
> I saw there’s an administrative PURGE command, but it looks like that is
> just for purging data from binary logs, if you’ve even turned on the option
> for keeping binary logs.
> In MariaDB 5.5.30 or later, how do I run a purge operation to compress the
> deleted rows of data out of my physical table files and cause the
> reindexing to happen for the data that is still in my tables?
> Mailing list: https://launchpad.net/~maria-discuss
> Post to : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help : https://help.launchpad.net/ListHelp