2 ms·
> MySQL VSZ ends and peaks at 6 gB, RSS ends and peaks at 2GB. For MemSQL, the RSS and VSZ end and peak at 18 gB and 19 gB, respectively. So the RSS of MemSQL
by continuations 14y ago
> MySQL VSZ ends and peaks at 6 gB, RSS ends and peaks at 2GB. For MemSQL, the RSS and VSZ end and peak at 18 gB and 19 gB, respectively.
So the RSS of MemSQL is almost 10x larger than that of MySQL's.
Is that going to be generally the case - that MemSQL will consume about 10X more memory than MySQL for the same dataset?
What causes this difference? Is it because skiplist requires more memory than B-tree?
- ankrgyl 14y agoIt has more to do with how much data is stored. MemSQL stores more than 30 times as many rows as MySQL by the end of the experiment.