[Building Sakai] Mysql high load Hibernate

[John Bush]

Can you provide more information, what does your cluster look like, how many
users are you running concurrently on each tomcat?  What tools are used
heavily, do you have particular slow queries that are causing you an issue?
 Its quite possible a few additional indices might go a long way, but would
need to know a little more first.

On Mon, Feb 28, 2011 at 3:04 AM, Ciellie Jansen van Vuuren <
ciellie.jansenvanvuuren at nwu.ac.za> wrote:

> Hallo
>
> We're running sakai 2.6 in production. The number of simultaneous users
> almost
> double from January causing our db to crash. We are caching queries and try
> to
> minimize slow queries, but still it crashes. Is it possible to let
> hibernate
> split reads and writes to different database servers. We are using Mysql.
>
> If it is what can we do to implement something like this?
>
> Thank you
> Ciellie
>
> _______________________________________________
> 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"
>



-- 
John Bush
602-490-0470
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110228/548fd9d1/attachment.html