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