[Using Sakai] mysql performance issues

[Sam Ottenhoff]

If you have lots of RAM, use 128M or 256M. 64M should be plenty to notice
an immediate difference.

--Sam

On Tue, Jan 17, 2012 at 9:47 AM, Anders Nordkvist
<anders.nordqvist at his.se>wrote:

>  Thank you all for your replies!****
>
> ** **
>
> Why do you think I should use 64M instead of 128 Sam?****
>
> ** **
>
> ** **
>
> mvh****
>
> Anders Nordqvist****
>
> Systemadministratör, Nätbaserad Utbildning****
>
> ________________________****
>
> IT- och campusavdelningen****
>
> Högskolan i Skövde****
>
> Box 408****
>
> 541 28 Skövde****
>
> tfn 0500-44 81 78****
>
> e-post anders.nordqvist at his.se <fornamn.efternamn at his.se>****
>
> ** **
>
> ** **
>
> ** **
>
> *From:* Sam Ottenhoff [mailto:ottenhoff at longsight.com]
> *Sent:* den 17 januari 2012 15:09
> *To:* Anders Nordkvist
> *Cc:* sakai-user at collab.sakaiproject.org
> *Subject:* Re: [Using Sakai] mysql performance issues****
>
> ** **
>
> ** **
>
>  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/a71f5bd6/attachment.html