Recommendations for topic and table of content cache settings
A few rules of thumb insure an optimal performance through appropriate caching.
The adaptation of caching parameters to data size is made through the use of disk space to supply memory for big loads. When the database is bigger than 60 Gb, it is best resorting to disk space with the maxBytesLocalDisk parameter. When you use maxBytesLocalDisk, you need to remove the competing maxEntriesLocalDisk.
The parameters are set in the configuration file \WEB-INF\classes\ehcache.xml.
-
Table of Content cache (for
TOC_UUID) -
Database smaller than 60 Gb:
maxBytesLocalHeapset between 1 and 3% of the memory allocated to Tomcat.
Database bigger than 60 Gb:maxBytesLocalHeapset to 600 Mb if the memory allocated to Tomcat is bigger than 10 Gb. Between 1 and 3% of the memory allocated to Tomcat if it is smaller than 10 Gb.maxBytesLocalDiskset between 5 and 10% of the database size (andmaxEntriesLocalDiskremoved).
- Topics cache
-
maxBytesLocalHeapset between 1 and 3% of the memory allocated to Tomcat.maxBytesLocalDiskset to as high as you can (andmaxEntriesLocalDiskremoved).