[client]

port            = 3306

socket          = /tmp/mysql.sock

character-set=utf8

[mysqld]

port            = 3306

socket          = /tmp/mysql.sock

datadir=/opt/mysql_data

skip-name-resolve

character-set-server=utf8

lower_case_table_names=1

expire-logs-days=60

back_log = 500

max_connections = 5000

max_connect_errors =100000

table_open_cache = 2048


max_allowed_packet = 16M

binlog_cache_size = 1M

max_heap_table_size = 64M

sort_buffer_size = 8M

join_buffer_size = 8M

thread_cache_size = 8

query_cache_size = 64M

query_cache_limit = 2M

ft_min_word_len = 4


thread_stack = 192K

transaction_isolation = REPEATABLE-READ

tmp_table_size = 64M


log-bin=/opt/mysql_log/mysql-bin

binlog_format=mixed


slow_query_log_file=/opt/mysql_slow/localhost-slow.log

slow_query_log

long_query_time=1

#log-queries-not-using-indexes

#tmpdir = /tmp

relay-log=/opt/mysql_log/relay-bin

# ***  Replication related settings

server-id = 101

#replicate-ignore-db=mysql

#replicate-ignore-db=test

key_buffer_size = 32M

myisam_repair_threads = 1

myisam_recover


# *** INNODB Specific options ***

#default_table_type = InnoDB

innodb_buffer_pool_size = 64G

innodb_data_file_path = ibdata1:10M:autoextend

innodb_file_per_table=1


innodb_file_io_threads = 4

#innodb_force_recovery=1

innodb_thread_concurrency = 16

innodb_flush_log_at_trx_commit = 2

innodb_log_buffer_size = 8M

innodb_log_file_size = 256M

innodb_log_files_in_group = 6

innodb_max_dirty_pages_pct = 90

innodb_lock_wait_timeout = 120

innodb_flush_method=O_DIRECT


[mysqldump]

quick

max_allowed_packet = 16M


[mysql]

no-auto-rehash

#safe-updates


[myisamchk]

key_buffer_size = 512M

sort_buffer_size = 512M

read_buffer = 8M

write_buffer = 8M


[mysqlhotcopy]

interactive-timeout


[mysqld_safe]

open-files-limit = 65535

log-error=/opt/mysql_log/error.log

pid-file=/opt/mysql_data/mysql.pid