### SYN-3 mysql config, optimized for zarafa.
# (C)2014 DatuX

# The following options will be passed to all MySQL clients
[client]
port		= 3306
socket		= /var/run/mysql/mysql.sock

[mysqld]
port		= 3306
socket		= /var/run/mysql/mysql.sock
key_buffer = 64M
#table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
thread_stack = 256k
skip-networking

#dont let mysql decide memory usage (it will be way too much)
performance_schema = 0

#dont write buffer at each commit
#http://dev.mysql.com/doc/refman/5.6/en/optimizing-innodb-transaction-management.html
innodb_flush_log_at_trx_commit = 0

#can safely turn this off because we dont use replication
#http://dev.mysql.com/doc/refman/5.6/en/optimizing-innodb-transaction-management.html
innodb_support_xa=0

#innodb_lock_wait_timeout = 50
max_connections = 500

# neccesary for upgrades according to http://dev.mysql.com/doc/refman/5.1/en/upgrading.html
innodb_fast_shutdown=0

# default, other settings dont seem to change performance 
#innodb_flush_method=fsync

# this should roughly match the IOPS of the disks. 
# "For systems with individual 5400 RPM or 7200 RPM drives, you might lower the value to the former default of 100."
innodb_io_capacity=100

# "You might increase this value for a MySQL server with heavy insert, update, and delete activity"
innodb_change_buffer_max_size=50

# "If a write-intensive workload saturates your I/O capacity, decrease the value, especially if you have a large buffer pool."
innodb_lru_scan_depth=512

# "A typical setting for a problematic workload might be 1 million, assuming that transactions are small, only 100 bytes in size, and it is permissible to have 100MB of unpurged InnoDB table rows."
innodb_max_purge_lag=1000000

### SYN-3 zarafa settings for about 1000 users:
# (based on http://doc.zarafa.com/7.1/Administrator_Manual/en-US/html-single/#_PerformanceTuning )

#"about 50% of RAM size"
#configured automaticly by run-script:
innodb_buffer_pool_size = 200000K
#innodb_buffer_pool_instances = 32

#"32Mb should be enough"
query_cache_type=1
query_cache_size=32M

#"25% of the innodb_buffer_pool_size"
#http://dev.mysql.com/doc/refman/5.6/en/optimizing-innodb-logging.html says: "even as big as the bufferpool."
innodb_log_file_size = 1G

#"32Mb"
innodb_log_buffer_size = 32M

#we dont want one huge ibdata-file:
innodb_file_per_table=1

#at least 16M
max_allowed_packet = 512M



[mysqldump]
quick
max_allowed_packet = 512M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout