I run with a dedicated Debian server and I wish like to know what is the best method to clear my logs in my database?
Currently, I use the Magento cron every 5 minutes. It's work fine and when I check on my database in my cron_schedule table, the cron works every 5 minutes.
*/5 * * * * /bin/sh /path/to/magento/cron.sh
Now, I wish clear the following tables every five minutes :
dataflow_batch_export dataflow_batch_import log_customer log_quote log_summary log_summary_type log_url log_url_info log_visitor log_visitor_info log_visitor_online report_viewed_product_index report_compared_product_index report_event
What is the best method for realize that?