SPAM-LOW: Re:Semi-OT: Database for "average" users

[Christopher Browne]

On 5/3/05, Ilya Palagin <tux-4CS0UopE6WdBDgjK7y7TUQ at public.gmane.org> wrote:
> Except for performance?

What are you talking about?  Rumours of the past?

The only cases where people find MySQL to be consistently faster than
other systems is when they run single-user, single-threaded,
single-query benchmarks that were tuned specifically for it and where
they simultaneously didn't bother doing a competent tuning job on the
competing database systems.

> > And don't even get me started about MySQL's locking issues.

There would be a good case in point.

What is most fascinating is the absence of published benchmarks for
versions of MySQL more recent than version 3.23, and for any storage
engine other than MyISAM.

Certainly they wouldn't want reports on attempts to use MyISAM-based
systems for any sort of concurrent update work, because that storage
scheme requires granting complete table locks any a query modifies
data, which has a pretty obvious effect, namely that it can't scale
worth anything.

And it would appear from the absence of benchmarks that perhaps InnoDB
doesn't lead to performance that anyone wants written about.
-- 
http://www3.sympatico.ca/cbbrowne/linux.html
"The true  measure of a  man is how he treats  someone who can  do him
absolutely no good." -- Samuel Johnson, lexicographer (1709-1784)
--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml