I’ve been working on a new site that was located on a staging subdomain. When I was ready to move the site up to the (soon to be) live area I attempted to run a BackupBuddy backup. The backup failed every time after about 30 seconds. Because of messages in the log file indicating memory issues, I double checked the memory allocations, etc… They were all plenty high to run BackupBuddy with some headroom.
After following error codes from BackupBuddy I eventually discovered that the culprit was a database table that was part of Activity Log for WP. That table had exploded from empty to 3.4 gigabytes within a few days of installing it. That was causing the backup to fail simply because of its size.
I was busy on the site - making template changes, etc. for several hours over a couple days, but I was shocked to see that huge amount of data in one database table. The only way I could delete the data from that table and be certain (with my skill level) that I wasn’t going to wreck the site was to check the option to delete all data upon removal of the plugin. I did that and the database immediately shrank to 31MB.
i cannot imagine that it is anything close to normal for that plugin to dump that much data into the database within such a few short days. Is that normal? I have the plugin on other sites and don’t see that problem in those databases.
The site is still under construction, but I have checked it out and I don’t see anything amiss after I deleted the plugin and its data. I don’t suspect anything suspicious beyond this strangeness.
What could cause this issue?