Informations and tune for Purge system!
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
Subject
Views
Written By
Posted
Informations and tune for Purge system!
269
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.