View Install Guide Part 2
7. Change default memory configuration by editing the file brighthouse.ini within the data directory.
Important: It is critical that you increase the memory settings for systems running more than 2GB of physical memory or performance will be severely impacted.
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 |
| —————- | ———————- | ——————————— | ——————— |
| 64 GB | 48000 | 4000 | 800 |
| 48 GB | 32000 | 4000 | 800 |
| 32 GB | 24000 | 4000 | 800 |
| 16 GB | 10000 | 1000 | 800 |
| 8 GB | 4000 | 500 | 800 |
| 4 GB | 1300 | 400 | 400 |
| 2 GB | 600 | 250 | 320 |
| Default | 600 | 250 | 320 |
| . |
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, 256, and 320 respectively.
8. To start or stop the Infobright server, run:
/etc/init.d/mysqld-ib start
/etc/init.d/mysqld-ib stop
For details, run
bin/mysqld_safe --help
9. To start/stop the Infobright server during system boot/shutdown use the mysqld-ib script in /etc/init.d/ for start and stop services. Use run level 2 3 4 5 to start the service, and run level 0 1 6 to stop.
The following are sample commands to create services:
(Ubuntu) update-rc.d mysql-ib.server start 99 2 3 4 5 . stop 01 0 1 6 .
(CentOS) chkconfig --add mysqld-ib
chkconfig --level 2345 mysqld-ib on
chkconfig --level 016 mysqld-ib off
10. To connect to Infobright server, use the script mysql-ib located in /usr/bin
