MySQL Forums
Forum List  »  InnoDB

Informations and tune for Purge system!
Posted by: Christian Marinelli
Date: May 16, 2024 07:45AM

Hi all,
i have some questions about MySQL purge system.
I read from the official documentation the purge system is automatically scheduled so i don't need to enable it in some way, but i didn't understand very weel how often it run; if i'm not wrong, i read it runs every 128 DELETE queryes and i can change this value with the innodb_purge_rseg_truncate_frequency parameter (for example if i want it runs more frequently).
Can you confirm me if i understood correcly the documentation?
Unfortunalty i worked for a long time with PostgreSQL and here there is the VACUUM process, i have a few experience with MySQL, i am learning day by day.
Thanks a lot in advance
Christian

Options: ReplyQuote


Subject
Views
Written By
Posted
Informations and tune for Purge system!
210
May 16, 2024 07:45AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.