Clever Geek Handbook

WSO2 Analytics database size too large

We are using api manager (2.1.0) and set up analytics.

We ran load testing and event data generated by the analytics in the database traversed 2GB.

Is there a way to control the size of the database. OR Is there any impact if we use h2 database for processed data.

We use oracle DB

thank

+3


source to share


3 answers


Data should be cleaned periodically. You can cleanse data in analytics based on the following methods.

  • Clearing table data
  • Global data cleansing


You can read how to enable data cleansing in here . APIM analytics runs wso2das, so you can do the same configurations as in.

+1


source


As far as I know, this is expected as it will store all events when analytics is enabled. But you can periodically clean the data. Further use of h2 in production is not recommended at all.



0


source


You can always clean up data from the tables below, but you shouldn't clean up compressed data.

ORG_WSO2_APIMGT_STATISTICS_DESTINATION
ORG_WSO2_APIMGT_STATISTICS_FAULT
ORG_WSO2_APIMGT_STATISTICS_REQUEST
ORG_WSO2_APIMGT_STATISTICS_RESPONSE
ORG_WSO2_APIMGT_STATISTICS_WORKFLOW
ORG_WSO2_APIMGT_STATISTICS_THROTTLE
0


source






More articles:


All Articles