How to limit the size of the Event tables

To keep your Yellowfin configuration database finely tuned there are a few tasks you can do as mentioned in this knowledge base post. One of them is to keep the number of records in the Event and EventArchive tables under control, this is good practice because these tables can get quite big as they record many different types of Yellowfin events.

There are 2 jobs that are important to this upkeep and maintenance of the Event and EventArchive tables, one of them moves records from the Event table to the EventArchive table when they become older than a certain number of days, and the other one deletes records from the EventArchive table when they become older than a certain number of days.

The way to create these 2 jobs and configure the number of days is by running the following 2 queries, keeping in mind that the last value of each INSERT query represents the number of days.

1. Archive tasks from the EVENT table, the job runs every day, searches for events older than xnumber of days ( eg. 30 days).

INSERT INTO Configuration
VALUES (1, ‘SYSTEM’, ‘EVENTMAXDAYS’, 30)

2. Delete records from the EVENTARCHIVE table older than x number of days ( eg. 60 days).

INSERT INTO Configuration
VALUES (1, ‘SYSTEM’, ‘EVENTARCHIVEMAXDAYS’, 60)
Is article helpful?