On Mar 13, 2007, at 22:45, Kris Kennaway wrote:
I used sql-bench
/usr/ports/databases/mysql50-server/work/mysql-5.0.33/sql-bench/
(at this time)
the default Makefile of port have "--without-bench" options so u
need
to make manually
Hmm. This seems to be a single-user test, so while it's presumably
testing some relevant basic ingredients of database performance it's
probably not a realistic measure of server performance. i.e. if you
really only have a maximum of one client accessing your database then
your 4-core system is being more than 75% wasted :)
Sorry, couldn't resist...
This being mysql, the number of processors isn't going to matter
much, no matter how many connections you have. Mysql doesn't scale
very well to multiple cpu's.
I've had my doubts about this "benchmark" from the beginning of this
thread, I don't see the point of benchmarks using mysql - especially
if it's not even clear whether myIsam or Innodb was used. If this
benchmark means anything, I'm sure there are benchmarks that better
suit the purpose (with the exception of benchmarking mysql
performance for a single connection). What are we actually trying to
benchmark here?
In my experience mysql as a database accepts invalid data, doesn't
comply to the SQL standards much and isn't very fast at real-life
database queries - among other things.
It doesn't compare[1] to a tuned PostgreSQL database, which I think
is a considerably more interesting benchmark. And of course that
would include multiple simultaneous connections.
Not to say that PostgreSQL is the ultimate benchmark instead of
mysql, just a better one. Of course they both have their uses, but
IMO mysql is loosing terrain fast.
[1] I really mean it doesn't compare. PostgreSQL provides more (and
IMHO better) features, and can be faster under the right
circumstances (usually complex queries or concurrent writes). It also
scales almost linearly to the number of cpu's, provided there are
enough simultaneous connections.
--
Alban Hertroys
Priest to alien: "We want to know, is there a higher
being?".
Alien: "Well, actually that's why we're here,
we're sheer out of virgins".
!DSPAM:74,45f741509413780612645!
_______________________________________________
freebsd-stable@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-stable
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
