MYSQL 配置文件
  
 
 
 
 写道
 
 user = mysql
  port = 3306
  socket = /tmp/mysql.sock
  basedir = /usr/local/mysql
  datadir = /usr/local/mysql/data
  open_files_limit = 3072
  back_log = 200
  max_connections = 600
  max_connect_errors = 512
  table_cache = 307
  external-locking = FALSE
  #max_allowed_packet = 512M
  sort_buffer_size = 2M
  join_buffer_size = 2M
  thread_cache_size = 26
  thread_concurrency = 8
  query_cache_size = 512M
  query_cache_limit = 2M
  #query_cache_min_res_unit = 2k
  default_table_type = MyISAM
  thread_stack = 192K
  transaction_isolation = READ-COMMITTED
  tmp_table_size = 61M
  max_heap_table_size = 61M
  #/usr/local/mysql/data/slow.log
  #/usr/local/mysql/data/error.log
  #long_query_time = 1
  #log-slow-queries = /web/mysql-slow.log
  log_long_format
  server-id = 1
  log-bin = /usr/local/mysql/data/binlog
  binlog_cache_size = 4M
  max_binlog_cache_size = 8M
  max_binlog_size = 512M
  #expire_logs_days = 3
  key_buffer_size = 1024M
  read_buffer_size = 4M
  read_rnd_buffer_size = 16M
  bulk_insert_buffer_size = 64M
  myisam_sort_buffer_size = 512M
  myisam_max_sort_file_size = 10G
  myisam_max_extra_sort_file_size = 10G
  myisam_repair_threads = 1
  myisam_recover
  wait-timeout = 150
  interactive-timeout = 250
  skip-locking
  skip-name-resolve
 
  我的myslq设置
                
        
    
                    转载请注明原文地址: https://ju.6miu.com/read-1126075.html