What is the effect of truncating the log_* tables? These tables have grown very large effecting the amount of time to do backups and the amount of memory needed on the DB server (I see a ‘select * from log_visitor’ in the slow queries log that reads 12 million rows in 76 seconds - gotta be a bad thing)
I see a lot of discussion on these tables, but there’s very little good information on them.
Here’s my questions -
If I truncate these tables, what is the effect on the admin reporting capabilities?
Is there a downside of deleting the data every day?
Can I stop Magento from logging in the first place if this data is not being used?
Thanks for the help,