GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Size of tmp_table_size & max_heap_table_size stuck on 32M

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

  • Size of tmp_table_size & max_heap_table_size stuck on 32M

    Size of tmp_table_size & max_heap_table_size stuck on 32M

    Code:
    max_heap_table_size=128M;
    tmp_table_size=128M;
    Code:
    mysql> SELECT @@max_heap_table_size;
    +-----------------------+
    | @@max_heap_table_size |
    +-----------------------+
    |              33554432 |
    +-----------------------+
    1 row in set (0.00 sec)
    
    mysql> SELECT @@tmp_table_size;
    +------------------+
    | @@tmp_table_size |
    +------------------+
    |         33554432 |
    +------------------+

  • #2
    Hi,

    After setting it in my.cnf, have you restarted the MySQL server? Can you check with "show global variables like 'max_heap_table_size%';"
    If it's still not worked then I would suggest to check error log after restart, you might be find something which causes this. Also provide mysql/PS version.

    Comment


    • #3
      I had the same problem, after I restarted mysql server everything get back to normal, thanks!


      __________________________________________________ ___________
      Shopping forum

      Comment


      • #4
        I tried restarting all nodes in cluster and even then output is same.
        Code:
        mysql> SHOW GLOBAL VARIABLES LIKE 'tmp_table_size';
        +----------------+----------+
        | Variable_name  | Value    |
        +----------------+----------+
        | tmp_table_size | 33554432 |
        +----------------+----------+
        mysql> show global variables like 'max_heap_table_size%';
        +---------------------+----------+
        | Variable_name       | Value    |
        +---------------------+----------+
        | max_heap_table_size | 33554432 |
        +---------------------+----------+
        I then executed following on all nodes.
        Code:
        SET GLOBAL max_heap_table_size=134217728;
        SET GLOBAL tmp_table_size=134217728;
        SET max_heap_table_size=134217728;
        SET tmp_table_size=134217728;
        After that output was

        Code:
        mysql> SHOW GLOBAL VARIABLES LIKE 'tmp_table_size';
        +----------------+-----------+
        | Variable_name  | Value     |
        +----------------+-----------+
        | tmp_table_size | 134217728 |
        +----------------+-----------+
        Config has following defined
        Code:
        max_heap_table_size=128M
        tmp_table_size=128M
        But after restarting nodes, output is same as before.
        Code:
        mysql> SHOW GLOBAL VARIABLES LIKE 'tmp_table_size';
        +----------------+----------+
        | Variable_name  | Value    |
        +----------------+----------+
        | tmp_table_size | 33554432 |
        +----------------+----------+
        There is no error in log file related with table_size

        Is this a bug or I am doing something wrong?

        Comment

        Working...
        X