MySQL Forums
Forum List  »  Memory Storage Engine

Re: memory tables swapped out?
Posted by: Rick James
Date: January 07, 2015 04:49PM

I don't know the specific answer. Instead, I will argue that your goal is faulty.

* If mysql swaps for any reason, it will become terribly slow.
* A MEMORY table that is "big" should not be MEMORY; use some other ENGINE.
* Allowing (non-swapped) room for MEMORY table(s) steals RAM from various caches, thereby slowing other things down.

Bottom line:
* Because of tradeoffs, MEMORY is not necessarily the best answer for performance.
* Tune my.cnf so swapping never happens.

Options: ReplyQuote

Written By
January 06, 2015 07:20PM
Re: memory tables swapped out?
January 07, 2015 04:49PM
January 08, 2015 03:18AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.