# Jane Instanz 1 DB 01
[mysqld]
user=mysql
default_week_format=1
#
#Instanzen Einstellungen
datadir=/opt/jane1/appdb01
socket=/opt/jane1/appdb01/mysql.sock
port=50101
#
#Performance Einstellungen
sort_buffer_size=15G
tmp_table_size=30G
max_heap_table_size=30G
#large_pages=1
binlog_cache_size=1M
max_allowed_packet=8M
table_open_cache=17000
open_files_limit=16000
max_connections=9999

#MyISAM
read_buffer_size=1147479552
key_buffer_size=256M
bulk_insert_buffer_size=500M
myisam_sort_buffer_size=2G
delay_key_write=ALL
#myisam_use_mmap=1


#InnoDB
default-storage-engine=innodb
innodb_status_file=1
innodb_file_per_table
innodb_buffer_pool_size=15G
innodb_additional_mem_pool_size=500M
innodb_log_file_size=256M
innodb_log_buffer_size=8M
innodb_autoextend_increment=50
skip-innodb_doublewrite
innodb_flush_log_at_trx_commit=0
innodb_support_xa=0
sync_binlog=0
#innodb_flush_method=O_DIRECT
transaction-isolation=READ-UNCOMMITTED
innodb_open_files=15000
innodb_thread_concurrency=0




#
#Log Einstellungen
log-slow-queries=/opt/jane1/appdb01/mysqld_slow_queries.log
log-queries-not-using-indexes


[mysqld_safe]
log-error=/opt/jane1/appdb01/mysqld.log
pid-file=/opt/jane1/appdb01/mysqld.pid

[client]
socket=/opt/jane1/appdb01/mysql.sock

[jane]
lockfile=/var/lock/subsys/jane1db01