Tune mysql embedded foglight database? Mysql performance affects UI (4352000)

Would like tuning parameters for mysql embedded foglight database to increase overall performance? 

Edit the MySQL config file:

WINDOWS: %FGL_HOME%\mysql\my.ini file
UNIX: $ FGL_HOME/mysql/data/my.cnf

----------------------
innodb_buffer_pool_size=
----------------------
Increase it to 1024M or more (up to 80 percent of the free memory). The default is 512MB

NOTE: The embedded MySQL  repository  is a 32bit database.  The maximum innodb_buffer_pool_size value is 2048M for Windows 32bit MySQL databases.  The maximum innodb_buffer_pool_size value is 4096M  for Linux/Unix MySQL 32 bit databases V5.1 or above.

The larger you set this value, the less disk I/O is needed to access data in tables. On a dedicated database server, you may set this to up to 80% of the machine physical memory size. 

• The address space must be contiguous, which can be an issue on Windows systems with DLLs that load at specific addresses.
• Competition for physical memory might cause paging in the operating system.

---------------------
innodb_log_group_home_dir =
---------------------
If log file resides at the same disk as databases , it is recommended to move it to a different disk. Create the new directory structure for the log files manually.     This parameter may not be created in the my.ini/my.cnf file by default.   Example syntax to create:

Windows:

innodb_log_group_home_dir=C:/InnoDB

Unix:

innodb_log_group_home_dir=/mysqlloggroup/InnoDB




Log file size is also important :
-----------------------
innodb_log_file_size=
-----------------------
log files size recommended size is about 25%-100% of buffer_pool_size to avoid unneeded buffer pool flush activity on log file overwrite. However, note that a larger logfile size will increase the time needed for the recovery process.


A FMS restart is required for new settings to take effect.