Introduction

This article is about how to cleanse the data in the process collector table. To maintain optimal performance and storage efficiency, it may be necessary to cleanse or archive old records from the table periodically. This guide outlines the steps, considerations, and example SQL queries to safely remove outdated entries from the Process Data Collector table in a Joget environment.

Important Notes before cleansing the table:

  1. Always perform comprehensive backups of your Joget database before any database activity, and test the backups accordingly.
  2. Run the database activities only after office hours.
  3. Run the database activities after stopping the Joget Apache Tomcat.
    1.  Stop all background processes.
    2. Prevent users from logging into Joget.
  4. Please test all your queries on a test database before implementing them on the actual database.

Getting Started

The Process Data Collector information is stored in the app_report_* tables. Truncating these tables is sufficient to clean up the data associated with this plugin. To delete the Process Data Collector database tables in MySQL, use the following SQL script:

set foreign_key_checks=0;
truncate app_report_activity_instance;
truncate app_report_package;
truncate app_report_app;
truncate app_report_process_instance;
truncate app_report_activity;
truncate app_report_process;
set foreign_key_checks=1;


Related Links