MySQL MEMORY/HEAP engine ?

Posted by cquest on January 10, 2007 at 2:38pm

Has anyone tried to take advantage of the MEMORY/HEAP engine in MySQL ?

I thought about using it to avoir cache queries, combined to some hashing.

Worth trying something ?

Best,
Christian

Comments

Posted by Gabriel Radic on April 5, 2011 at 3:29pm

Did you try it?
I'm about to give it a try myself.

Posted by Gabriel Radic on April 5, 2011 at 3:33pm

That was a quick test...

> An error occurred when trying to change the table type to 'MEMORY'.
> MySQL said: The used table type doesn't support BLOB/TEXT columns

Too bad.