Magento log cleaning helps you keep your Magento shop fast by cleaning and optimizing your database(s).
Magento saves your web statistics by logging these in your database. This data is useful, but it takes up a lot of disk space and unfortunately Magento’s database is not very efficient. To keep your Magento shop optimized and thus fast, you’ll need to clean these logs. An easy way of cleaning up your database is by enabling Log Cleaning in the backend of Magento. This method is called ‘Automatic log cleaning’. More advanced Magento users can manually clean their logs.
TABLE OF CONTENTS
- Enable Automatic Log Cleaning
- Manually Clean the Magento Logs
- Turn Off Database Logging
Enable Automatic Log Cleaning
Magento offers an easy tool to clean your logs. When you’re not familiar with Magento’s database system, we recommend you to use this tool. Simply follow the steps written below:
- Log into your Magento backend
- In the left menu under
Log Cleaning, change
Enable Log Cleaningto
YESand configure the
Save Log for 7 days
The most important setting is Save log for .. days. We recommend you to pick a number between 1 and 30 days.
Manually Clean the Magento Logs
It is not recommended to manually clean your logs if you don't have prior knowledge of MySQL databases.
Cleaning your Magento logs manually is the most effective way of cleaning your logs. You can use either SSH or phpMyAdmin to manually clean the logs.
Manually Clean the Logs via SSH
Log on to your Hypernode via SSH, navigate to the root of your Magento shop (usually
/data/web/public/ and use the following command:
php -f shell/log.php clean
Manually Clean the Logs via phpMyAdmin
Open your database in PHPMyAdmin and select the following tables:
Scroll down to select ‘Empty’ from the dropdown ‘With selected’ and click yes.
Turn Off Database Logging
If you don’t need any database logging it can be worthwhile to disable all logging. To do so, install the
disablelog extension by Yireo. For shops that are heavy on the database, this can help reduce the amount of update/insert queries and therefore reducing load times.