GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Can't change key_buffer_size

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Can't change key_buffer_size

    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
    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

    Comment


    • #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

      Comment


      • #4
        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

        Comment

        Working...
        X