KB Article #70059
Database: What does the STATENTRIES table do and why would it grow to a very large size.
STATENTRIES table grows to a very large size.
Explanation: The STATENTRIES table contains entries that are used by the 'Statistics Monitor' feature in the UI. If this feature is not used by the customer, they can stop adding rows to this table using this procedure.
Resolution
1) Make a backup copy of <build>/conf/monitoringconfig.xml
2) Open <build>/conf/monitoringconfig.xml in a text editor
3) Replace all occurrences of persistToDb="true" with persistToDb="false"
4) Save the file
5) Restart Interchange
This will cause Interchange to no longer write entries to the STATENTRIES table. And, eventually, because of the Stats purging routine, this table will shrink. Additionally, it would probably be okay to 'truncate' the STATENTRIES table. However, that should be done while Interchange is *not* running.