EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB326072: New environment variable FILE_CACHE_SIZE_THRESHOLD in MicroStrategy Secure Enterprise running on Linux operating systems


Community Admin

• Strategy


New environment variable FILE_CACHE_SIZE_THRESHOLD in MicroStrategy Secure Enterprise 10.x/11.x running on Linux operating systems.

Overview:
In Strategy Secure Enterprise 10.x/11.x running on Linux, a new environment variable has been introduced:
 


FILE_CACHE_SIZE_THRESHOLD

 
This environment variable is designed to help with excessive Page Cache usage especially during publication of large cubes.
 
The Page Cache itself is designed to help increase access speeds for non-volatile storage. Essentially, when first reading or writing data to the hard drive, it will also store the data into unused areas of memory which then serves as the cache. If the data needs to be accessed again, it can refer to the Page Cache instead of the underlying storage device. Additional information about this can be found here. 
 
This can cause problems when publishing large Intelligent Cube files, which can require large amounts of memory. This new environment variable, FILE_CACHE_SIZE_THRESHOLD can be used to specify the maximum size of an Intelligent Cube (in Megabytes) that should be allowed to stay in the Page Cache. For example, if the variable is set in <MSTR_HOME>/env/Tunable.sh such as below, any Intelligent Cube or cache published which takes over 20GB will be cleared from page cache immediately. Any Intelligent Cube or cache that takes less than 20GB will be not be cleared thus continuing to take advantage of Page Cache for smaller files.
 

export FILE_CACHE_SIZE_THRESHOLD=20480

 
Note: Any change to this environment variable only takes effect after an Intelligence Server restart.

KB326072


Comment

0 comments

Details

Knowledge Article

Published:

July 24, 2017

Last Updated:

July 15, 2020