Not the answer you need?
Register and ask your own question!

Can't change key_buffer_size

HaritaHarita EntrantInactive User Role Participant
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

Comments

  • allworknoplayallworknoplay Contributor Inactive User Role Advisor
    <table border="0" align="center" width="90%" cellpadding="3" cellspacing="1"><tr><td class="SmallText">Harita wrote on Fri, 14 September 2007 02:19</td></tr><tr><td class="quote">
    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


    </td></tr></table>

    Try:

    SET GLOBAL key_buffer_size= 4G
  • HaritaHarita Entrant Inactive User Role Participant
    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
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.