[mysqld]
#===================
#Logs et replication
#===================
server-id=4
set-variable = binlog_cache_size=4096
#On ne synchronise pas trop souvent, pour gagner du temps, et on n'a pas besoin d'avoir une garantie complète de récupération d'erreurs en cas de crash
set-variable = sync_binlog=50
# Au dessus de 5 sec je considere query long (defaut = 10s)
log-slow-queries=mysql-slow.log
set-variable = long_query_time=1
#Replication
relay-log-purge=1
report-host=magic-sql2
replicate-do-db=magic4
replicate-ignore-table=magic4.PENDING_PUBLICATION
replicate-ignore-table=magic4.PLANNING_SYNCHRO
replicate-ignore-db=mysql
#Errors
log-error

#===================
#Mode transactionnel
#===================
transaction-isolation = READ-COMMITTED

#=====================
#Gestion des acces
#=====================
set-variable    = max_connections=500
set-variable    = max_user_connections=500

#=====================
#Gestion de la mémoire
#=====================
set-variable    =  bulk_insert_buffer_size=0
set-variable    =  join_buffer_size=65536
set-variable	=  key_buffer_size=8388608
set-variable    =  thread_cache_size=16
# Try number of CPU's*2 for thread_concurrency
set-variable    =  thread_concurrency=8
set-variable    =  max_allowed_packet=1M
set-variable    =  read_buffer_size=1M
set-variable    =  read_rnd_buffer_size=262144
set-variable    =  sort_buffer_size=1M
set-variable    =  myisam_sort_buffer_size=64M
set-variable	=  innodb_max_purge_lag=50000

#=====================
#Gestion du cache
#=====================
set-variable    =  query_cache_size=10485760
set-variable    =  query_cache_limit=512000
set-variable    =  query_cache_type=2
set-variable    =  query_cache_min_res_unit=2048
set-variable    =  query_cache_wlock_invalidate=1

#=====================
#Gestion des fichiers
#=====================
skip-locking
set-variable    = table_cache=768

#### Begin Optimize #####
set-variable    = slave_transaction_retries=10
#### End Optimize #####


[mysqladmin]
user= root


#### Begin Optimize #####
[mysqldump]
quick
set-variable    = max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
set-variable    = key_buffer=128M
set-variable    = sort_buffer=128M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M

[myisamchk]
set-variable    = key_buffer=128M
set-variable    = sort_buffer=128M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M

[mysqlhotcopy]
#interactive-timeout
user= root
#### End Optimize #####