jxwjq 发表于 2018-10-6 11:47:32

mysql 5.7.12二进制安装

  port            = 3306
  socket          = /tmp/mysql.sock
  
  no-auto-rehash
  
  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
  
  quick
  max_allowed_packet = 2M
  
  log-error=/data/mysql/logs/error.log
  pid-file=/data/mysql/mysqld_safe.pid

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