Re: Performance comparison of Oracle Vs Aurora MySQL

From: Orlando L <oralrnr_at_gmail.com>
Date: Fri, 6 Apr 2018 11:00:23 -0500
Message-ID: <CAL8Ae77Zy4HOZ0Ke4Q3NvD8uqh5bdwpj++_n3fPEvdfLYo33MQ_at_mail.gmail.com>



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.

Sorry Ravi, hope I am not hijacking your thread.

OL.

On Fri, Apr 6, 2018 at 10:44 AM, Powell, Mark <mark.powell2_at_dxc.com> wrote:

>
> Ravi, what is the OS platform. With 160G of memory if UNIX then Large
> Pages should be in use, Huge Pages on Linux. Is this feature configured in
> both the OS and Oracle? If not, configuring it may result in an
> improvement on your current observed performance.
>
>
>
> Mark Powell
> Database Administration
> (313) 592-5148
>
>
> ------------------------------
> *From:* Ravi Teja Bellamkonda <raviteja.bellamkonda7_at_gmail.com>
> *Sent:* Thursday, April 5, 2018 4:34:06 PM
> *To:* Powell, Mark
> *Cc:* oracle-l
> *Subject:* Re: Performance comparison of Oracle Vs Aurora MySQL
>
> Hi Mark,
>
> Sorry that I missed that information.
>
> Aurora RDS uses Inno-DB Engine.
>
> Oracle 11.2.0.4 EE. Current Oracle Database configuration 40 CPU 160 GB.
>
> On Thu, Apr 5, 2018 at 1:20 PM, Powell, Mark <mark.powell2_at_dxc.com> wrote:
>
> Ravi, which database engine do you plan to use?
>
>
> Mark Powell
> Database Administration
> (313) 592-5148
>
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on
> behalf of Ravi Teja Bellamkonda <raviteja.bellamkonda7_at_gmail.com>
> *Sent:* Thursday, April 5, 2018 4:09:16 PM
> *To:* oracle-l
> *Subject:* RE: Performance comparison of Oracle Vs Aurora MySQL
>
> Hi List,
>
> My organization is planning on moving from Oracle to Aurora MySQL
> (capability of having Read Replicas) for the sake of performance and
> scalability which I am completely against as I believe that having the
> capability of scaling will not solve all the problems.
>
> I cannot find any benchmarks comparing Oracle with MySQL. Can someone
> please provide insights on whether this is a even a good move as I am new
> to MySQL and not sure how good it is in terms of performance when compared
> with Oracle. As far as I know Oracle is better performant.
>
> Your time is appreciated.
> --
> Thanks & Regards,
> Ravi Teja
>
>
>
>
> --
> Thanks & Regards,
> Ravi Teja Bellamkonda
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 06 2018 - 18:00:23 CEST

Original text of this message