[Using Sakai] mysql performance issues

[Sam Ottenhoff]

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

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

Yes, you should add that to the end of your JDBC URL.  Your final URL
should look something like:

url at javax.sql.BaseDataSource
=jdbc:mysql://localhost/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?
>

Yes, shut down all Sakai instances. Shut down MySQL.  Make the changes to
MySQL.  Start MySQL.  Start the Sakai instances.

****
>
> ** **
>
> 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?****
>
>
>
You will no longer see the users present box underneath the tools in the
left column.  But if you are suffering from performance problems, modifying
this value will result in a tremendous performance improvement.

--Sam
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20120117/ef0ad395/attachment.html