This site contains the documentation that is relevant to older WSO2 product versions and offerings.
For the latest WSO2 documentation, visit https://wso2.com/documentation/.

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Data purging is an option to remove historical data in WSO2 API Manager Analytics. This is important because it is not possible to delete tables or table data in WSO2 API Manager Analytics. By purging data, you can achieve high performance in data analysis without removing analyzed summary data. This data is contained in the following tables:

  • <WHAT??>

Make sure you do not purge data in tables other than those mentioned above and the tables related to alerts, because data purging deletes your summarized historical data.

You can purge data either for a specific table or globally. Refer to the following sections for more information on data purging with regard to WSO2 API Manager Analytics.

Purging alert related tables

Data Purging is enabled by default for all the aggregation tables. However, you can purge data in certain alert tables, namely APIMIpAccessSummary and APIMIpAccessAlertCount tables, which have the potential to grow quickly like aggregation tables. Follow the instructions below to purge the data in the latter mentioned alert tables.

  1. Configure WSO2 API Manager (WSO2 API-M) with WSO2 API-M Analytics, and start WSO2 API-M Analytics, WSO2 API Manager, and the WSO2 API-M Analytics Dashboard node in the latter mentioned order.
    For more information, see Configuring APIM Analytics.
  2. Access the Business Rules via the WSO2 API-M Analytics dashboard.
    https://<HOSTNAME>:<DASHBOARD_PORT>/business-rules
    For example: https://localhost:9643/business-rules
  3. Click the edit link that corresponds to the APIM DATA PURGING business rule.
  4. Click Save and Deploy to enable data purging in the APIMIpAccessSummary and APIMIpAccessAlertCount tables.
    When the above business rule is enabled, it will purge data from APIMIpAccessSummary and APIMIpAccessAlertCount tables every time the trigger is triggered. The default time interval for the trigger is 1 year.
    If you need to purge the data immediately and cannot wait for the next trigger, then you need to reduce the default trigger time to a small value such as one minute and change the trigger time after that.
  • No labels