Yeah, it’s been a while I know. Recently I needed to export and import the database of a fairly large Magento website. The database dump file(s) were around 15GB in size. Yeah the database isn’t…
Shrinking Database Size for Magento
If you ever managed a medium to large Magento shop you very well know that its database size can grow quite a bit. In particular if the site has sizable catalog, large amount of traffic,…
Magento Admin Tip: Run mysqldump Without Locking Tables
Hey all Magento administrators or developers out there, just a short tip here on how to avoid locking tables when you perform a full mysqldump on a live server. This does not apply for any shared hosting, but only the more advanced dedicated hosting (VPS/cloud or not). When you perform a mysqldump on a live environment, the default behaviour is to lock the entire set of tables until the dump is complete, even if it takes 1 minute or less, it means that during that minute, users will not be able to checkout, or admins may not be able to perform any transactions in the back end.