Chat now with support
Chat with Support

Foglight 6.1.0 - Installing Foglight on Windows with an External MySQL Database

Before Installing Foglight Installing Foglight
Preparing to install Installing a new version of the Management Server Installed directories Foglight settings HP patch checking tool Uninstalling Foglight Upgrading the Management Server Installing Foglight FAQ
Running the Management Server Installing and Upgrading Cartridges Installing Agents

Initializing and tuning the database

Initializing and tuning the database

The following sections describe how to initialize and tune your database:

•
Initializing the database
•
Tuning an external MySQL database for Foglight

Initializing the database

For external databases, once the database has been successfully initialized, you can run Foglight.

Tuning an external MySQL database for Foglight

If you are running the Management Server with an external MySQL® database in a production environment, you may want to tune your database to ensure that it is not under-resourced. The table below lists the tunable settings in the <mysql_install_path>\my.ini file.

 
* 
NOTE: Database tuning is an advanced-user activity. Changing settings for your MySQL database incorrectly can result in problems with your Foglight installation, such as serious performance problems with the Management Server.

 

Table 1. Tuning an external database - tunable settings
my.ini setting
Recommended Value
Comments

innodb_additional_mem_pool_size

20M

Additional memory pool used by InnoDB to store metadata information.

innodb_buffer_pool_size

512M

InnoDB uses a buffer pool to cache both indexes and row data. The larger you set this the less disk I/O is needed to access data in tables. Note that on 32-bit systems you might be limited to 2 to 3.5G of user level memory per process, so do not set it too high. Also, ensure that the host has enough real memory free for specified buffer pool size. Performance will degrade substantially if the buffer pool uses virtual memory.

innodb_flush_log_at_trx_commit

2

Value 2 means that the transaction log is only flushed to the OS cache rather than to disk at each commit. The log file is still flushed to disk approximately once per second.

innodb_log_buffer_size

8M

The size of the buffer InnoDB uses for buffering log data.

innodb_log_file_size

128M

Size of each log file in a log group. You should set the combined size of log files to about 25 to 100% of your buffer pool size to avoid unneeded buffer pool flush activity on log file overwrite. Note that a larger log file size will increase the time needed for the recovery process.

max_connections

50 or more

The maximum amount of concurrent sessions the MySQL® server will allow.

tmp_table_size

32M

Maximum size for internal (in-memory) temporary tables.

Starting and stopping the Management Server

The following sections describe how to start and stop the Management Server:

•
Starting the Management Server
•
Running the Management Server as a Windows service
•
Stopping the Management Server
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating