Situation
In our magento database we have three tables that are growing too big.
- sales_flat_quote_shipping_rate: 3045MB
- sales_flat_quote_address: 1688MB
- sales_flat_quote: 1897MB
That's more than 6GB of data.
I've found this article on how to truncate these tables. This article only speaks of the third table.
I'm not sure about the truncating, and I prefer to delete all data older than 60 days. The article speaks of 17 million records - we have 20! If I'm correct, deleting these records won't lock the table, and I'm currently testing this on a test installation. That seems to work, and it doesn't conflict too much with the site.
Questions
- I would like to know if I can use the same query for the other two tables as well?
- I'm wondering what these tables are for.