Subversion Repositories configs

[mysqld]

innodb_file_per_table

datadir=/db/mysql

socket=/var/lib/mysql/mysql.sock

# Settings user and group are ignored when systemd is used (fedora >= 15).

# If you need to run mysqld under different user or group,

# customize your systemd unit file for mysqld according to the

# instructions in http://fedoraproject.org/wiki/Systemd

user=mysql

symbolic-links=0

key_buffer = 640M

table_cache = 1280

sort_buffer_size = 2M

myisam_sort_buffer_size = 8M

query_cache_size = 128M

thread_cache_size = 12

innodb_buffer_pool_size = 4G

join_buffer_size = 32k

# Semisynchronous Replication

# http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html

# uncomment next line on MASTER

;plugin-load=rpl_semi_sync_master=semisync_master.so

# uncomment next line on SLAVE

;plugin-load=rpl_semi_sync_slave=semisync_slave.so

# Others options for Semisynchronous Replication

;rpl_semi_sync_master_enabled=1

;rpl_semi_sync_master_timeout=10

;rpl_semi_sync_slave_enabled=1

# http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html

;performance_schema

#zarafa

max_allowed_packet=16M

init_connect='SET collation_connection = utf8_unicode_ci'

init_connect='SET NAMES utf8'

character-set-server=utf8

collation-server=utf8_unicode_ci

skip-character-set-client-handshake

# mysqldump restore

;SET autocommit = 0;

;SET unique_checks=0;

;SET foreign_key_checks=0;

;START TRANSACTION;

#innodb_flush_log_at_trx_commit = 2

#innodb_log_file_size = 256M

#innodb_flush_method = O_DIRECT

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

socket=/var/lib/mysql/mysql.sock