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


Subject
Views
Written By
Posted
3991
January 06, 2015 07:20PM
Re: memory tables swapped out?
1087
January 07, 2015 04:49PM
1040
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.