no match variable

[Roman Smirak]

Hello,

* I would like to set variables related to memory (i.e. key_buffer_size, table_cache, read_buff_size, etc.)
* I have tried to set the variables in context of my.cnf (in context of [mysqld] section), I have tried to use params directly from command line using -O, --set-variable, or --key_buffer_size (with and without _size postfix)
* that produced following error: no match variable: -O 'key_buffer_size=64M', because of:
* enabled variables are following:
[root@backupserver bin]# mysql --help
Possible variables for option --set-variable (-O) are:
connect_timeout current value: 0
max_allowed_packet current value: 16777216
net_buffer_length current value: 16384
select_limit current value: 1000
max_join_size current value: 1000000
* => I can't set key_buffer_size, but:
[root@backupserver bin]# /usr/bin/mysqladmin variables | grep key_buffer_size
| key_buffer_size | 8388600 |
* is included into system.

** Question: how to set e.g. key_buffer_size variable ?

MySQL version: 3.23.49
OS: RH Linux 7.3 2.96-110

Thanks, Roman