GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

overhead in memory table

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

  • overhead in memory table

    ------------------------
    Courtesy note: I first asked this question over at the Oracle mysql lists, but I did not get any replies.
    -------------------------

    Hello.

    We have a table using the memory engine and we notice in PMA that the overhead continues to grow over time. Normally we'd optimize with such an issue but that is not applicable to memory based tables. So... does this pose a problem for long term use of the table? If so, is there a recommended way to deal with it other than switch to a new table engine?

    We are not experiencing any problems at this time, we are just trying to be proactive about it.

    Thanks.

  • #2
    Can you describe more about what you mean by "the overhead continues to grow" ?

    Even though the engine doesn't support OPTIMIZE, you can still do a no-op ALTER:


    ALTER TABLE $table ENGINE=MEMORY;

    Comment

    Working...
    X