Comparative Mysql DragonFlyBsd v1.0 / FreeBSD v4.10
David Rhodus
drhodus at machdep.com
Sat Jul 17 19:57:25 PDT 2004
Its hard to bring the numbers you posted into a true real world load
situation.
For a real world example, take one typical mysql processing node at the
office running DragonFly. The average QPS(queries processed per) during
non-peak time is ~24QPS. Durning peak processing time we see an average
of around ~60QPS. Even with the non peak time, no FreeBSD box has ever
been able to maintain the load average the same exact hardware running
DragonFly is able to maintain. As for the dataset size, most of the data
is not small enough to be maintained inside the query cache for very
long as a typical table size is around 121 columns with an average of
1465206 rows adding up to an average table size of 3.6Gig.
-DR
More information about the Kernel
mailing list