Re: Performance comparison of Oracle Vs Aurora MySQL

From: Ravi Teja Bellamkonda <raviteja.bellamkonda7_at_gmail.com>
Date: Fri, 6 Apr 2018 10:04:05 -0700
Message-ID: <CANRhLpA_PckhMDg99dr6t4ZfAZWxf6Mhyg7=rbxG545Sh00idg_at_mail.gmail.com>



As long as knowledge is being shared, Hijacking is very welcome. :)

On Fri, Apr 6, 2018 at 9:00 AM, Orlando L <oralrnr_at_gmail.com> 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.
>
> 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
>>
>
>

-- 
Thanks & Regards,
Ravi Teja Bellamkonda

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 06 2018 - 19:04:05 CEST

Original text of this message