[Building Sakai] Excessive querying of SAKAI_SITE_PAGE_PROPERTYtable in 2.6?

[Maurer, Christopher Wayne]

Here¹s what I pulled form one of our app serves:
org.sakaiproject.db.BaseDbFlatStorage.SAKAI_SITE_PAGE_PROPERTY: count:8715
hits:88589 misses:2700387 hit%:3

Chris


On 8/27/09 2:11 PM, "Stephen Marquard" <stephen.marquard at uct.ac.za> wrote:

> You can increase the TTL and cache properties in sakai.properties, e.g.
> 
> timeToLive at db.cache.SAKAI_SITE_PAGE_PROPERTY=3600
> timeToIdle at db.cache.SAKAI_SITE_PAGE_PROPERTY=3600
> 
> but looking at our production db, I see hardly anything in that table - only 7
> records with the property "is_home_page".
> 
> Cheers
> Stephen
> 
>>>> >>> Joshua Swink <joshua.swink at gmail.com> 8/27/2009 8:06 PM >>>
> I haven't inspected our database, but Sakai says this:
> 
> org.sakaiproject.db.BaseDbFlatStorage.SAKAI_SITE_PAGE_PROPERTY:
> count:2993 hits:9838 misses:732554 hit%:1
> 
> That seems to be a very low hit rate. Would it be helpful to increase
> the size of the cache? How can I do that?
> 
> Josh
> 
> On Thu, Aug 27, 2009 at 11:01 AM, Stephen
> Marquard<stephen.marquard at uct.ac.za> wrote:
>> > There is a cache for that (along with other property lookups) - c/f
>> SAK-13886
>> >
>> > Have a look in Admin Workspace / Memory / Status and see what it says on
>> one of your app servers, e.g. on a newly started trunk build I see something
>> like:
>> >
>> > org.sakaiproject.db.BaseDbFlatStorage.SAKAI_SITE_PAGE_PROPERTY: count:40
>> hits:3 misses:51 hit%:5
>> >
>> > Perhaps you have this cache disabled in your config.
>> >
>> > Cheers
>> > Stephen
>> >
>>>>> >>>> "Maurer, Christopher Wayne" <chmaurer at iupui.edu> 8/27/2009 7:52 PM
>>>
>> > Looking at some of our database reports, we see that in the time span of an
>> hour the following query gets run over a million times:
>> >
>> > select NAME, VALUE from SAKAI_SITE_PAGE_PROPERTY where ( PAGE_ID = ? )
>> >
>> > Rumor has it that this is probably for the internationalization of
>> page/tool titles, is that right?
>> >
>> > Are other folks running 2.6.x seeing similar things?  Should we be
>> concerned about how often this query is being run?
>> >
>> > Chris
>> >
>> >
>> > _______________________________________________
>> > sakai-dev mailing list
>> > sakai-dev at collab.sakaiproject.org
>> > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>> >
>> > TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org
>> with a subject of "unsubscribe"
>> >
> 
> 
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090827/26321a81/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2141 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090827/26321a81/attachment.bin