Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » Can't change key_buffer_size
Can't change key_buffer_size [message #1828] Fri, 14 September 2007 02:19 Go to next message
Harita is currently offline Harita
Messages: 2
Registered: September 2007
Junior Member
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
Report message to a moderator
Re: Can't change key_buffer_size [message #1830 is a reply to message #1828 ] Fri, 14 September 2007 09:40 Go to previous messageGo to next message
allworknoplay is currently offline allworknoplay
Messages: 58
Registered: September 2007
Location: New York
Member
Harita wrote on Fri, 14 September 2007 02:19

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
Report message to a moderator
Re: Can't change key_buffer_size [message #1834 is a reply to message #1830 ] Fri, 14 September 2007 13:11 Go to previous messageGo to next message
Harita is currently offline Harita
Messages: 2
Registered: September 2007
Junior Member
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
Report message to a moderator
Re: Can't change key_buffer_size [message #1835 is a reply to message #1834 ] Fri, 14 September 2007 14:46 Go to previous message
allworknoplay is currently offline allworknoplay
Messages: 58
Registered: September 2007
Location: New York
Member
Harita wrote on Fri, 14 September 2007 13:11

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




Well let's see if we can even change it, since you're at the default 8M, let's change it to 100M, see what happens..

SET GLOBAL key_buffer_size=100M
Report message to a moderator
Previous Topic:Experience with innodb_flush_method setting
Next Topic:mysql stops processing suddenly, no error
Goto Forum:
  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Fri Jul 10 04:49:59 EDT 2009

Total time taken to generate the page: 0.01133 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.