Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

WSO2 DAS stores data in the Data Access Layer (DAL) and performs various analysis operations on them according to defined analytic queries. Thereby, as the volume of the data stored grows over time, the analysis and summarization jobs will also eventually consume more time. Then you can apply data purging to reduce the time taken to execute the analytics scripts, as well as the disk usage, since usually it is not necessary to analyze all data to produce the final result. 

...

  1. Log in to the management console as an admin user using the following URL: https://<DAS_HOST>:<DAS_PORT>/carbon/ 
  2. Click Main, and then click Data Explorer.
  3. Select he the required event table for the Table Name parameter, and click Schedule Data Purging as shown below.

    Note

    The Schedule Data Purging option is displayed only for users of whom the assigned role has the Delete permission under Record enabled. For instructions on setting this permission to users, see WSO2 DAS-Specific User Permissions.

    purging data per table

  4. Enter information as follows in the Schedule Data Purging dialog box to schedule the data purging task.
    scheduling the data purging task
    The fields of the above screen are described below.

    FieldDescription
    Enable Data PurgingWhether you want to enable data purging or not.
    Schedule Time (Either cron string or HH:MM)Enter the time on which you want to purge data via cron expression or by defining the time in the following format: HH:MM. For example, the following cron expression will configure the data purging job to run at  12:00 PM (noon) every day 0 0 12 * * ?  For more information on cron expressions, go to Oracle Documentation.
    Purge Record Older Than (Days)Define the value as to keep data of only the last 'n' no of days back in the selected table. For example, if you give 1 as the value, the system will purge all data stored before yesterday.
  5. Click Save, and close the dialog box. 

...

  1. Log in to the Management Console as an admin user, if you are not already logged in.
  2. Click Main, and then click Data Explorer.
  3. Select the required table in the Table Name field, and then click Schedule Data Purging to open the Schedule Data Purging dialog box.
  4. Clear the Enable Data Purging check box as shown below.
    disable data purging
  5. Click Save, and close the dialog box.

  

Global data purging

You can perform data purging as a global operation which will affect all tenants. Follow the steps below to perform global data purging.

...