Important Magento maintenance, now for IIS too: optimize the speed and performance of your Magento ecommerce webshop by carrying out important maintenance. Remove old MySQL database log files and Magento cache data on a regular basis.
Magento eCommerce Maintenance: Improve Webshop Speed & Performance
Clear Magento cache and MySQL log tables, perform regular Magento maintenance on IIS web servers for better performance. Magento Community Edition is a very popular ecommerce and webshop solution. And very bloated as we all know. Anywhere you run your Magento webshop, it's important to perform maintenance. Carrying out maintenance on a regular basis optimizes Magento performance.
Two of such important Magento maintenance tasks are clearing out and emptying the MySQL database cache and log tables (such as log_visitor, log_url), and Magento's file system cache directories in /var. Most scripts and solutions out there are for Linux- and Unix webservers only. I decided to modify a Magento maintenance script, to run on Windows Server and IIS too.
To optimize MySQL databases, it utilizes my MySQLi multi_query statement to optimize all MySQL tables in one statement.
Ask your hosting provider to schedule this script as a Windows Server scheduled task, for instance once a day, and you'll notice a speed improvement of your Magento webshop. Next, add support for WinCache and your Magento webshop is very, very fast. Even on IIS!
Clear magento cache and log tables
Disclamer: this script is provided "AS-IS" and should not be put into production without testing! Save the following PHP code as maintenance.php and upload it to your web-root.
<?php/** * maintenance.php: * IIS Magento Maintenance Script * * Run this script to optimize your Magento ecommerce webshop's MySQL * database, by performing regular maintenance. For instance, * schedule a Windows scheduled task to run * www.example.com/maintenance.php?clean=log and * www.example.com/maintenance.php?clean=var on a daily basis * * Other versions exist @ * http://www.crucialwebhost.com/kb/magneto-log-and-cache-maintenance-script/ * http://www.magentocommerce.com/wiki/groups/227/maintenance_script * * Modified 2014-07-25, Jan Reilink * Converted ext/mysql statements to mysqli * Added mysqli->multi_query to optimize all tables in one query * Modified 2014-07-01, Jan Reilink * Fix for Windows IIS web servers, on which exec('rm -rf '.$dir) * doesn't function * */if(isset($_GET['clean'])) { switch($_GET['clean']) { case 'log': // perform maintenance on MySQL database log tables clean_log_tables(); break; case 'var': // Clears Magento cache in var directory clean_var_directory(); break; default: default_action(); break; }}else { default_action();}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; // the following MySQL database tables will be trucated (cleared) // during maintenance $tables = array( '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' ); $mysqli = new mysqli($db['host'], $db['user'], $db['pass'], $db['name']); if($mysqli->connect_error) { die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error); } foreach($tables as $table) { @mysqli->query('TRUNCATE `'.$db['pref'].$table.'`'); } $query = "SELECT CONCAT('OPTIMIZE TABLE ', GROUP_CONCAT(CONCAT(table_schema,'.',table_name)),';') INTO @optimizecmd FROM information_schema.tables WHERE table_schema=database(); PREPARE s1 FROM @optimizecmd; EXECUTE s1;"; $mysqli->multi_query($query); $mysqli->close(); } else { exit('Unable to load local.xml file'); }}function clean_var_directory() { // the following website directories are emptied or removed $dirs = array( 'downloader/.cache/', 'downloader/pearlib/cache/*', 'downloader/pearlib/download/*', 'media/css/', 'media/css_secure/', 'media/import/', 'media/js/', 'var/cache/', 'var/locks/', 'var/log/', 'var/report/', 'var/session/', 'var/tmp/' ); foreach($dirs as $dir) { delete_files($dir); }}function delete_files($target) { if(is_dir($target)) { $files = glob($target . '*', GLOB_MARK); foreach($files as $file) { delete_files($file); } rmdir($target); } elseif(is_file($target)) { unlink($target); }}function default_action() { // Just return an empty 403 Forbidden response return http_response_code(403);}?>Magento Maintenance Schedule URI's
To perform automatic maintenance of your Magento webshop, to clear its cache, schedule the following URI's:
- http://www.example.com/maintenance.php?clean=log
- http://www.example.com/maintenance.php?clean=var
for which you can use wget or curl.
This Magento maintenance script is tested with Magento 1.4.2.0 and Magento 1.7.0.2 without problems.
Thank you very much! <3 ❤️
Hi, my name is Jan. I am not a hacker, coder, developer or guru. I am merely an application manager / systems administrator, doing my daily thing at Embrace – The Human Cloud. In the past I worked at CLDIN (CLouDINfra) and Vevida. With over 20 years of experience, my specialties include Windows Server, IIS, Linux (CentOS, Debian), security, PHP, websites & optimization. I blog at https://www.saotn.org.