Dx3webs : The Ultimate Magento Host - Speed : Support : Security

Dx3webs is the ULTIMATE Magento host with a wide range of options for businesses of all sizes.
magento-logo

House keeping for your Magento database

[stextbox id="custom" color="ffffff" bcolor="ffffff'" bgcolor="000000" image="null" float="true" width="600"]
Unless you have correctly setup a cron job to clear out your Magento database it is possible that over time your database could grow extremely large. We have encountered databases almost 1GB filled with useless logged information. Clearing these out not only saves disk space but can lead to some dramatic speed improvements as well.
[/stextbox]

To see if you have a problem open phpmyadmin and click on the database name in the left hand menu. This will list all your tables in the right hand window and you will see the size of your different tables.
Look at all log tables ie

log_customer
log_quote
log_summary
log_summary_type
log_url
log_url_info
log_visitor
log_visitor_info

and

report_event

This last table collects information on
catalog_product_view (products recently viewed box)
sendfriend_product
catalog_product_compare_add_product (recently compared products box and compare box)
checkout_cart_add_product
wishlist_add_product (wishlist box not wishlist itself)
wishlist_share

and is very prone to bloat.

If any of these tables are large and yes, 1/2 a million records is large you can Empty them.

Put a tick next to each table you wish to Empty (NOT DROP). At the bottom of the table list you will see the option. With checked : Select Empty. You will be taken to a confirmation screen asking if you are sure you wish to TRUNCATE these tables. Select yes and you could potentially reclain a lot of disk space.

Once you have done this use the same technique to OPTIMISE your table. Log into the backend and refresh your cache.

[stextbox id="alert" width="600" color="000" bcolor="000" bgcolor="eeeeee" image="null" caption="Looking for Optimised UK Magento Hosting"]
Rock solid speed and reliability
Robust, reliable, fully backed up, secure UK based Magento hosting for £175 per year. Full details here or Contact us
[/stextbox]

Tags: , , , , , , , , , , , , , , ,

2 Comments : Leave a Reply

  1. sjolzy says:


    TRUNCATE `log_url_info`;
    TRUNCATE `log_visitor_info`;
    TRUNCATE `index_event`;
    TRUNCATE `log_visitor`;
    TRUNCATE `log_url`;
    TRUNCATE `report_event`;
    TRUNCATE `dataflow_batch_import`;
    TRUNCATE `dataflow_batch_export`;

    i use this , but, i think i can do more

  2. Thanks! I’ve managed to reduce the size of my database from 1gb to just over 600mb!

Leave a Reply