[mysqld]
port		= 3306
datadir=/var/lib/mysql
#tmpdir=/var/lib/mysqltmp
skip-external-locking
socket=/var/lib/mysql/mysql.sock
table-open-cache = 4096
table-definition-cache = 2048
log_warnings=2
thread_cache_size=16
thread_concurrency=8
back_log=100
max_connect_errors=10000
open-files=20000
interactive_timeout=600
wait_timeout=60
max_connections=600
lower_case_table_names=1
#sql_mode=TRADITIONAL
slow-query-log-file=/var/log/mysql/slow_queries.log
long_query_time=10
#log-queries-not-using-indexes
max_allowed_packet=32M
tmp_table_size=96M
max_heap_table_size=96M
query_cache_size=128M
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=8M
join_buffer_size=6M
#default-storage-engine=InnoDB
key_buffer_size=32M
myisam_sort_buffer_size=32M
innodb_data_file_path=ibdata1:10M:autoextend:max:500M
innodb_log_file_size=100M
innodb_buffer_pool_size=4G
innodb_file_per_table=1
innodb_open_files=4096
server-id=1 
log-error=/var/log/mysql/mysqld.log
general_log=0
general_log_file=/var/log/mysql/mysql_query.log
#log-bin=/var/lib/mysqllogs/bin-log
#log-bin-index=/var/lib/mysqllogs/bin-log.index
#relay-log=/var/lib/mysqllogs/relay-log
#relay-log-index=/var/lib/mysqllogs/relay-log.index
#expire_logs_days=14
#log-slave-updates
#sync_binlog=1
#auto_increment_increment=2
#auto_increment_offset=1


[mysql.server]
user=mysql
#basedir=/var/lib

[mysqld_safe]
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit=2048