[Building Sakai] Read Committed

[Sam Ottenhoff]

I believe this is the recommended value for MySQL:

  defaultTransactionIsolationString at javax.sql.BaseDataSource
=TRANSACTION_READ_COMMITTED

What kind of performance issues are you running into?  What version of
MySQL?  Any specific slow queries or operations?


On Fri, Aug 22, 2014 at 4:51 PM, Ethan Kromhout <ethan_kromhout at unc.edu>
wrote:

> We have been dealing with some performance issues in our MySQL instance
> for Sakai, and have been reading about the possibility of setting our
> isolation level to READ COMMITTED. A comment I found in a Jira noted
> that your binlog-format needed to be row for replication, but I didn't
> find much other comment about this change.
>
> I was hoping to hear from others as to the safety and benefits of using
> READ COMMITTED for Sakai.
>
> Thanks,
>
> Ethan
>
> _______________________________________________
> 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/20140822/087cd2da/attachment.html