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???

Thanks.

Comments

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.

BITANUBE’s picture

Hi bojanz.

I'm writting you for your comment "I've seen reports of InnoDB causing databases to increase in size because some kind of garbage collection fails. Google around."

We have several Drupal sites and some Drupal Commerce. All of that commerce are mid size and all of them works slowly.
At this moment we have one site with a lot of waiting IO database disk. We have 3Gb RAM memory but it's slow just with one user. I now that maybe coud not be a Commerce related but the rest of Drupal sites works fine and all Commerce have the same problem.
Table cache_bootstrap needs 3Gb storage with up to 600Mb/row average. I think this is not normal.

We have Debian+NGinx+OpCache+Memcahed+mySQL last versions.

Have you got a mySQL , system or Drupal performance or other considerations ?

Thanks !