root@def-db06:~# cat /etc/mysql/my.cnf
[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqldump]
quick
quote-names
#max allowed packet     1,048,576 (5.5.9 original)
max_allowed_packet      = 16M

[mysql]

[isamchk]
#key buffer size        8,388,608 (5.5.9 original)
key_buffer              = 16M

[mysqld]

port                            = 3306
socket                          = /var/run/mysqld/mysqld.sock
character-set-server            = utf8
user                            = mysql
socket                          = /var/run/mysqld/mysqld.sock
pid-file                        = /var/run/mysqld/mysqld.pid
log-error                       = /var/log/mysql/mysqld.err
basedir                         = /usr/local/mysql
datadir                         = /SSD/mysql
skip-name-resolve

interactive_timeout 		= 30
wait_timeout 			= 30
lock_wait_timeout 		= 600

back_log                        = 50
max_connections                 = 800
max_connect_errors              = 9999999
table_cache                     = 15000
max_allowed_packet              = 16M
binlog_cache_size               = 1M
max_heap_table_size             = 1548M
sort_buffer_size                = 2M
join_buffer_size                = 2M
thread_cache_size               = 100
thread_concurrency              = 16
#query_cache_size                = 6144M
query_cache_size                = 3072M
query_cache_limit               = 256M
query_cache_min_res_unit        = 2K
thread_stack                    = 384K
tmp_table_size                  = 1548M
slow_query_log					= 1
slow_query_log_file				= /var/log/mysql/mysql-slow.log
long_query_time                 = 2
tmpdir                          = /tmp
memlock
federated

binlog_format = MIXED
log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 7
binlog_do_db = defshop-prod
binlog_do_db = defshop-backend
binlog_ignore_db = mysql
binlog_ignore_db = information_schema
binlog_ignore_db = Lager
binlog_ignore_db = backoffice
binlog_ignore_db = defshop_filter
binlog_ignore_db = jahresabschluss2009
binlog_ignore_db = performance_schema
binlog_ignore_db = products-trash
binlog_ignore_db = statistics
binlog_ignore_db = defshop-counts
replicate_wild_ignore_table=defshop_filter.%
replicate_wild_ignore_table=mysql.%
replicate_wild_ignore_table=information_schema.%
replicate_wild_ignore_table=performance_schema.%
replicate_wild_ignore_table=statistics.%
replicate_wild_ignore_table=defshop-counts.%


# *** INNODB Specific options ***

innodb_additional_mem_pool_size = 160M
innodb_buffer_pool_size         = 6G
innodb_data_file_path           = ibdata1:10G:autoextend
innodb_flush_method             = O_DIRECT
innodb_read_io_threads          = 6
innodb_write_io_threads          = 6
innodb_thread_concurrency       = 48
innodb_flush_log_at_trx_commit  = 0
innodb_log_buffer_size          = 80M
innodb_log_file_size            = 800M
innodb_log_files_in_group       = 3
innodb_max_dirty_pages_pct      = 90
innodb_lock_wait_timeout        = 120
#innodb_file_per_table           = 1

sync_binlog = 1

server-id = 59