全部答案

2017-07-26 10:57:11

•   Memory-Related Variables
  内存相关变量
  These server variables control the amount of memory allocated to the various buffers and caches within MySQL。
    
  以下这些服务器变量控制这MySQL分配给各种缓冲或者换缓存的内存总数。
  join_buffer_size
  (PER SESSION) Controls the amount of memory allocated to perform joins on tables that have no keys which can be used to perform a condition filter。
     Allocated for each table joined without necessary filter conditions
  (会话变量) 控制在对没有索引的表连接时分配的内存总数，它可以用做条件过滤器。为连接中的每个表分配而无需必要的过滤条件。
    
  key_buffer_size
  (GLOBAL) (MyISAM-only) Controls the amount of memory allocated to the MyISAM index key cache
  (全局变量) (只针对MyISAM表) 空置分配给MyISAM索引缓存的内存总数。
    
  innodb_buffer_pool_size
  (GLOBAL) (InnoDB-only) Controls the amount of memory allocated to the InnoDB cache containing both clustered data and secondary index pages
  (全局变量) (只针对Innodb) 控制分配给包括集群数据以及次要索引页的Innodb缓存的内存总数。
    
  innodb_additional_mem_pool_size
  (GLOBAL) (InnoDB-only) Controls the amount of memory allocated to the buffer storing the InnoDB internal data dictionary
  (全局变量) (只针对Innodb) 控制分配给对Innodb内部数据字典进行排序所需的缓冲。
    
  innodb_log_buffer_size
  (GLOBAL) (InnoDB-only) Controls the amount of memory allocated to the buffer storing InnoDB write-ahead log entries
  (全局变量) (只针对Innodb) 控制分配给对Innodb存储提前写日志记录所需的缓冲。
    
  query_cache_size
  (GLOBAL) Controls the amount of memory allocated to the Query Cache
  (全局变量) 控制分配给查询缓存的内存总量。
  read_buffer_size
  (PER SESSION) Controls the amount of memory allocated to the connecting thread in order to process a table scan
  (会话变量) 控制分配给处理扫描表的连接线程内存总数。
    
  read_rnd_buffer_size
  (PER SESSION) Controls the amount of memory allocated to the buffer used to read previously sorted results。
    

  全部
  

  傅***

  2017-07-26 10:57:11

  44 2 评论

  分享
  提交评论