[Using Sakai] Question regarding mysql

David Horwitz david.horwitz at uct.ac.za
Tue Feb 28 02:03:15 PST 2012


Hi Anders,

We have a script that moves all session and event data to another 
database each night. So we only ever 24 hours data on the production DB.

The script we use is here:
http://source.cet.uct.ac.za/svn/sakai/scripts/trunk/archive_stats.pl

Regards

David

On 02/28/2012 11:52 AM, Anders Nordkvist wrote:
>
> HI all,
>
> We have had some performance issues regarding our mysql server for a 
> while now.
>
> My question to you is how large are you allowing the SAKAI_EVENT table 
> to grow? Ours is 13 000000 rows.
>
> Regards
>
> Anders Nordkvist
>
> System administrator
>
> University Of Skövde
>
> Sweden
>
>
> _______________________________________________
> sakai-user mailing list
> sakai-user at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>
> TO UNSUBSCRIBE: send email to sakai-user-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20120228/88849724/attachment.html 


More information about the sakai-user mailing list