maria-discuss team mailing list archive
Mailing list archive
Re: How does InnoDB delete rows?
Hartmut Holzgraefe <hartmut@xxxxxxxxxxx>
Thu, 13 Sep 2018 10:48:37 +0200
Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.9.1
On 31.07.2018 20:01, Alexandre hadjinlian guerra wrote:
> So, the "better performing and storage wise procedure" is to delete all
> the rows in a given page. This will mark the page as free.
but that only moves the question up by one level: now the full page
will be marked as free, and be ready to be reused, but it will not
be returned to the file system either.
Hartmut Holzgraefe - Principal Support Engineer (EMEA)
MariaDB Corporation - http://www.mariadb.com/