joozh 发表于 2018-10-1 08:59:40

二进制安装MySQL 5.6

  
back_log = 2000
  
basedir = /usr/local/mysql
  
binlog-format = MIXED
  
character_set_server = utf8
  
datadir = /data/mysql/data
  
event_scheduler = ON
  
expire_logs_days = 1
  
innodb_autoinc_lock_mode = 1
  
innodb_buffer_pool_size = 1073741824
  
innodb_data_file_path = ibdata1:500M:autoextend
  
innodb_data_home_dir = /data/mysql/data
  
innodb_file_per_table = 1
  
innodb_flush_log_at_trx_commit = 2
  
innodb_flush_method = O_DIRECT
  
innodb_io_capacity = 2000
  
innodb_log_buffer_size = 8388608
  
innodb_log_files_in_group = 3
  
innodb_log_group_home_dir = /data/mysql/data
  
innodb_max_dirty_pages_pct = 50
  
innodb_open_files = 1024
  
innodb_read_io_threads = 8
  
innodb_thread_concurrency = 20
  
innodb_write_io_threads = 8
  
innodb_lock_wait_timeout = 10
  
innodb_buffer_pool_load_at_startup = 1
  
innodb_buffer_pool_dump_at_shutdown = 1
  
key_buffer_size = 3221225472
  
innodb_log_file_size = 1G
  
local_infile = 1
  
log-bin = /data/mysql/binlog/mysql-bin.log
  
log_bin_trust_function_creators = 1
  
log_output = FILE
  
long_query_time = 1
  
log-error = /data/mysql/log/error.log
  
max_allowed_packet = 134217728
  
max_connect_errors = 1000000
  
max_connections = 2000
  
myisam_sort_buffer_size = 33554432
  
myisam_recover = 1
  
join_buffer_size = 8388608
  
tmp_table_size = 33554432
  
net_buffer_length = 8192
  
performance_schema = 1
  
performance_schema_max_table_instances = 200
  
pid-file = /data/mysql/mysqld.pid
  
port = 3306
  
query_cache_size = 0
  
query_cache_type = 0
  
read_buffer_size = 20971520
  
read_rnd_buffer_size = 16M
  
max_heap_table_size = 33554432
  
bulk_insert_buffer_size = 134217728
  
#relay-log = /data/mysql/log/mysql-relay.log
  
secure-file-priv = /data/mysql/tmp
  
server-id = 1131053306
  
skip-slave-start
  
skip_name_resolve
  
slave-load-tmpdir = /data/mysql/tmp
  
slow-query-log-file = /data/mysql/log/mysql-slow.log
  
slow_query_log = 1
  
socket = /tmp/mysql.sock
  
sort_buffer_size = 2097152
  
table_open_cache = 128
  
thread_cache_size = 50
  
tmpdir = /data/mysql/tmp
  
user = mysql
  
wait_timeout = 2880000
  
transaction_isolation=read-committed
  
long_query_time=1
  
sync_binlog=0
  
innodb_flush_log_at_trx_commit=0
  

  
log-error = /data/mysql/log/error.log
  
pid-file = /data/mysql/mysqld.pid


页: [1]
查看完整版本: 二进制安装MySQL 5.6