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 previous 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
[Message index]

Read Message
Read Message
Read Message
Read Message
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:55:43 EDT 2009

Total time taken to generate the page: 0.02060 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.