db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Raymond Raymond" <raymond_de...@hotmail.com>
Subject Re: How to set the percentage of dirty pages in cache pages?
Date Mon, 12 Feb 2007 02:47:14 GMT
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


Mime
View raw message