overhead in memory table

Polyglot Projects LAMP Stack
1

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;