[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
bind-address=127.0.0.1
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
key_buffer_size =256M
open_files_limit=100000
query_cache_limit = 2M
query_cache_size = 512M
query_cache_type = 1 
table_cache = 100000
concurrent_insert=2
#skip-innodb
#skip-bdb
max_allowed_packet=200M
tmp_table_size=4048M
max_heap_table_size=4048M
max_connections=100
max_user_connections=30
low_priority_updates=1
wait_timeout= 300
interactive_timeout =300

#extra tunning
join_buffer_size=128M
thread_cache_size=20
slow_query_log=1
log_slow_filter="tmp_table_on_disk,filesort_on_disk"
long_query_time=1 
tmpdir="/dev/shm/"

 
#innodb
innodb_log_buffer_size = 80M
innodb_max_dirty_pages_pct = 90
innodb_log_file_size = 5242880
innodb_file_per_table = 1
innodb_data_file_path = "ibdata1:10M:autoextend"
innodb_autoextend_increment = 8
innodb_open_files = 100000
# Set buffer pool size to 50-80% of your computer's memory
innodb_buffer_pool_size=8024M
innodb_additional_mem_pool_size=1280M
innodb_flush_log_at_trx_commit=1
innodb_thread_concurrency=4
# unkoment for recovery
#innodb_force_recovery = 4
default-storage-engine=innodb
 
skip-external-locking
 
#percona tweaks
userstat=1
 
#general_log=1
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
 
 
 
[mysql]
 
default-character-set=utf8