mysql 5.7.12二进制安装

jxwjq

[client]　　port            = 3306
　　socket          = /tmp/mysql.sock
　　[mysql]
　　no-auto-rehash
　　[mysqld]
　　user    = mysql
　　port    = 3306
　　socket  = /tmp/mysql.sock
　　basedir = /aliyun/server/mysql-5.7.12/
　　datadir = /data/mysql/data/
　　open_files_limit    = 1024
　　back_log = 600
　　max_connections = 800
　　max_connect_errors = 3000
　　table_cache = 614
　　external-locking = FALSE
　　max_allowed_packet =8M
　　sort_buffer_size = 1M
　　join_buffer_size = 1M
　　thread_cache_size = 100
　　thread_concurrency = 2
　　query_cache_size = 2M
　　query_cache_limit = 1M
　　query_cache_min_res_unit = 2k
　　thread_stack = 192K
　　tmp_table_size = 2M
　　max_heap_table_size = 2M
　　long_query_time = 1
　　pid-file = /data/mysql/mysql.pid
　　log-bin = /data/mysql/logs/bin-log/mysql-bin
　　server_id = 1
　　relay-log = /data/mysql/logs/relay-log/relay-bin
　　relay-log-info-file = /data/mysql/relay-log.info
　　binlog_cache_size = 1M
　　max_binlog_cache_size = 1M
　　max_binlog_size = 2M
　　expire_logs_days = 7
　　key_buffer_size = 16M
　　read_buffer_size = 1M
　　read_rnd_buffer_size = 1M
　　bulk_insert_buffer_size = 1M
　　lower_case_table_names = 1
　　skip-name-resolve
　　slave-skip-errors = 1032,1062
　　replicate-ignore-db=mysql
　　innodb_additional_mem_pool_size = 4M
　　innodb_buffer_pool_size = 32M
　　innodb_data_file_path = ibdata1:10M:autoextend
　　innodb_file_io_threads = 4
　　innodb_thread_concurrency = 8
　　innodb_flush_log_at_trx_commit = 2
　　innodb_log_buffer_size = 2M
　　innodb_log_file_size = 4M
　　innodb_log_files_in_group = 3
　　innodb_max_dirty_pages_pct = 90
　　innodb_lock_wait_timeout = 120
　　innodb_file_per_table = 0
　　[mysqldump]
　　quick
　　max_allowed_packet = 2M
　　[mysqld_safe]
　　log-error=/data/mysql/logs/error.log
　　pid-file=/data/mysql/mysqld_safe.pid