I just noticed this behavior when one of my commerce sites run out of space. The size in phpmyadmin the db is about 300MB (with caches) and the file size in the disk is about 1,5GB.

Does it happen to anyone else??

What might have cause this???



stellapro’s picture

I am having the same issue and it is causing problems because my host is telling me I am running out of disk space (no lectures on hosting please - I know)
According to my cpanel my db is 5,839.26 MB but according to phpmyadmin it is 20 MiB - that is a lot of difference. I have been trying to delete stuff like users, comments etc but everytime I delete something the amount of hard disk used increases. I have cleared the cache etc and just do not know what to do now as everything I do seems to use resources not free them.

Any help would be appreciated

discipolo’s picture

Issue summary: View changes

i just had something similar, can you check in phpmyadmin whether all that extra size is in the watchdog table? for me it was, and clearing the tables with drush watchdog-delete all then disabling dblog prevented this for me.
hope this helps you too.

bojanz’s picture

Status: Active » Fixed

This is a generic mysql problem that doesn't have anything to do with Commerce Kickstart. Closing.

I've seen reports of InnoDB causing databases to increase in size because some kind of garbage collection fails. Google around.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.