1898
1898
(char**) &max_system_variables.join_buff_size, 0, GET_UINT64,
1899
1899
REQUIRED_ARG, 128*1024L, IO_SIZE*2+MALLOC_OVERHEAD, ULONG_MAX,
1900
1900
MALLOC_OVERHEAD, IO_SIZE, 0},
1901
{"key_buffer_size", OPT_KEY_BUFFER_SIZE,
1902
N_("The size of the buffer used for index blocks for MyISAM tables. "
1903
"Increase this to get better index handling (for all reads and multiple "
1904
"writes) to as much as you can afford;"),
1905
(char**) &dflt_key_cache_var.param_buff_size,
1908
REQUIRED_ARG, KEY_CACHE_SIZE, MALLOC_OVERHEAD, SIZE_MAX, MALLOC_OVERHEAD,
1910
{"key_cache_age_threshold", OPT_KEY_CACHE_AGE_THRESHOLD,
1911
N_("This characterizes the number of hits a hot block has to be untouched "
1912
"until it is considered aged enough to be downgraded to a warm block. "
1913
"This specifies the percentage ratio of that number of hits to the "
1914
"total number of blocks in key cache"),
1915
(char**) &dflt_key_cache_var.param_age_threshold,
1917
0, (GET_UINT32), REQUIRED_ARG,
1918
300, 100, ULONG_MAX, 0, 100, 0},
1919
{"key_cache_block_size", OPT_KEY_CACHE_BLOCK_SIZE,
1920
N_("The default size of key cache blocks"),
1921
(char**) &dflt_key_cache_var.param_block_size,
1923
0, (GET_UINT32), REQUIRED_ARG,
1924
KEY_CACHE_BLOCK_SIZE, 512, 1024 * 16, 0, 512, 0},
1925
{"key_cache_division_limit", OPT_KEY_CACHE_DIVISION_LIMIT,
1926
N_("The minimum percentage of warm blocks in key cache"),
1927
(char**) &dflt_key_cache_var.param_division_limit,
1929
0, (GET_UINT32) , REQUIRED_ARG, 100,
1931
1901
{"max_allowed_packet", OPT_MAX_ALLOWED_PACKET,
1932
1902
N_("Max packetlength to send/receive from to server."),
1933
1903
(char**) &global_system_variables.max_allowed_packet,