[mysqld]
##
## Load Plugins
## To specify cutom plugin dir use line below.
## plugin_dir=/usr/local/lib/mysql/plugin
##
 
plugin-load=ha_xtradb.so
 
##
## General Optimization
##
 
open-files-limit=1024
local-infile
character-set-server=utf8
connect-timeout=60
key_buffer_size=1M
sort_buffer=256K
max_heap_table_size=1M
 
##
## InnoDB Configuration.
##
 
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
innodb_data_file_path = ibdata1:1024M:autoextend
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_log_files_in_group=2
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_file_per_table
 
##
## Setting Log / Bin expiry and name
##
 
expire_logs_days=5
log-bin=mysqld-bin
log-bin-trust-function-creators=1
datadir=/usr/local/var
relay-log=freebsd-relay-bin
binlog-ignore-db=mysql,test
 
##
## Replication Options
##
 
server-id=0
 
#server-id=2
#replicate-same-server-id=0
#auto-increment-increment=5
#auto-increment-offset=2
#slave-net-timeout=120
 
#master-host=192.168.1.3
#master-user=repl
#master-password=password
#master-connect-retry=60
#replicate-ignore-db=mysql,test