search

wso2 / analytics-apim

Analytics for APIM
Apache License 2.0
55 stars 126 forks source link

Purge alert summary tables #1006

Open fazlan-nazeem opened 4 years ago

fazlan-nazeem commented 4 years ago

Description:

Currently, we are storing alert messages in the DB in several tables according to the alert type. We have not enabled purging for any of these tables by default. Therefore it can only grow. These alerts are then fetched and shown in the alert dashboard in the admin portal.

I suggest we should purge these data which are older than a specific number of months(maybe 6). It is rarely an admin would need to view an alert generated more than 6 months ago. We could gain an improvement in DB write performance by this if these tables have grown enormously in customer environments as well as save disk space

fazlan-nazeem commented 4 years ago

There seems to be a limitation in siddhi, in purging non-aggregate tables. Hence reducing priority.