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?



>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.

Buy what you want when you want it on Sympatico / MSN Shopping  

View raw message