Also relevant is the fact that columar stores were showing up in some MySQL
storage engines (specifically thinking InfiniDB) years before Oracle started
dipping their toes in. IIRC that's what MariaDB's 'ColumnStore' functionality
is based on. https://mariadb.com/products/mariadb-columnstore ;
<https://mariadb.com/products/mariadb-columnstore>
From my experience; oracle has some fantastic features straight out of the box,
but with a little creativity you can often perform very similar functions.
Oracle is analogous to a pre-built toy car. It's built well and always fun to
play with. The MySQL ecosystem is a lego set. It may take a little time, but
with the right bricks in the right place it's equally as satisfying.
On Dec 23, 2016, at 8:23 AM, Kellyn Pot'Vin-Gorman <dbakevlar@xxxxxxxxx>
wrote:
Uhm, MySQL has shard query, sharding technology in MySQL is more advanced
than Oracles to begin with...) and Heap tables, MySQL's older technology for
memory tables has been around a significant amount of time. It's not apple
for apples, but depending on the use case, MySQL has the features.
Kellyn
Sent from myMail for iOS
Friday, December 23, 2016, 12:24 AM -0700 from Mladen Gogala
<gogala.mladen@xxxxxxxxx <mailto:gogala.mladen@xxxxxxxxx>>:
On 12/22/2016 02:58 AM, oracle@xxxxxxxxxxx
<x-msg://6/compose?To=oracle@xxxxxxxxxxx> wrote:
I've worked with both.
I can make mysql outperform any database, including Oracle, on any
dataset under 2TB.
Now, that is a brave claim, if I ever saw one! How would you defeat
parallel query or in-memory option?
--
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com ;<http://mgogala.freehostia.com/>
--
//www.freelists.org/webpage/oracle-l ;
<//www.freelists.org/webpage/oracle-l>