[Building Sakai] Mysql table questions

[Charles Hedrick]

I believe statistics uses a separate table,  SST_EVENTS. 

SST_EVENTS grows, but not as quickly as SAKAI_EVENT. Eventually you may have to get rid of old entries in SST_EVENTS, though we haven’t done so.

I assume you realize that the right way to zero out a table is with SQL. Don’t just delete the file.


> On Feb 16, 2015, at 8:46 AM, William Karavites <willkara at oit.rutgers.edu> wrote:
> 
> 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 <mailto:willkara at rutgers.edu>
> http://willkara.com <http://willkara.com/>
> ------------------------------------
> 
> From: "Anders Nordkvist" <anders.nordqvist at his.se <mailto:anders.nordqvist at his.se>>
> To: sakai-dev at collab.sakaiproject.org <mailto: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 <mailto:sakai-dev at collab.sakaiproject.org>
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev <http://collab.sakaiproject.org/mailman/listinfo/sakai-dev>
> 
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org <mailto: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/db7fb266/attachment.html