Subversion Repositories configs

Rev

Rev 60 | Rev 158 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed

[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