Clean logs files database Magento

How to clean logs files database MagentoClean logs files database Magento

How to clean logs files database magento?

Magento is an e-commerce platform which is most secure e-commerce open-source platform. So it has lot of security implementation into files or database as well. That’s why it always produces of lot of temporary date in files as well as into database. After some time you can see that your website as well as your database is getting heavy on daily basis. So it affects the performance of tasks and processing of store. To keep the store clear and healthy we must schedule a regular cleaning of our magento store.

 

 

Cleaning logs need to be done as per below steps:

  1. Clearing file logs in magento file directory. Following are the list of directories which contains log data. So we need to remove files inside the directories of below to clear logs.
    1. downloader/.cache/
    2. var/cache/
    3. var/locks/
    4. var/log/
    5. var/report/
    6. var/session/
    7. var/tmp/
  2. Clearing magento database logs. We need to truncate below listed tables to clear database logs from magento set of database:
    1. core_cache
    2. core_cache_tag
    3. core_session
    4. dataflow_batch_export
    5. dataflow_batch_import
    6. log_customer
    7. log_quote
    8. log_summary
    9. log_summary_type
    10. log_url
    11. log_url_info
    12. log_visitor
    13. log_visitor_info
    14. log_visitor_online
    15. index_event
    16. index_process_event
    17. report_event
    18. report_viewed_product_index
    19. report_compared_product_index

Nature of open-source Platform

Due to the nature of free and open-source software and the ubiquity of its components, each and every component of the Magento stack is very well tested regarding performance and security and there is an abundance of experienced contractors to do the tailoring respectively the system administration. There is also a constant development going on.

Payment Gateway with Magento

A payment gateway is an e-commerce application service provider service that authorizes credit card payments for e-businesses, online retailers, bricks and clicks, or traditional brick and mortar.

It is the equivalent of a physical point of sale terminal located in most retail outlets. Payment gateways protect credit card details by encrypting sensitive information, such as credit card numbers, to ensure that information is passed securely between the customer and the merchant and also between merchant and the payment processor.

A payment gateway facilitates the transfer of information between a payment portal (such as a website, mobile phone or interactive voice response service) and the Front End Processor or acquiring bank.

Shashi Dhar Kumar Experience in Web/software development including client server and implementation using PHP, XML, MySQL and SQL Server. Experience of working on Apache, Linux projects, Javascript, Ajax, Putty, FTP, Remote Connection, XML parsing, Mod-Rewriting, Payment Gateways and shipping modules, Trouble shooting and Manual Testing.

1 Comment. Leave new

Website Consultant
September 28, 2018 5:17 am

Thanks for this article. It is very nice to see how we can flush the unwanted data record easy.

Reply

Leave a Reply

Your email address will not be published. Required fields are marked *