MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Egor Egorov Date:June 10 2004 11:13am
Subject:Re: key_buffer or key_buffer_size
View as plain text  
Chambon <bernard.chambon@stripped> wrote:

> Can somebody tell me if 'key_buffer' and 'key_buffer_size' are the same variables ?

Yes. _size is deprecated. 

> Perhaps it is just a question of syntax, I mean, in the my.cnf
>    you write  key_buffer=100M
> or you write  set-variable = key_buffer_size=100M

It's the same. "set-variable" is deprecated, so use the first syntax instead.

> Same question for
>  sort_buffer and sort_buffer_size,
>  thread_cache and thread_cache_size,
>  innodb_buffer_pool and innodb_buffer_pool_size
> etc.

All the same :-)





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com



Thread
key_buffer or key_buffer_sizeChambon7 Jun
  • Re: key_buffer or key_buffer_sizeEgor Egorov10 Jun