The importance of properly maintainng your Magento database can not be understated.  Magento has several log tables that will continuously grow over time grinding your site to a halt and dramaticically effecting the speed and performance of your Magento installation.  Properly maintaining your Magento database is crucial to achieving the highest performance available.

We've created a widely used script for Magento log and Cache Management to help automate the process of maintaining these log tables and to conveniently clear this data out on occassion automaticaly.

Here's a link to the Magento Log and Cache Management Script and a full description of how to implements it's use and set it up in cron - set it and forget it and watch your magento installation fly!