[Using Sakai] Question regarding mysql

[Arlow, Magdaleen]

This message (and attachments) is subject to restrictions and a disclaimer. Please refer to http://www.unisa.ac.za/disclaimer for full details.
________________________________

Dear Anders

We do the same as UCT, but to two history tables on the productions DB. We archive data older than 2 years from these history tables. We also summarize data into an additional  in house table for regular stats we display  to staff and students.

Kind regards

Magdaleen Arlow

Deputy-Director : Academic Systems Development
ICT Department
[cid:image001.png at 01CCF62D.06A7C040]

' +27 (0) 12 429 3102
Cell + 27 (0) 82 783 9163

Email : arlowm at unisa.ac.za



From: sakai-user-bounces at collab.sakaiproject.org [mailto:sakai-user-bounces at collab.sakaiproject.org] On Behalf Of David Horwitz
Sent: 28 February 2012 12:03
To: sakai-user at collab.sakaiproject.org
Subject: Re: [Using Sakai] Question regarding mysql

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<mailto: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<mailto: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/cab07054/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 2078 bytes
Desc: image001.png
Url : http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20120228/cab07054/attachment.png