Knowledgebase
How to prevent the built-in H2 database from growing excessively large
Posted by John Villanueva on 24 May 2018 06:40 PM

As pointed out in the article "Slow startup and other performance issues due to large database", if the built-in H2 database used by MFT Server to store server configuration data grows excessively large, it can cause performance issues and can even prevent MFT Server from starting. While that same article outlines the steps to compact an overgrown database, it would help to know how to prevent the database from growing too large in the first place. This article addresses that. 

First of all, you need to be aware of the items that enable the database to grow. Here are some of them:

  • trigger execution history (Triggers > Recent)
  • administrative events log
  • AS2 messages

Now, here are the things you can do prevent these items from flooding the database:

For the Trigger execution history


Open each domain and go to "Triggers > Settings" then enable "Clear recent triggers older than __ days" and set it to say 1

 

 

For the administrative events log

Go to "Settings > Manager Service > Logs" and enable "Clear records older than" option and set it to 1 day.

 

For the AS2 messages

AS2 messages can be purged using the js-as2purge command line utility.

Other things you can do

Check if you have set any domain logging to database (Logging > Service). You can use Log to File instead (see http://files.jscape.com/secureftpserver/docs/index.html?settingloggingpreferences.htm)

Check if you have enabled verbose logging as well (Logging > Settings). Disable this if so.


Lastly, there is an option to migrate from the embedded H2 database into an external database such as MySQL, Oracle, MSSQLServer and PostgreSQL (latest version of JSCAPE MFT Server only).

Refer to this for details:

http://files.jscape.com/secureftpserver/docs/migrating_to_centralized_global_datastore.htm

Using an external database solves performance issues that would occur when the database grows large.

(0 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Software by Kayako fusion