I hope this is the right forum to get the answer. I am using moodle 1.8.7. My mdl_log table is around 100 Mb. (see it via phpMyadmin). Is the performance would be much better if I empty this table? and is it safe (won't be any trouble on my LMS ) to empty mdl_log table ?
mdl_log is just the Moodle log table, it records when users logged on, and some of their actions.
The Moodle log reporting and "statistics" are drawn from this table, though, it may be that statistics get copied over to another table (may still work after original logs are deleted). If you are not using statistics then this does not matter... affected reports will be:
admin > reports > logs
admin > reports > statistics
Instead of manually deleting the logs, go into:
Admin > Server > Cleanup
you can set the logs to be automatically deleted after 35 days or more... that way your table will be maintained safely and automagically
The Moodle log reporting and "statistics" are drawn from this table, though, it may be that statistics get copied over to another table (may still work after original logs are deleted). If you are not using statistics then this does not matter... affected reports will be:
admin > reports > logs
admin > reports > statistics
Instead of manually deleting the logs, go into:
Admin > Server > Cleanup
you can set the logs to be automatically deleted after 35 days or more... that way your table will be maintained safely and automagically
Thank Jez!