KB Article #70800

Database table space filling up too fast

Problem

Customer notes that their database is filling up its table space more quickly than their calculations have indicated it should.


Resolution

There are a couple of tables in the Interchange database that can be considered optional. One is the StatEntries table, where the information presented in the STATS logs is stored in the database for use by the 'Statistics Monitor'. If the Statistics Monitor is not used, follow this procedure to stop populating it:



1) Open <build>/conf/monitoringconfig.xml in a text editor (make a backup first)
2) Replace all occurrences of persistToDb="true" with persistToDB="false"
3) Save the file, restart Interchange



The second table is MessageEventSnapshots. This table is not used after version 5.5.1, but customers upgrading from that (or similar) versions may still have this functionality enabled. To stop populating MessageEventSnapshots, follow this procedure:



1) Open <build>/conf/events.xml in a text editor (make a backup first)
2) Look for the section <EventRouter id="Message Events to Database"...
3) If that section is commented out, we're done
4) If the section is not commented out, change active="true" to active="false"
5) Save the file, restart Interchange