General help

 
 
My Picture
Log file (mdl_log table)
 
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 ?
 
Average of ratings: -
Picture of Jez H
Re: Log file (mdl_log table)
Group Particularly helpful Moodlers
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 big grin
 
Average of ratings: -
My Picture
Re: Log file (mdl_log table)
 
Thank Jez!
 
Average of ratings: -