Magento Themes and Magento Extensions

How to find the size / rows of Magento database & tables?

Posted on May 2nd, 2013 | Posted by admin


Magento is a giant e-commerce application having more than 300 tables. It uses an eav model concept and provides different complex features which makes the database huge.

Sometimes you may wonder what’s the database size of your Magento database or individual tables so that you can work on some optimization task or freeing some of your server space.
Here we are going to discuss some SQL queries which seems to be helpful.

SQL Snippets

1. Find size & rows of Magento database

Magento : Delete Test Orders & Customers using SQL

Posted on May 1st, 2013 | Posted by admin

When moving a Magento development site to live or cleaning up dummy orders and customers, you might want to wipe out all test customers and orders from the Magento database / backend. The following SQL queries can be run on the database. Be careful: make a backup of the database before doing this. I’ve run this code over and over again, without any trouble, but still, just be careful.

Page 6 of 6« First...«23456