optimize table xxxxx will "clean" the "deleted records"
2013/10/9 Steve Afrin <[email protected]> > 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? > > Thanks, > Steve > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > > -- Roberto Spadim SPAEmpresarial
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
