Joinutility seperatorLogin utility separator Infobright.com

Navigation

 ·   Wiki Home
 ·   Wiki Help
 ·   Categories
 ·   Title List
 ·   Uncategorized Pages
 ·   Random Page
 ·   File Upload
 ·   Uploaded Files
 ·   Recent Changes
 ·   RSS
 ·   Atom
 ·   What Links Here

Active Members:

Search:

 

Create or Find Page:

 

View Install Guide Part 3

9. Change default memory configuration by editing the file brighthouse.ini within the data directory. The following table lists the parameters and some recommended values based on the amount of system memory (values are expressed in megabytes).

System Server Main Server Compressed Loader Main
Memory Heap Size Heap Size Heap Size
32 GB 24000 4000 800
16 GB 10000 1000 800
8 GB 4000 500 800
Default 4000 500 800
.

Note: The default values are set in the brighthouse.ini file, and if these values or that file are deleted, they will be reset to the application minimum allowed values of 600, 250, and 320 for ServerMainHeapSize, ServerCompressedHeapSize, and LoaderMainHeapSize respectively and performance may be impacted.

The 32-bit install is also set to the minimum allowed values of 600, 250, and 320 for ServerMainHeapSize, ServerCompressedHeapSize, and LoaderMainHeapSize respectively.

10. Change user to mysql in order to run the mysql client and server

11. To start the Infobright server, run:

cd /usr/local/mysql
bin/mysqld_safe --defaults-file=/etc/my.cnf &

To connect to the Infobright server, run:

/usr/local/mysql/bin/mysql --defaults-file=/etc/my.cnf -uroot

To stop the Infobright server, run:

/usr/local/mysql/bin/mysqladmin --defaults-file=/etc/my.cnf -uroot shutdown

Creating the Database from an Existing Schema