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 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.

One thought on “Magento Database Size Growing Rapidly

Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s