[mysqld]
#datadir=/var/lib/mysql
#tmpdir = /var/lib/mysql/tmp
port            = 3306

max_heap_table_size=512M 
open_files_limit = 32000 
group_concat_max_len = 1M

#By request( all engines)
tmp_table_size=512M 
sort_buffer_size = 64M   
join_buffer_size = 256M 

#During load or enable keys
bulk_insert_buffer_size = 1G
myisam_sort_buffer_size=1G

table_open_cache = 2048
thread_cache_size = 64

#Time out and linked problems
connect_timeout=28800
innodb_lock_wait_timeout=28800
wait_timeout=28800
interactive_timeout=28800
max_allowed_packet = 128M

#Low query
slow_query_log=1
slow_query_log_file=slow-queries.log
long_query_time=120

#At startup
key_buffer_size = 1G 
innodb_buffer_pool_size = 1G


#Innob DB 
innodb_stats_on_metadata=0
innodb_flush_method=O_DIRECT
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=1G #taille buffer redo log
innodb_log_file_size=512M
innodb_file_per_table=1
innodb_open_files=1024
innodb_max_dirty_pages_pct=30


[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
innodb_lock_wait_timeout=1500