Chat now with support
Chat with Support

Foglight 5.9.3 - Installing Foglight on a UNIX System 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

Option 2 - Run SQL scripts to configure the database

If you clicked Create during the database installation step, the SQL scripts in the<foglight_home>/scripts/sql directory are prepared with the provided configuration options. There are four SQL files for each database type ([dbtype]):

You can review these scripts before running them.

You must run the configured scripts against the database using a third-party tool.

Run the .sql scripts by issuing the following commands in the order shown:

Example (for Foglight only):

After you have run all four scripts, you can start the Management Server. Proceed to Starting and stopping the Management Server.

Initializing and tuning the database

Initializing and tuning the database

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

Initializing the database

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

IMPORTANT: Do not make the MySQL® database file my.cnf world-writable, for example by issuing the command chmod a+w <path_to_file>/my.cnf. Foglight and the database cannot start if there is world access to the configuration file my.cnf.

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.

 

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.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating