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


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.











Transaction Isolation



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