maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

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?
>
> Thanks,
> Steve
>
> _______________________________________________
> 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
>
>


-- 
Roberto Spadim
SPAEmpresarial