[Building Sakai] Mysql table questions

[William Karavites]

Anders, 

I'll chime in where I can, 



sakai_event.ibd is what it says, it stores all of the events within Sakai. Someone logs in, stored here, someone submits a quiz, stored here, someone sneezes, stored here. At Rutgers, we usually truncate our event table after every semester; that involves renaming the last semesters to another table name and archiving past ones. Charles Hedrick should be able to fill you in on our process more. We have to do this every semester since our events table can sometimes reach >100GB. 

IMHO, the only other table I'd think about truncating is the sessions table. Someone else may be able to fill you in on other ideas/reasons. 


-Will Karavites 

------------------------------------ 
William Karavites 
Application Programmer 
OIT/OIRT- Rutgers University 
Office: 848-445-8726 
Cell: 732-822-9405 
willkara at rutgers.edu 
http://willkara.com 
------------------------------------ 

----- Original Message -----

From: "Anders Nordkvist" <anders.nordqvist at his.se> 
To: sakai-dev at collab.sakaiproject.org 
Sent: Monday, February 16, 2015 8:40:36 AM 
Subject: [Building Sakai] Mysql table questions 



Hello to you all, 



We in Skövde, Sweden are running Sakai 2.9.x with two nodes and a mysql server in the background. I have here the top 10 tables (in size) of our mysql instance. Can someone tell me what is stored in them? And which of them is it safe for me to truncate? I can’t find much information on the web about whats stored in mysql tables in Sakai. Assignment_submission I think should be intact but I suppose I can clear the Sakai_event table even though it may be used by the statistics tool? I would much appreciate if someone could tell me a little about this tables or point me in the right direction on the web. 







1. sakai_event.ibd 

2. sst_resources.ibd 

3. sst_events.ibd 

4. content_resource.ibd 

5. assignment_submission.ibd 

6. sakai_session.ibd 

7. mfr_unread_status_t.ibd 

8. sam_itemgrading_t.ibd 

9. mfr_message_t.ibd 

10. sakai_realm_rl_fn.ibd 





Regards 

Anders Nordkvist 

System administrator 

University Of Skövde 

Sweden 





_______________________________________________ 
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/20150216/ec283b85/attachment.html