Cleanup
An administrator can limit the size of certain tables in the database by setting appropriate options in Administration > Site administration > Server > Cleanup.
Delete unconfirmed users after
If you're using Email-based self-registration users must confirm their account (complete the email registration process) within a certain time-frame. Once the time set here has passed, any account that hasn't been confirmed will be deleted. The default is 7 days.
Delete incomplete users after
Once users have confirmed their account, they must complete their profile within the time interval set here.
A complete profile is one where the following fields have been filled in (are not empty):
- First name
- Last name
- Email address
Just as a reference, given that the firstname, lastname and email are required fields of the Upload users module, any account created this way is automatically a complete account.
Keep logs for
Moodle keeps extensive logs of user activity. Eventually, however, the logs will become so large that they begin to clog your server. Limiting the length of time logs are kept for will reduce database table size. Generally, a year is enough time to keep logs for.
Note: In Moodle 2.7 onwards, this setting has been moved to the legacy log store settings in Site administration > Plugins > Logging > Manage log stores.
Disable grade history
History tracking of changes in grades-related tables may be disabled by checking the disablegradehistory box.
Grade history lifetime
The length of time that the history of changes in grade-related tables is kept may be set (from 30 days to never).
Note: For users who have upgraded to Moodle 2 from 1.9, the setting 'Unsubscribe users from courses after' in Cleanup has been replaced by 'Unenrol inactive after' in Self enrolment. i.e. the setting now applies ONLY to users who self-enrolled.
See also
- Using Moodle How do I prune mdl_log table? forum discussion