Clearing Magento Log Data

Question

Hi,

I have a question regarding clearing of the log data in Magento.

I have more than 2.3GB of data in Magento 1.4.1, and now I want to optimize the database, because it's too slow due to the size of the data. I checked the log info (URL,Visitors) and it shows more than 1.9 GB. If I directly clear those records, will it affect any functionality in the site? How can I clear the log details? By clearing those data will I have or lose any data on my site?

Answer 1

No need to do this yourself, the Magneto system has a built-in for cleaning up log information. If you go to

System > Configuration > Advanced > System > Log Cleaning

You can configure your store to automatically clean up these logs.

Answer 2

Hi there,

there are some other tables you can clear out: documented here : http://dx3webs.com/front/2010/08/house-keeping-for-your-magento-database/

hope this helps Andy