[mysqld_multi]
 log = /lvdata_inst01/instance_manager/log_mysqld_multi_lim-prd1-vm-04.log
 user = root

 [mysqld1]
 performance_schema
 user = root
 init_connect = 'SET AUTOCOMMIT = 0'
 transaction-isolation = READ-COMMITTED
 port   = 3223
 socket = /lvdata_inst01/database/socket/lim-prd1-vm-04_inst01.sock
 # removed feature in MySQL 5.5 : skip-locking
 net_buffer_length = 1048576
 max_allowed_packet = 1G
 table_open_cache = 1024
 sort_buffer_size = 4M
 read_buffer_size = 4M
 read_rnd_buffer_size=4194304
 myisam_sort_buffer_size=8M
 thread_cache_size=80
 query_cache_size=1G
 tmp_table_size = 160MB
 max_heap_table_size = 160MB
 max_connections = 300
 thread_concurrency=8
 lower_case_table_names=1
 query_cache_type = 1
 query_cache_limit = 1048576
 pid-file = /lvdata_inst01/database/socket/lim-prd1-vm-04_inst01.pid
 server-id=1
 local_infile=0
 query_prealloc_size = 8388608
 query_cache_min_res_unit = 2048
 secure_auth = ON
 key_buffer_size = 2G
 key_cache_block_size = 8192

 general_log = 1
 general_log_file = /lvdata_inst01/database/log/log-lim-prd1-vm-04-inst01

 log-bin = /lvdata_inst01/database/bin/log-bin-lim-prd1-vm-04-inst01
 log-bin-index = /lvdata_inst01/database/bin/log-bin-index-lim-prd1-vm-04-inst01
 binlog-format = ROW
 binlog_cache_size = 16M
 max_binlog_cache_size = 4294967295

 log-error = /lvdata_inst01/database/error/log-error-lim-prd1-vm-04-inst01
 log-queries-not-using-indexes

 slow_query_log = 1
 slow_query_log_file = /lvdata_inst01/database/log/log-slow-queries-lim-prd1-vm-04-inst01

 log-slow-admin-statements

 log_warnings = 2
 long_query_time = 5
 max_binlog_size = 2097152

 datadir=/lvdata_inst01/database/data
 tmpdir=/lvdata_inst01/database/temp

 default-storage-engine = innodb
 innodb_file_format = barracuda
 innodb_file_format_max = barracuda
 innodb_data_home_dir = /lvdata_inst01/database/data
 innodb_file_per_table
 innodb_data_file_path = limprd1vm04_inst01_datafile_01:100M:autoextend
 innodb_autoextend_increment = 100
 innodb_buffer_pool_size=6G
 innodb_log_buffer_size=1G
 innodb_log_file_size=128M
 innodb_log_files_in_group=4
 innodb_log_group_home_dir=/lvdata_inst01/database/ib_logs
 innodb_flush_log_at_trx_commit = 1
 sync_binlog = 1
 innodb_support_xa = 1

 # innodb_lock_wait_timeout modified by HEJ 01/22/2010 previous value 10
 innodb_lock_wait_timeout = 20
 innodb_additional_mem_pool_size=16M
 innodb_open_files = 2048

 # The maximum amount of concurrent sessions the MySQL server will
 # allow. One of these connections will be reserved for a user with
 # SUPER privileges to allow the administrator to login even if the
 # connection limit has been reached.

 max_connections = 300
 optimizer_search_depth = 3

 [mysqld2]
 performance_schema
 user = root
 init_connect = 'SET AUTOCOMMIT = 0'
 transaction-isolation = READ-COMMITTED
 port   = 3322
 socket = /lvdata_inst02/database/socket/lim-prd1-vm-04_inst02.sock
 # removed feature in MySQL 5.5 : skip-locking
 net_buffer_length =1048576
 max_allowed_packet = 1G
 table_open_cache = 1024
 sort_buffer_size = 4M
 read_buffer_size = 4M
 read_rnd_buffer_size=4194304
 myisam_sort_buffer_size=8M
 thread_cache_size=80
 query_cache_size=1G
 tmp_table_size = 128MB
 max_heap_table_size = 128MB
 max_connections = 300
 thread_concurrency=8
 lower_case_table_names=1
 query_cache_type = 1
 query_cache_limit = 1048576
 pid-file = /lvdata_inst02/database/socket/lim-prd1-vm-04_inst02.pid
 server-id=1
 local_infile=0
 query_prealloc_size = 8388608
 query_cache_min_res_unit = 2048
 secure_auth = ON
 key_buffer_size = 2G
 key_cache_block_size = 8192

 general_log = 1
 general_log_file = /lvdata_inst02/database/log/log-lim-prd1-vm-04-inst02

 log-bin = /lvdata_inst02/database/bin/log-bin-lim-prd1-vm-04-inst02
 log-bin-index = /lvdata_inst02/database/bin/log-bin-index-lim-prd1-vm-04-inst02
 binlog-format = ROW
 binlog_cache_size = 16M
 max_binlog_cache_size = 4294967295

 log-error = /lvdata_inst02/database/error/log-error-lim-prd1-vm-04-inst02
 log-queries-not-using-indexes

 slow_query_log = 1
 slow_query_log_file = /lvdata_inst02/database/log/log-slow-queries-lim-prd1-vm-04-inst02

 log-slow-admin-statements

 log_warnings = 2
 long_query_time = 5
 max_binlog_size = 2097152

 datadir=/lvdata_inst02/database/data
 tmpdir=/lvdata_inst02/database/temp

 default-storage-engine = innodb
 innodb_file_format = barracuda
 innodb_file_format_max = barracuda
 innodb_data_home_dir = /lvdata_inst02/database/data
 innodb_file_per_table
 innodb_data_file_path = limprd1vm04_inst02_datafile_01:100M:autoextend
 innodb_autoextend_increment = 100
 innodb_buffer_pool_size=6G
 innodb_log_buffer_size=1G
 innodb_log_file_size=128M
 innodb_log_files_in_group=4
 innodb_log_group_home_dir=/lvdata_inst02/database/ib_logs
 innodb_flush_log_at_trx_commit = 1
 sync_binlog = 1
 innodb_support_xa = 1

 # innodb_lock_wait_timeout modified by HEJ 01/22/2010 previous value 10
 innodb_lock_wait_timeout = 20
 innodb_additional_mem_pool_size=16M
 innodb_open_files = 2048

 # The maximum amount of concurrent sessions the MySQL server will
 # allow. One of these connections will be reserved for a user with
 # SUPER privileges to allow the administrator to login even if the
 # connection limit has been reached.

 max_connections = 300
 optimizer_search_depth = 3