[client]
port		= 36777
socket		= /data1/mortyzhou/mysql-5.7-files/mysql.sock

[mysqld]
user=root 
log-error = /data1/mortyzhou/mysql-5.7-files/mysqld.err
open-files-limit = 10240
port		= 36777
socket		= /data1/mortyzhou/mysql-5.7-files/mysql.sock
pid-file    = /data1/mortyzhou/mysql-5.7-files/mysqld.pid
datadir     = /data1/mortyzhou/mysql-5.7-files/data/
basedir     = /data1/mortyzhou/mysql-5.7-files/
slow_query_log_file = /data1/mortyzhou/mysql-5.7-files/slow_query.log
tmpdir = /data1/mortyzhou/mysql-5.7-files/tmp/
skip-log-bin

secure_file_priv = /data1/mortyzhou/mysql-5.7-files/data/
default-authentication-plugin=mysql_native_password

slow_query_log = 1
max_connect_errors=999999999
performance_schema = OFF

skip-external-locking
max_prepared_stmt_count=10000000


key_buffer_size = 16M
max_allowed_packet = 1G
table_open_cache = 16000
table_open_cache_instances=64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
thread_cache_size = 512
thread_stack = 128K

innodb_log_group_home_dir = /data1/mortyzhou/mysql-5.7-files/innodb_log
innodb_log_buffer_size = 64M


thread_stack = 512K
innodb_file_per_table = 1
innodb_lock_wait_timeout=7200
open_files_limit=102400
max_connections= 10240

tmp_table_size= 3M

innodb_purge_batch_size=300
innodb_buffer_pool_size=1310K
innodb_log_file_size =  1M
innodb_flush_log_at_trx_commit=2
innodb_io_capacity=20000
innodb_flush_method = O_DIRECT
innodb_open_files=3000
innodb_strict_mode=1
innodb_doublewrite=on
innodb_read_io_threads = 2
innodb_write_io_threads = 2
innodb_purge_threads=4
innodb_adaptive_flushing=ON
innodb_adaptive_flushing_lwm=10
innodb_adaptive_hash_index_parts=8
innodb_adaptive_hash_index=ON
innodb_buffer_pool_instances=2
innodb_thread_concurrency=0
innodb_commit_concurrency=0
innodb_flush_neighbors=0
innodb_lru_scan_depth=1024
innodb_io_capacity_max=200000
innodb_io_capacity=100000
innodb_use_native_aio = ON
innodb_undo_logs = 4
innodb_change_buffering=all
innodb_change_buffer_max_size=25
innodb_sync_array_size=1
table_definition_cache= 768
thread_cache_size = 512
interactive_timeout=3600
wait_timeout=3600

read_only = 0

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

[mysqld_safe]
core-file-size=unlimited