Magento Performance Boost: Enable Log Cleaning

Share
Posted on December 7th, 2012 | Posted by admin

Magento stores a lot of logging information in the database tables prefixed with log_e.g. log_visitor_info, log_url_info, etc. As with Magento’s session files, if not handled properly, these tables will grow out of control and hinder performance.

Magento has automated log cleaning functionality built in, but it is not enabled by default. Here’s how to turn it on.

  1. Firstly you need make sure Magento’s cron system is running.
    If you are unsure about this, see this article on setting up cron (scheduled tasks).
  2. Once cron is enabled and running, simply enable log cleaning via the admin:
    System > Configuration > Advanced > System > Log Cleaning

As per the screenshot below, I like to save 1 days logs, and perform the cleaning at 4:00am each morning.

Magento Performance Boost: Cleanup Old Session Files

Share
Posted on October 28th, 2012 | Posted by admin

If left unchecked, Magento session files can grow out of control and have a negative impact on your sites performance (aswell as taking up storage space). This article explains how to make sure old session files are removed automatically.

Magento stores it’s session files in var/session and I’ve seen too many Magento installations where the size of this directory has grown into the gigabytes. A quick browse of this directory should tell you whether you have a problem or not.

PHP has it’s own ‘garbage collection’ process for deleting old session files, but it’s disabled in Debian “due to the strict permissions on /var/lib/php5″
So, if you are using Debian then you’ll need to setup a simple cron script to do this garbage collection for you.

Magento performance: Optimization of Magento configurable products

Share
Posted on October 24th, 2012 | Posted by admin

If you use configurable products in your Magento store and your super attribute have a lot of options (thousands of options), you can experience the following performance issues:

  • Loading time of a configurable product page is more than other pages (especially when Magento cache is disabled)
  • When you add a configurable product to store cart, cart page become slow
  • When configurable product is added to store cart, all store pages become slow

In this article I will show how to debug such issues and how to fix the speed issue I described above.

Note: Pages load time depends on your server configuration and number of attribute options in your Magento store.

Product view loading time optimization

I started investigation of this issue on product view page. I found “TTT4″ point in the Magento profiler, which take a lot of loading time (in our case 10-15 seconds).
This is a call of _loadPrices() method in the Mage_Catalog_Model_Resource_Product_Type_Configurable_Attribute_Collection class.

How To Clean Up Your Magento Store’s Database Logs For Faster Performance

Share
Posted on February 2nd, 2012 | Posted by admin

Magik database backup extension – which will automatically backup your database

  • Use phpmyadmin and take the entire dump on your system
  • Use Magento’s built in profilers to export entire database.
  • How To Clean Up Your <a href=Magento Store’s Database Logs For Faster Performance ” width=”300″ height=”133″ />

    Improving Your Magento Store’s Performance – Boost Magento Speed

    Share
    Posted on January 26th, 2012 | Posted by admin

    Are you amongst those who have spent heavily on your Magento store still you are not impressed with your Magento store’s performance? In my last post Is Your Magento Store Optimized? Give Us A Call To Find Out i have written few common factors which affects your store’s overall performance. In continuity in this article i am going to give you few easy tips to enhance your Magento’s performance a little bit more. Keep in mind that Magento is a heavy package and it requires resources but based on your current hosting setup you can still improve the performance a little more.

    Page 1 of 212»