MySQL used to be packaged with ElectricCommander 4.1.x and earlier. Although MySQL is no longer directly packaged with the ElectricFlow installer, it is still one of the Supported Databases as listed in the Installation Guide
Here are some recommended settings for for MySQL usage with ElectricCommander 5.x and ElectricFlow 6.x and higher. Please choose to MySQL v.5.5 or higher.
Navigate to the MySQL configuration file:
- In Linux (/etc/mysql/my.cnf)
- In Windows (C:\ProgramData\MySQL\MySQL Server x.x)
Under section [mysqld] please set the following parameters.
The values for size are minimum recommendations and you may need to increase these values depending on usage. Please take the advice of a Database Administrator or Oracle support before adjusting these values.
# for utf-8
init_connect='SET NAMES utf8'
# Storage engine by default is MyISAM which does not work well for commander
# Increase innodb_lock_wait_timeout to 300 seconds (NMB-13898)if you see a lot of
#org.hibernate.exception.LockTimeoutException in the commander logs as
#default 50 sec is too low.
port = 3306
#If using Mysql 5.7 table_cache should be renamed to table_open_cache
#The innodb_additional_mem_pool_size is removed in Mysql 5.7.4
# On 64-bit MySQL, you can now bump innodb_buffer_pool_size to over 1500 MB if you #have enough memory available.
#For large commander property operations to work
#Commander needs atleast 200 connections.