What is Clean base rotation mean?

GaominZ
Tera Contributor

as the title, what is clean base rotation defined and mean?

GaominZ_0-1741599180679.png

 

for example, it says 2025/05/06 18:32:06 

which tables' data will be cleaned up at the time? " Log Entry[syslog]"??
Or the one oldest so far, which is "Log Entry [syslog0007]??

I have already read the document and still have the question. please kindly explain to me. 
Apply table rotation

2 REPLIES 2

Rohit  Singh
Mega Sage

Hi @GaominZ 

 

"clean base table rotation" refers to the process of automatically managing the size of a database table by periodically creating new, empty "rotation" tables, transferring data from the old table to the new one, and then deleting the old table once the data is migrated, effectively keeping only a certain amount of recent data within the table rotation cycle; this helps maintain performance and prevent the database from becoming too large by automatically removing older data.

 

Please also refer this: Table Rotation 

 

If my response helped, please mark it helpful and accept the solution so that it benefits future readers.

 

Regards,
Rohit

@Rohit Singh 

thank you for the explanation.
may I ask what is the rule used to decide which table to clean up? are the rotation tables being cleaned up in the order of time?
which table do "clean base rotation" refer to?