[Using Sakai] mysql performance issues

[Anders Nordkvist]

Im sorry to bother again but I should also, like it says in the jira add this line to Sakai.properties?

&useServerPrepStmts=false&cachePrepStmts=true&prepStmtCacheSize=4096&prepStmtCacheSqlLimit=4096<mysql://localhost:3306/sakai?useUnicode=true&characterEncoding=UTF-8&useServerPrepStmts=false&cachePrepStmts=true&prepStmtCacheSize=4096&prepStmtCacheSqlLimit=4096>

And as we have two instances of Sakai I suppose I have to shut down both of them to prevent any inconsistency in the database?

We have display.users.present set to true (as you said, maybe default in 2.7.x). What might be the impact of turning it to false?



Regards
Anders Nordkvist
System administrator
University Of Skövde
Sweden



From: Sam Ottenhoff [mailto:ottenhoff at longsight.com]
Sent: den 17 januari 2012 15:51
To: Anders Nordkvist
Cc: sakai-user at collab.sakaiproject.org
Subject: Re: [Using Sakai] mysql performance issues

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<mailto: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<mailto:fornamn.efternamn at his.se>



From: Sam Ottenhoff [mailto:ottenhoff at longsight.com<mailto:ottenhoff at longsight.com>]
Sent: den 17 januari 2012 15:09
To: Anders Nordkvist
Cc: sakai-user at collab.sakaiproject.org<mailto: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/7fb8019f/attachment-0001.html