[Using Sakai] mysql performance issues

[Sam Ottenhoff]

> I have looked at the Sakai admin mysql section and found a few tips. One
> thing to test with is the query caching.
>

Yes, enable query caching in MySQL right away!

query_cache_size = 64M



> ****
>
> Do you guys have any more tips of how to increase the performance? Do you
> know of any free profiling tool to use?
>


Yes, disable user presence in sakai.properties:

# enable presence display in the portal (true or false)
display.users.present=false




> ****
>
> My last question is: How do I know that SAKAI_PRESENCE table is in memory?
> ****
>
> ** **
>
>
>
mysql> show create table SAKAI_PRESENCE;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20120117/f3f48b96/attachment.html