I used TPC-B workload in my tests. Do you have any idea, how can
I tune up the percentage of dirty page?
Thanks.
Raymond
Raymond Raymond wrote:
I am doing some tests on Derby checkpoint. You know, with the
same number of cache pages, if the percentage of dirty pages is
higher, deby will dump more pages during checkpoint. I want to
see what impact it will give to Derby's performance when I tune
the percentage of dirty pages higher. As I observed, the default
percentage is like 20%. But I don't know how to set it as the
number I want.
My guess is that the "default percentage" you are seeing is the result of
the workload you are using. I don't believe Derby has any concept of an
optimal or default dirty page percentage.
Dan.
_________________________________________________________________
Buy what you want when you want it on Sympatico / MSN Shopping
http://shopping.sympatico.msn.ca/content/shp/?ctId=2,ptnrid=176,ptnrdata=081805
