I have a part in my database that's over 800MB and it slows down my moodle site. it's "mdl_statistics_monthly". How can I delete these statistics and what is the best configuration to avoid this. (my knowledge about mysql is nihil).
If you are 100% sure you don't need those stats, simply disable stats processing in the variables configuration page, and delete all the records from that table (using a SQL sentence).