Our store database reached 1GB, and the hosting provider doesn't allow the size of the database to be more than 1GB.
Now, I can't add new data such as product or category to the database.
How to decrease database size? or remove which items?
There are about 1800 removed products. but I think their pictures data still exist in "Picture" table. How to remove them?