maria-discuss team mailing list archive

Thread
Date

Re: How does InnoDB delete rows?

To: maria-discuss@xxxxxxxxxxxxxxxxxxx
From: Hartmut Holzgraefe <hartmut@xxxxxxxxxxx>
Date: Thu, 13 Sep 2018 10:48:37 +0200
In-reply-to: <CAOEJH=CirhoOHPwCyhYJioaruBj1afTG6Tkn4hanCMh1TuOTaw@mail.gmail.com>
User-agent: 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/

References

How does InnoDB delete rows?
From: Arlindo Neto, 2018-07-27
Re: How does InnoDB delete rows?
From: Alexandre hadjinlian guerra, 2018-07-31