. /** * Legacy log reader. * * @package logstore_legacy * @copyright 2014 Petr Skoda {@link http://skodak.org} * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ namespace logstore_legacy\task; defined('MOODLE_INTERNAL') || die(); class cleanup_task extends \core\task\scheduled_task { /** * Get a descriptive name for this task (shown to admins). * * @return string */ public function get_name() { return get_string('taskcleanup', 'logstore_legacy'); } /** * Do the job. * Throw exceptions on errors (the job will be retried). */ public function execute() { global $CFG, $DB; if (empty($CFG->loglifetime)) { return; } $loglifetime = time() - ($CFG->loglifetime * 3600 * 24); // Value in days. $lifetimep = array($loglifetime); $start = time(); while ($min = $DB->get_field_select("log", "MIN(time)", "time < ?", $lifetimep)) { // Break this down into chunks to avoid transaction for too long and generally thrashing database. // Experiments suggest deleting one day takes up to a few seconds; probably a reasonable chunk size usually. // If the cleanup has just been enabled, it might take e.g a month to clean the years of logs. $params = array(min($min + 3600 * 24, $loglifetime)); $DB->delete_records_select("log", "time < ?", $params); if (time() > $start + 300) { // Do not churn on log deletion for too long each run. break; } } mtrace(" Deleted old legacy log records"); } }