Re: Performance comparison of Oracle Vs Aurora MySQL

From: Mladen Gogala <>
Date: Fri, 6 Apr 2018 19:52:34 -0400
Message-ID: <>

Orlando, the huge pages are used for two reasons:

  • They are not swappable and cannot be stolen so they mostly behave like real memory, not like virtual memory.
  • Page tables are much smaller if a page is 2M instead of 4K. Page tables are 512 times smaller. Page tables are a virtual memory system overhead that doesn't anything useful for your end users and that you must allocate memory for. The less the better.

I use huge pages even with 8GB virtual machines and have no problems.


On 04/06/2018 12:00 PM, Orlando L wrote:
> Mark,
> Is there any amount of memory in GB above which huge pages are
> recommended on Linux? Is that for one DB or for multiple DBs. Reason I
> am asking is whether we should enable Huge pages in our future env on
> a server with 192Gb. There is going to be 3 or 4 DBs sitting there
> though, 2 DBs with real low foot print and one using majority of the
> memory.

Mladen Gogala
Database Consultant
Tel: (347) 321-1217

Received on Sat Apr 07 2018 - 01:52:34 CEST

Original text of this message