What is Clean base rotation mean?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-10-2025 02:36 AM
as the title, what is clean base rotation defined and mean?
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-10-2025 03:45 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-10-2025 03:59 AM
@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?