Purpose

New table entries are constantly being added to the Appian engines as various functions are executed throughout the system. Although the data may clear from these table entries when specific actions occur, like deletions and removals, there is still underlying metadata that remains which doesn’t allow the table entry to fully clear from the engine.

In certain circumstances, it may be beneficial for the system to clear, or “trim”, these excess table entries from the engine in order to reduce memory usage and reclaim some performance, provided that the rows exist at the end of the table. This script is a utility that allows the administrator to view and identify potential tables which can be trimmed, view basic statistics for these specified tables, and ultimately request the engines to trim off excess rows of the specified tables. These functions can all be performed without having to restart the system.

When to Use

It is best practice to consult and work with the Appian Support team before executing this script in order to determine what kind of performance, if any, may be reclaimed. There are a few common scenarios where running this script can be effective:

• If you've recently run the Sizing Script and the "Pre-Allocated Space Size" column reveals large values
• If you've recently executed a large bulk delete or archival of process data

If any of the above scenarios are true, then run the stats function of this script to determine if any tables may be marked as ready for trimming, indicated by wherever the isTableReadyForTrim column is true. Work with the Appian Support Team to determine if then running the trim function of this script to clear the unused entries of these tables may result in memory savings on the engine.

Additional Notes on Usage

• No Appian components need to be stopped in order to run this script
• Although this script can be run while a site is fully up, it can be resource intensive and should only be run during non-business hours
• Trimmed rows are beneficial in that it allows the system to write new data to them. In order to release the memory, an engine restart would still be required.
• For sites with a High Availability (HA) configuration, this script only needs to be run on the primary engine, but all replicas of that engine would need to be restarted in order to release memory

Location

<APPIAN_HOME>/server/_scripts/tools/trimtables.sh (.bat)

Script Options

Script Usage

1
./trimtables.sh <option> <parameters>

Help

This command returns the help text for the script and usage information for each command.

Usage

1
./trimtables.sh help

Show

This command returns a list of the engines on the system and internal tables that exist on the engines, which are ever eligible to be trimmed.

Parameters and Usage

1
./trimtables.sh show -e <engines>

Examples

1
2
./trimtables.sh show -e all
./trimtables.sh show -e process-analytics process-design process-execution0

Stats

This command returns detailed information for each of the above tables that are eligible to be trimmed.

Parameters and Usage

1
./trimtables.sh stats -e <engines> -t <tables>

Examples

1
2
3
4
./trimtables.sh stats -e all -t all
./trimtables.sh stats -e all -t ilst workq
./trimtables.sh stats -e process-analytics process-design process-execution0 -t all
./trimtables.sh stats -e process-analytics process-design process-execution0 -t ilst

Detailed Table Information

The following table statistics will be returned:

Trim

This command will trim the eligible entries from the specified engines and tables.

Parameters and Usage

1
./trimtables.sh trim -e <engines> -t <tables>

Examples

1
2
3
4
./trimtables.sh trim -e all -t all
./trimtables.sh trim -e all -t ilst workq
./trimtables.sh trim -e process-analytics process-design process-execution0 -t all
./trimtables.sh trim -e process-analytics process-design process-execution0 -t ilst

Status Codes

For each engine and table pair, the following status codes indicating the result of the trim will be displayed after the command execution: