[client]
port 			= 3306
socket 			= /var/run/mysqld/mysqld.sock

[mysqladmin]
port 			= 3306
socket 			= /var/run/mysqld/mysqld.sock
user			= sys_maint
password		= xxxxxxxxxxxxxxxxxxxxxxxxxxx


[safe_mysqld]
err-log         = /mydata/log/mysql.err


[mysqld]
user            	= mysql
pid-file        	= /var/run/mysqld/mysqld.pid
socket          	= /var/run/mysqld/mysqld.sock
log-error       	= /mydata/log/mysqld.err
transaction-isolation   = READ-COMMITTED
#log-warnings


### DIRECTORIES
#
basedir         = /usr
datadir         = /mydata/data
tmpdir          = /mydata/tmp


### LOG SLOW QUERIES
#
#long_query_time = 10
#log-slow-queries = /mydata/log/slow-queries.log
#log-queries-not-using-indexes


### NETWORKING
#
skip-name-resolve
port = 3306
max_connections		= 5000
#max_connect_errors	= 20
#max_user_connections	= 600
max_allowed_packet 	= 256M
wait_timeout		= 14400
net_write_timeout	= 300
net_read_timeout	= 300
#skip-networking


### SLAVE
#
#slave-skip-errors=1062
slave_net_timeout	= 60
skip-slave-start

### READ-ONLY
#
read_only		= ON


### BINLOG
#
server-id = 20
log-bin = /mydata/binlog/veso3dblx02-bin
binlog_format		= mixed
binlog-ignore-db	= mysql
report-host		= veso3dblx02
expire_logs_days	= 7
sync_binlog		= 0
binlog_cache_size	= 128K
relay-log-space-limit	= 50G


### REPLICATION AUTO INCREMENT
###	to put once startup configuration of replication
#
auto_increment_increment	= 2
auto_increment_offset		= 2
log-slave-updates
# As of MySQL 5.5.28, avoid replicate-(wild-)ignore-{db,table}
# See http://bugs.mysql.com/bug.php?id=66915
# Should be fixed for 5.5.29+
#replicate-ignore-db		= mysql

### TABLES
#
open_files_limit    = 147456
table_cache 	    = 65535
tmp_table_size 	    = 256M
max_heap_table_size = 256M
max_tmp_tables 	    = 64

skip-external-locking
concurrent_insert   = 2
low_priority_updates= 1

### BUFFER
#
key_buffer 		= 2048M
sort_buffer_size 	= 64M
read_buffer_size 	= 64M
join_buffer_size 	= 128M
bulk_insert_buffer_size = 512M
read_rnd_buffer_size 	= 4M



### THREAD
#
thread_cache_size  = 120
thread_concurrency = 48
thread_stack	   = 1M



### QUERY CACHE
#
query_cache_type 	= 0
query_cache_size 	= 0
query_cache_limit 	= 8M
query_alloc_block_size 	= 16K
query_cache_min_res_unit = 4K



### MYISAM
#
myisam_repair_threads 		= 16
myisam_sort_buffer_size 	= 512M


#skip-innodb

### INNODB
#
innodb_data_file_path = ibdata1:10M:autoextend
innodb_buffer_pool_size 	= 48G
innodb_additional_mem_pool_size = 32M
innodb_thread_concurrency 	= 16
innodb_log_buffer_size 		= 128M
innodb_log_file_size 		= 512M
innodb_log_files_in_group	= 2
innodb_file_io_threads 		= 4
innodb_max_dirty_pages_pct 	= 90
innodb_file_per_table
innodb_flush_log_at_trx_commit	= 2
innodb_io_capacity		= 250
innodb_read_io_threads		= 8
innodb_write_io_threads		= 8
innodb_purge_threads		= 0
innodb_read_ahead_threshold	= 56
innodb_buffer_pool_instances	= 24
#innodb_support_xa		= 1
#innodb_table_locks		= 1
innodb_use_native_aio		= 1
#innodb_doublewrite		= 1
#innodb_checksums		= 1

# rajout pour la couche d'abstraction
group_concat_max_len = 100000

[mysqldump]
quick
max_allowed_packet = 256M


[mysql]
prompt = \U\_(\d)\_>\_
no-auto-rehash


[myisamchk]
key_buffer 		= 1024M
sort_buffer_size 	= 1024M
read_buffer 		= 16M
write_buffer 		= 16M