首页 > 学院 > 综合知识 > 正文

my-innodb-heavy-4G.cnf配置文件解说

2022-07-15 12:02:31
字体:
来源:转载
供稿:网友
  [client]                   
  port  = 3306    #指定mysql启动端口为3306
  socket  = /application/mysql-5.5.32/tmp/mysql.sock  ##指定socket 路径
  [mysqld]
  port  = 3306               
  socket  = /application/mysql-5.5.32/tmp/mysql.sock
  back_log = 50              
  max_connections = 100      
  max_connect_errors = 10    
  table_open_cache = 2048    
  max_allowed_packet = 16M   
  binlog_cache_size = 1M     
  max_heap_table_size = 64M  
  read_buffer_size = 2M      
  read_rnd_buffer_size = 16M
  sort_buffer_size = 8M      
  join_buffer_size = 8M      
  thread_cache_size = 8      
  thread_concurrency = 8     
  query_cache_size = 64M     
  query_cache_limit = 2M     
  ft_min_word_len = 4        
  default-storage-engine = MYISAM        
  thread_stack = 192K                    
  transaction_isolation = REPEATABLE-READ
  tmp_table_size = 64M                   
  log-bin=mysql-bin                      
  binlog_format=mixed                    
  slow_query_log                         
  long_query_time = 2                    
  server-id = 1                          
  key_buffer_size = 32M                  
  bulk_insert_buffer_size = 64M          
  myisam_sort_buffer_size = 128M         
  myisam_max_sort_file_size = 10G        
  myisam_repair_threads = 1              
  myisam_recover                         
  innodb_additional_mem_pool_size = 16M  
  innodb_buffer_pool_size = 2G           
  innodb_data_file_path = ibdata1:10M:autoextend  
  innodb_write_io_threads = 8        
  innodb_read_io_threads = 8             
  innodb_thread_concurrency = 16         
  innodb_flush_log_at_trx_commit = 1     
  innodb_log_buffer_size = 8M            
  innodb_log_file_size = 256M            
  innodb_log_files_in_group = 3          
  innodb_max_dirty_pages_pct = 90        
  innodb_lock_wait_timeout = 120         
  [mysqldump]
  quick
  max_allowed_packet = 16M  
  [mysql]
  no-auto-rehash
  [myisamchk]
  key_buffer_size = 512M
  sort_buffer_size = 512M
  read_buffer = 8M
  write_buffer = 8M
  [mysqlhotcopy]
  interactive-timeout
  [mysqld_safe]
  open-files-limit = 8192

(编辑:错新网)

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表