mysql 几个buffer相关的变量

show variables like "%buffer%";

大概得到下面几个东西

Variable Name
"innodb_log_buffer_size"
"join_buffer_size"
"key_buffer_size"
"myisam_sort_buffer_size"
"net_buffer_length"
"preload_buffer_size"
"read_buffer_size"
"read_rnd_buffer_size"
"sort_buffer_size"
"sql_buffer_result"

"Variable_name";"Value"
"binlog_cache_size"
"have_query_cache"
"key_cache_age_threshold"
"key_cache_block_size"
"key_cache_division_limit"
"max_binlog_cache_size"
"query_cache_limit"
"query_cache_min_res_unit"
"query_cache_size"
"query_cache_type"
"query_cache_wlock_invalidate"
"table_definition_cache"
"table_open_cache"
"thread_cache_size"

• read_buffer_size

  Each thread that does a sequential scan allocates a buffer of this size (in bytes) for each table it scans. If you do many sequential scans, you might want to increase this value, which defaults to 131072. 

  
  

  When tuning a MySQL server, the two most important variables to configure are key_buffer_size and table_open_cache. You should first feel confident that you have these set appropriately before trying to change any other variables.

  The following examples indicate some typical variable values for different runtime configurations.