Maintenance

Database Maintenance

-- Optimize tables
OPTIMIZE TABLE mdl_user;
OPTIMIZE TABLE mdl_course;
-- Clean logs
DELETE FROM mdl_log 
WHERE time < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 90 DAY));

File System Cleanup

// Clean cache
purge_all_caches();
// Remove temp files
remove_dir($CFG->dataroot . '/temp');
// Cleanup backups
$backups = get_config('backup', 'backup_auto_keep');