Re: Performance comparison of Oracle Vs Aurora MySQL

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