Magento Database Size Growing Rapidly

The database size of a Magento installation, in particular once they have gone live, tends to grow rapidly because Magento keeps track of visitors who visit the site and the url of pages that they visit.

To give you an idea, for a relatively low traffic Magento Site version 1.4.1.1 of ~30 visitors per day and ~10 page clicks per visitor, the database grows at a pace of ~10MB per day.

To reduce the database size, use phpMyAdmin to browse the tables and locate “log_url”, “log_url_info”, “log_visitor”, “log_visitor_info”.

phpMyAdmin tells you in a glance the number of records in these tables and their sizes.

Select these tables and empty them. Confirm to truncate.

In this particular example, I have just reduced the size from ~495MB to ~134MB.

Advertisements

One thought on “Magento Database Size Growing Rapidly

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s