Can't change key_buffer_size

MySQL & MariaDB Other MySQL® Questions
1

Hi Peter,
When I try to change the key_buffer_size to 4GB, it doesnt get effective. I don’t see the key_buffer_size changing to 4GB. I am not sure why it doesnt get changed.
Here is the command that I followed from this forum:

mysql> SET GLOBAL key_buffer_size=4917467096;
Query OK,0 rows affected(0.0 seconds)

After this if I say show variables like “key_buffer_size”, it gives me the old number as 8388600.

Please let me know how can I change it.

Thanks,
Harita

2
[B]Harita wrote on Fri, 14 September 2007 02:19[/B]
Hi Peter, When I try to change the key_buffer_size to 4GB, it doesnt get effective. I don't see the key_buffer_size changing to 4GB. I am not sure why it doesnt get changed. Here is the command that I followed from this forum:

mysql> SET GLOBAL key_buffer_size=4917467096;
Query OK,0 rows affected(0.0 seconds)

After this if I say show variables like “key_buffer_size”, it gives me the old number as 8388600.

Please let me know how can I change it.

Thanks,
Harita

Try:

SET GLOBAL key_buffer_size= 4G

3

Hi,
I tried SET GLOBAL key_buffer_size=4G but this I get an error:

ERROR 1232 (42000): Incorrect argument type to variable ‘key_buffer_size’

So, I am still not able to change the configuration.

Thanks,
Harita