Re: Performance comparison of Oracle Vs Aurora MySQL

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.

Regards

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


--
http://www.freelists.org/webpage/oracle-l