SET commands don"t handle values like my.cnf does.

Using the latest 4.0.xx build, I have this in my.cnf:

set-variable = key_buffer=256M

But I decided that I want to double the value without restarting the
server. So I try this:

mysql> set global key_buffer_size = 512M;
ERROR 1232: Wrong argument type to variable 'key_buffer_size'

Hmm. It's not at all clear from the docs here:

http://www.mysql.com/doc/en/System_Variables.html

that my syntax is invalid. In fact, the bottom of that page even
refers to the command-line docs, which point to the Tuning Server
Parameters docs:

http://www.mysql.com/doc/en/Server_parameters.html

that has examples using "M" suffixes on values.

Of course, this works:

mysql> set global key_buffer_size = 536870912;
Query OK, 0 rows affected (0.04 sec)

But I had to do the 512*1024*1024 math myself.

How-To-Repeat: Do just what I did.

You could either call this a documentation bug or a missing feature.
Personally, I'd like to be able to use the same size specifiers in SET
commands that I use in my.cnf.

Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
| http://jeremy.zawodny.com/

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: SET commands don"t handle values like my.cnf does.

Hi,

> Using the latest 4.0.xx build, I have this in my.cnf:
>=20
> set-variable =3D key_buffer=3D256M
>=20
> But I decided that I want to double the value without restarting the
> server. So I try this:
>=20
> mysql> set global key_buffer_size =3D 512M;
> ERROR 1232: Wrong argument type to variable 'key_buffer_size'

Jeremy, thanks for the bug report. I've entered it into our bug db, you can
follow its progress at: http://bugs.mysql.com/bug.php?id=3D226


Rgds,
Indrek

--=20
MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Indrek Siitan
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Support Guy
/_/ /_/\_, /___/\___\_\___/ Uuem=F5isa, Haapsalu, Estonia
<___/ www.mysql.com


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org