[client]
socket = /u01/mysql/run/mysql.sock
default-character-set = gbk

[innotop]
socket = /u01/mysql/run/mysql.sock

[mysql]
prompt = \\u@\\d \\r:\\m:\\s>
no-auto-rehash


[mysqld_safe]
pid-file = /u01/mysql/run/mysqld.pid

[mysqld]

#### Baes dir ####
basedir = /u01/mysql
datadir = /u01/mysql/data
tmpdir = /u01/mysql/tmp
socket = /u01/mysql/run/mysql.sock
open_files_limit = 65535

#### Base configure info ####
default-character-set = gbk
port = 3306
skip-locking
skip-name-resolve
old_passwords = 0
lower_case_table_names = 1
open_files_limit = 65535
read_rnd_buffer_size = 5M
max_allowed_packet = 24M
max_connect_errors = 50000
max_connections = 3200
max_user_connections = 3000
thread_cache_size=256
table_cache=512
thread_stack=524288
#### Log info ####
log-error = /u01/mysql/log/alert.log
log_slow_queries = /u01/mysql/log/slow.log
log-slow-admin-statements
#log-queries-not-using-indexes
long_query_time = 1

#### Binary log && Relay log ####
log-bin = /u01/mysql/log/mysql-bin
log-slave-updates = 1
relay-log = /u01/mysql/log/mysqld-relay-bin
relay-log-index = /u01/mysql/log/mysqld-relay-bin.index
master-info-file = /u01/mysql/log/master.info
relay-log-info-file = /u01/mysql/log/relay-log.info
max_binlog_size = 500M

#### query cache ####
query_cache_size = 30M
query_cache_limit = 1K
query_cache_min_res_unit = 1K
query_cache_type=2


#myisam
concurrent_insert = 2
key_buffer = 100M
sort_buffer_size = 100K
join_buffer_size = 100K
read_buffer_size = 1M
myisam_sort_buffer_size = 100M

#innodb plugin
ignore_builtin_innodb
plugin_load=innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_locks=ha_innodb_plugin.so;innodb_lock_waits=ha_innodb_plugin.so;innodb_cmp=ha_innodb_plugin.so;innodb_c
mp_reset=ha_innodb_plugin.so;innodb_cmpmem=ha_innodb_plugin.so;innodb_cmpmem_reset=ha_innodb_plugin.so
innodb_file_format=Antelope
innodb_strict_mode=1

wait_timeout = 28800
#innodb
default-storage-engine = INNODB
innodb_flush_method = O_DIRECT
                 
innodb_open_files=60000 
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 100
innodb_additional_mem_pool_size = 20M
innodb_log_buffer_size= 200M
innodb_log_file_size = 1000M
innodb_log_files_in_group = 4
innodb_file_io_threads = 4
innodb_thread_concurrency = 64
innodb_write_io_threads=8
innodb_read_io_threads=8
innodb_max_dirty_pages_pct = 50
innodb_io_capacity=2000
innodb_data_home_dir=/u01/mysql/data/
innodb_data_file_path =ibdata1:5G;ibdata2:5G:autoextend
max_binlog_cache_size = 2G
binlog_format = row
sync_binlog =0
#########this is ssd my.cnf ##################
server_id=1626260
innodb_buffer_pool_size=70G