Purchasing the correct hardware: dual-core intel? Big cache?
cswiger at mac.com
Tue Apr 25 14:46:39 UTC 2006
Bill Moran wrote:
> On Tue, 25 Apr 2006 09:48:21 -0400
> Chuck Swiger <cswiger at mac.com> wrote:
[ ...long explanation snipped for brevity... :-) ]
> Thanks, Chuck.
> What I'm looking for is a way to measure this on the current machines
> we're using so I can make a prediction as to whether larger cache
> sizes will improve performance. What I'm looking for is some sort of
> counter or the like that I can use to tell what my current L2 cache
> hit ratio _is_, so I can intelligently speculate as to whether another
> 6M of cache is worth the outrageous price.
It's possible to write code which tests cache size and latency empirically, but
I'm not sure how to obtain the ratio you're looking for directly for your
Previous experience suggests that large CPU cache helps heavily multithreaded or
parallel multiprocess tasks by a lot, but does little to help something like a
big database because the amount of data you have to traverse is much larger than
will fit into any L2 cache, no matter how big. On the other hand, more L2 cache
can provide more significant benefit to a well-tuned database if the indexes or
particular frequently-used subqueries fit better into the larger cache...
More information about the freebsd-questions