Re: Performance comparison of Oracle Vs Aurora MySQL

From: Powell, Mark <mark.powell2_at_dxc.com>
Date: Fri, 6 Apr 2018 15:44:43 +0000
Message-ID: <AT5PR8401MB0626F1E58076033C86B5A04BCCBA0_at_AT5PR8401MB0626.NAMPRD84.PROD.OUTLOOK.COM>



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<mailto: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<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> on behalf of Ravi Teja Bellamkonda <raviteja.bellamkonda7_at_gmail.com<mailto: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 - 17:44:43 CEST

Original text of this message