Magento – How to clear the cache and log table in magento?

Hi Forks, there is multiple methods to clear the cache and logs from database. firstly we are using SSH terminal for best practice.
You’re best of doing this from the command line using a SSH terminal or a cronjob.

# rm -Rf /home/domain.com/www/var/cache/*
# rm -Rf /home/domain.com/www/var/log/*

This will be more reliable than using PHP and also you can call the following from php.

Mage::app()->cleanCache();

For clean cache, following methods will help you to make a shell script:

// Clean js and css
Mage::getModel('core/design_package')->cleanMergedJsCss();
Mage::dispatchEvent('clean_media_cache_after');

// product image
Mage::getModel('catalog/product_image')->clearCache();
Mage::dispatchEvent('clean_catalog_images_cache_after');

// Get cache types
Mage::app()->getCacheInstance()->getTypes()

// Clean specific tags
Mage::app()->cleanCache($tags);

// dispatch event if you flush all cache tags
Mage::app()->cleanCache($alltags);
Mage::dispatchEvent('adminhtml_cache_flush_system');

Now, We are using php file for clear the cache and log file so now we creating clean.php and paste below code and run this code using below instruction.

INSTRUCTION :
1. Save the file to the Magento root directory and Run the following URL For Log clearing.
    http://www.domain.com/cleanup.php?clean=log

2. Run the following URL for Cache clearing
    http://www.domain.com/cleanup.php?clean=var

<?php
switch($_GET['clean']) {
    case 'log':
        clean_log_tables();
    break;
    case 'var':
        clean_var_directory();
    break;
}

function clean_log_tables() {
    $xml = simplexml_load_file('./app/etc/local.xml', NULL, LIBXML_NOCDATA);

    if(is_object($xml)) {
        $db['host'] = $xml->global->resources->default_setup->connection->host;
        $db['name'] = $xml->global->resources->default_setup->connection->dbname;
        $db['user'] = $xml->global->resources->default_setup->connection->username;
        $db['pass'] = $xml->global->resources->default_setup->connection->password;
        $db['pref'] = $xml->global->resources->db->table_prefix;

        $tables = array(
            'adminnotification_inbox',
            'aw_core_logger',
            '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',
            'index_event',
            'report_event',
            'report_viewed_product_index',
            'report_compared_product_index',
            'catalog_compare_item',
            'catalogindex_aggregation',
            'catalogindex_aggregation_tag',
            'catalogindex_aggregation_to_tag'
        );

        mysql_connect($db['host'], $db['user'], $db['pass']) or die(mysql_error());
        mysql_select_db($db['name']) or die(mysql_error());

        foreach($tables as $table) {
            @mysql_query('TRUNCATE `'.$db['pref'].$table.'`');
        }
    } else {
        exit('Unable to load local.xml file');
    }
}

function clean_var_directory() {
    $dirs = array(
        'downloader/.cache/',
        'downloader/pearlib/cache/*',
        'downloader/pearlib/download/*',
        'var/cache/',
        'var/locks/',
        'var/log/',
        'var/report/',
        'var/session/',
        'var/tmp/'
    );

    foreach($dirs as $dir) {
        exec('rm -rf '.$dir);
    }
}