Setting Up MySQL Configuration Parameters

 

Quick Start Recommended Best Practice

 

1.  When you install MySQL, you must decide what port number the database will use for communications.  The default port is 3306.  If you decide to have MySQL communicate on a port other than the default, please refer to the MySQL documentation to determine how to change the port.  These instructions assume for Quick Start Recommended Best Practice sections that the MySQL communications port remains at the default value of 3306.

2.  Please ensure your MySQL server has the following settings at a minimum.  If not, set them and then restart your MySQL daemon after modifying the configuration file, my.cnf.  

MySQL Configuration Parameters

https://test.kuali.org/confluence/images/icons/emoticons/information.gif

Note:

These settings reflect a CentOS 5.3 distribution using the distribution-installed MySQL packages.  They are stored in /etc/my.cnf.

Only the root user can change these settings, and they should only be changed when the database server is not running.

 

 

[mysqld]

max_allowed_packet=20M

transaction-isolation=READ-COMMITTED

lower_case_table_names=1

max_connections=1000

innodb_locks_unsafe_for_binlog=1

 

 

Transaction Isolation

 

Warning:

It is very important to verify that the default transaction isolation is set to READ-COMMITTED.  KEW uses some ‘SELECT ... FOR UPDATE’ statements that do NOT function properly with the default MySQL isolation of REPEATABLE-READ.

 

Index Gaps Lock

 

innodb_locks_unsafe_for_binlog=1 is only necessary if you are running MySQL 5.0.x.  This behavior has been changed in MySQL 5.1+ so that, in 5.1+, this command is NOT necessary as long as you specify READ-COMMITTED transaction isolation.

3.  If you make the changes to your MySQL configuration specified above, you will have to restart your MySQL server for these changes to take effect.  You can restart your MySQL daemon by executing this command:

 

/etc/init.d/mysqld restart

 

 

END - Quick Start Recommended Best Practice