Hopefully this is the correct forum area. I have had a Moodle server up and running since Sep 2010 with no issues. That's the good, I have had to do nothing to it but let it run. Over the past few weeks though is has had some slowness creeping in. I'm going to guess the MySQL database may need some sort of re-indexing, or what ever passes for that in MySQL.
Can someone maybe provide some best maintenace actions for the database that should be performed on a routine basis? My searching lead me to a lot of configuation settings which I have applied in the past, but I did not see any suggestions in my searches for routine maintenance. Many thanks.
MySQL - 5.1.49
Apache - 2.2.11
PHP - 5.2.92
Win 2003 server