Re: Oracle vs MySql Performance

We run both Oracle and MySQL. I don't know why you expected Oracle to be faster.
It is just the opposite. For pure query, MySQL is much cheaper and thus faster.
It only uses 40% of the CPU cost of Oracle for the same query. Therefore, for the
same box, running the same set of tables with the same queries, MySQL can
handle twice the workload.

The reason is simple. MySQL is just a barebone Oracle. It has no consistent read,
no latch (thus no contention), no recovery ability, no parse, no data integrity and
even no index - everything is IOT, thus the buffer gets per execution for the same
depth is typically 20% cheaper right there.

So, if you don't care about what MySQL does not have and don't care about shutting
down database just to add a datafile, then, by all means use MySQL. Oracle is the
wrong tool for you in this case. You get much better performance with HW that
can handle twice the load. Received on Thu Aug 23 2007 - 12:49:57 CDT