Return to Modify_Course_Table_Lifetime.tex CVS log

Up to [LON-CAPA] / loncom / html / adm / help / tex

- Missing help files for modification of course defaults by Domain Coordinator
  for specific course(s) via: "View or modify a course or community".

\label{Modify_Course_Table_Lifetime}

The default lifetime (since last update) for "temporary" MySQL tables containing student performance data is 172800s (i.e., 2 days). A different default lifetime can be set by course type, which will apply to MySQL tables on the course's homeserver only. The cleanup_database.pl script which is run nightly by cron will check the time elapsed since last update to each temporrary MySQL table, and will drop the table if that time is longer then the lifetime in effect for tables in the course to which the table belongs.

A Domain Coordinator can also choose to override the domain default (on a course-by-course basis) by setting a value for the lifetime (in seconds) for temporary MySQL tables for a selected course.

A reason to set a long lifetime for one or more courses would be if a script is run periodically on a domain's primary library to export student scores by folder those particular LON-CAPA courses.