KBEC-00356 - MySQL Configuration Recommendations

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)

Refer to the following link to find the right my.cnf file for your MySQL installation

https://www.electrictoolbox.com/mysql-my-cnf/

Otherwise, run 

"ps -ef | grep -i mysql"  . 

to get an output similar to

$ ps -ef | grep -i mysql
root 3505 1 0 Sep05 ? 00:00:00 sudo /usr/bin/mysqld_safe --user=mysql
root 3506 3505 0 Sep05 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --user=mysql
mysql 3693 3506 0 Sep05 ? 01:16:42 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/ora-db-test2.electric-cloud.com.err --pid-file=/var/lib/mysql/ora-db-test2.electric-cloud.com.pid --socket=/var/lib/mysql/mysql.sock

my.cnf file can be found under the directory labelled "basedir"

Under section [mysqld] please set the following parameters.  The my.cnf file can be found in the directory labelled "basedir".

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.

[mysqld]

# for utf-8
init_connect='SET collation_connection = utf8_unicode_ci, NAMES utf8'

character-set-server=utf8

collation-server=utf8_unicode_ci

skip-character-set-client-handshake

# Storage engine  by default is MyISAM  which does not work well for commander

default_storage_engine=InnoDB

# 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.

innodb_lock_wait_timeout=300

port = 3306

transaction-isolation=REPEATABLE-READ

#If using Mysql 5.7 table_cache should be renamed to table_open_cache

table_cache=1024

query_cache_size=32M

sort_buffer_size=6M

tmp_table_size=64M

max_heap_table_size=32M

read_rnd_buffer_size=256K

#The innodb_additional_mem_pool_size is removed in Mysql 5.7.4

innodb_additional_mem_pool_size=2M

# On 64-bit MySQL, you can now bump innodb_buffer_pool_size to over 1500 MB if you #have enough memory available.

innodb_buffer_pool_size=512M

innodb_file_per_table

connect_timeout=14400

#For large commander property operations to work

max_allowed_packet=1024M

#Commander needs atleast 200 connections.

max_connections=210

Have more questions? Submit a request

Comments

Powered by Zendesk