Re: Is Oracle faster/easier than mySQL
Date: Tue, 10 Mar 2009 16:42:31 +0000 (UTC)
On Mon, 09 Mar 2009 17:33:55 -0700, jgar the jorrible wrote:
> Oracle's big strengths are scalability and concurrency issues.
Also, Oracle is well instrumented. When you have a performance problem in Oracle, you have a method at your disposal, generally known as "method R", and a collection of instruments (tracing, tkprof, event tables, PL/SQL profiler) to resolve it. There is nothing like that in the open source databases like MySQL or PostgreSQL. Also, when the problem is found, with OSS databases one has to fix the application code. That is the process that may take time. Oracle has things like the DBMS_ADVANCED_REWRITE, a ground breaking "intercept" which makes it possible to plug in a replacement for a bad SQL without rewriting the code and thus the ability to react quickly in a critical situation. So, for the OSS databases, the following applies:
- No tracing. MySQL has the ability to dump the slow queries, but that doesn't cut it.
- No event interface. You can't ask MySQL "what is my session waiting for".
- No fiddling with the statistics.
- No detailed execution statistics. You can't monitor "user commits" for a session.
- No DBMS_ADVANCED_REWRITE <TAKE COVER> Also, in OSS databases, one cannot increase the block size and thus increase the performance tenfold. </TAKE COVER>