Clearing Magento Log Data

Question

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

User · Accepted Answer

No need to do this yourself  the Magento system has a built-in for cleaning up log information   If you go to   System  gt  Configuration  gt  Advanced  gt  System  gt  Log Cleaning   You can configure your store to automatically clean up these logs

User · Answer

This script is neat and tidy  Set it up as a cron job and relax   http   www crucialwebhost com kb magneto-log-and-cache-maintenance-script

User · Answer

Cleaning the Magento Logs using SSH    login to shell SSH  panel and go with root shell folder   execute the below command inside the shell folder  php -f log php clean   enter this command to view the log data s size     php -f log php status   This method will help you to clean the log data s very easy way

User · Answer

Try   TRUNCATE dataflow batch export  TRUNCATE dataflow batch import  TRUNCATE log customer  TRUNCATE log quote  TRUNCATE log summary  TRUNCATE log summary type  TRUNCATE log url  TRUNCATE log url info  TRUNCATE log visitor  TRUNCATE log visitor info  TRUNCATE log visitor online  TRUNCATE report viewed product index  TRUNCATE report compared product index  TRUNCATE report event  TRUNCATE index event    You can also refer to following tutorial  http   www crucialwebhost com kb article log-cache-maintenance-script   Thanks

User · Answer

TRUNCATE  log url info   TRUNCATE  log visitor info   TRUNCATE  index event   TRUNCATE  log visitor   TRUNCATE  log url   TRUNCATE  report event   TRUNCATE  dataflow batch import   TRUNCATE  dataflow batch export     I just use it

User · Answer

you can disable or set date and time for log setting      System   Configuration   Advanced   System   Log Cleaning

User · Answer

Cleaning Logs via Magento Admin Panel  This method is easier for non technical store owners who don   t want    to mess directly with the Magento store   s database  To activate log cleaning option in Magento just do the following   Log on to your Magento Admin Panel  Go to System    Configuration  On the left under Advanced click on System  Advanced     System   Under system you will see    Log Cleaning    option  Fill the desired    Log Cleaning    option values and click Save   Cleaning Logs via phpMyAdmin  If you are comfortable with mysql and queries then this method is more efficient and quicker than default Magento Log Cleaning tool  This method also allows your to clean whatever you like  you can even clean tables which aren   t included in default Magento   s Log Cleaning tool   Open the database in phpMyAdmin In the right frame  click on the boxes for the following tables  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  Look to the bottom of the page  then click the drop down box that says    with selected    and click empty  Click Yes on confirmation screen  and this will truncate all the selected tables   or you can use script to run  TRUNCATE dataflow batch export  TRUNCATE dataflow batch import  TRUNCATE log customer  TRUNCATE log quote  TRUNCATE log summary  TRUNCATE log summary type  TRUNCATE log url  TRUNCATE log url info  TRUNCATE log visitor  TRUNCATE log visitor info  TRUNCATE log visitor online  TRUNCATE report viewed product index  TRUNCATE report compared product index  TRUNCATE report event  TRUNCATE index event    Keep in mind that we are here to empty  Truncate  selected tables are not drop them  Be very careful when you do this   Performing this regularly will definitely improve your Magento store   s performance and efficiency  You can setup up scripts to do this automatically at regular intervals too using    CRON

User · Answer

SET FOREIGN KEY CHECKS 0  TRUNCATE dataflow batch export  TRUNCATE dataflow batch import  TRUNCATE log customer  TRUNCATE log quote  TRUNCATE log summary  TRUNCATE log summary type  TRUNCATE log url  TRUNCATE log url info  TRUNCATE log visitor  TRUNCATE log visitor info  TRUNCATE log visitor online  TRUNCATE report viewed product index  TRUNCATE report compared product index  TRUNCATE report event  TRUNCATE index event  SET FOREIGN KEY CHECKS 1

User · Answer

SET foreign key checks   0  TRUNCATE dataflow batch export  TRUNCATE dataflow batch import  TRUNCATE log customer  TRUNCATE log quote  TRUNCATE log summary  TRUNCATE log summary type  TRUNCATE log url  TRUNCATE log url info  TRUNCATE log visitor  TRUNCATE log visitor info  TRUNCATE log visitor online  TRUNCATE report viewed product index  TRUNCATE report compared product index  TRUNCATE report event  TRUNCATE index event  SET foreign key checks   1

User · Answer

there are some other tables you can clear out  documented here   https   dx3webs com blog house-keeping-for-your-magento-database  hope this helps Andy

User · Answer

Login to your c-panel goto phpmyadmin  using SQL run below query to clear logs  TRUNCATE dataflow batch export  TRUNCATE dataflow batch import  TRUNCATE log customer  TRUNCATE log quote  TRUNCATE log summary  TRUNCATE log summary type  TRUNCATE log url  TRUNCATE log url info  TRUNCATE log visitor  TRUNCATE log visitor info  TRUNCATE log visitor online  TRUNCATE report viewed product index  TRUNCATE report compared product index  TRUNCATE report event  TRUNCATE index event

User · Answer

After clean the logs using any of the methods described above you can also disable them in your app etc local xml       lt frontend gt   lt events gt    lt frontend gt     lt events gt       lt  -- disable Mage Log -- gt       lt controller action predispatch gt           lt observers gt  lt log gt  lt type gt disabled lt  type gt  lt  log gt  lt  observers gt       lt  controller action predispatch gt       lt controller action postdispatch gt           lt observers gt  lt log gt  lt type gt disabled lt  type gt  lt  log gt  lt  observers gt       lt  controller action postdispatch gt       lt customer login gt         lt observers gt           lt log gt             lt type gt disabled lt  type gt           lt  log gt         lt  observers gt       lt  customer login gt       lt customer logout gt         lt observers gt           lt log gt             lt type gt disabled lt  type gt           lt  log gt         lt  observers gt       lt  customer logout gt       lt sales quote save after gt          lt observers gt             lt log gt                 lt type gt disabled lt  type gt             lt  log gt           lt  observers gt      lt  sales quote save after gt      lt checkout quote destroy gt        lt observers gt          lt log gt            lt type gt disabled lt  type gt          lt  log gt        lt  observers gt      lt  checkout quote destroy gt   lt  events gt   lt  frontend gt   lt  config gt

User · Answer

Further hint  If you don t need those information you can change the Table Type to  Blackhole   instead of InnoDB   This means  nothing will be stored in the future and the insert statements are still working fine   You can also disable the logs by setting all events to disabled   https   gist github com tegansnyder 189f1c3ce897b4ab494d

User · Answer

You may check good article here   http   blog magalter com magento-database-size  It has instructions how to check database size  truncate some tables and how to configure automatic table cleaning

User · Answer

How Magento log cleaning can be done both manually  automatically and other Magento database maintenance  Below the three things are most important of Magento database maintenance and optimization techniques    Log Cleaning Smart use of MySQL updated versions     Buffer pool size settings   To get more information http   blog contus com magento-database-maintenance-and-optimization

[magento] Clearing Magento Log Data

Examples related to magento