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