Tag - optimize Magento database

optimize Magento database

How to optimize Magento database 1.9.x

How to optimize Magento database 1.9.x I have magento version 1.9.2.1, and I have greater than 30000 products in my store. My magento databse size raise to 3GB approximate. For database optimization What I already did : 1) clean log tables But still database size is 2.7 GB. When I checked products tables, these have multiple entry for one product corresponding to store and customer group. For Example : I have 4 store and 6 customer groups then there are total 24 rows for [...]

Read more...