In this section: |
The Hyperstage configuration file is called brighthouse.ini and is located in the ib_data subdirectory within the Hyperstage Data directory installation directory (for example, C:\ibi\HyperstagePG\ib_data). The configuration file is a text file containing the Hyperstage configuration parameters.
Each parameter is shown on a separate line and uses the following form:
ParameterName=ParameterValue If a parameter is not present in the configuration file or if the configuration file does not exist, the default values are used. Blank lines and comments (lines starting with #) are ignored.
Be sure to customize the following parameters to optimize performance. These tuning parameters are case-sensitive and must be typed as shown in the following table.
Parameter Syntax | Value | Description |
|---|---|---|
ServerMainHeapSize=size | Not less than 320 Default: 600 | Size of the main memory heap in the server process, in MB. The larger the heap size, the more effectively the server works. However, the sum of the heap sizes in the server and the loader should not exceed physical memory installed in the machine. Otherwise, performance decreases radically. |
LoaderMainHeapSize=size | Not less than 320 Default: 320 | Size of the memory heap in the loader process, in MB. The sum of the heap sizes in the server and the loader should not exceed physical memory installed in the machine. Otherwise, performance decreases radically. |
CacheFolder=directory | Directory name Default: none | This is a mandatory parameter. Path to the directory where temporary files will be created and stored. This is set as one of the installation script parameters. |
Note: The values are commented out (preceded by #) in the brighthouse.ini file, which causes them to default to the application minimum allowed values of 600 and 320 for ServerMainHeapSize and LoaderMainHeapSize, respectively.
The following table describes additional Hyperstage parameters.
Parameter Syntax | Value | Description |
|---|---|---|
KNFolder=directory | Directory name Default: BH_RSI_Repository | Directory where the Knowledge Grid is stored. If not specified, these files are located in a subdirectory of the data directory. Allow free space of at least 1% of database size (compressed). |
ControlMessages=number | 0, 1, 2, 3, 4, 5 Default: 0 (lowest level of detail) | Set to 2 to turn the control messages on with timestamps. This is usually needed by Hyperstage to support performance investigation. For descriptions of other Control Messages levels, see https://www.infobright.org/index.php//ICE_Wiki/wiki-4/troubleshooting/query-execution-log/. |
Important: You must properly configure your memory settings to ensure optimal performance.
The following table shows sample, recommended memory configurations for different systems.
|
System Memory |
Server Main Heap Size |
Loader Main Heap Size |
|---|---|---|
|
64GB |
48000 |
800 |
|
48GB |
32000 |
800 |
|
32GB |
24000 |
800 |
|
16GB |
10000 |
800 |
|
8GB |
4000 |
800 |
|
4GB |
1300 |
400 |
|
2GB |
600 |
320 |
In most cases, the loader does not benefit from larger memory settings. However, increasing the LoaderMainHeapSize can help when:
or
You can use more memory at import if you are planning to execute several concurrent load tasks to different data tables. However, disk access may become a bottleneck.
ServerMainHeapSize should be as large as possible, but safely smaller than the amount of physical memory on the machine. If performance decreases because of memory swapping by the operating system, try to set lower heap sizes. We also recommend decreasing the heap size if many users are running queries in parallel.
Note:
| WebFOCUS |