I recently had an issue where my multi-site database grew huge and exceeded it’s size limit in a couple of days. I narrowed it down to the wp_sitemeta table which was over 500MB in size. I was also unable to login the to back-end as super admin. It is difficult to narrow down the culprit script/plugin, but the row within that table that was 500MB was wdp_un_autoupdate_schedule. Deleting this row reduced the table size to 400 KB. I’ve seen this before where some script gets stuck in a Loop and creates more and more data in the database.
I’m wondering if it was caused by plugin WPMU DEV DashBoard below version 4.0.7 because on 4.0.7 the changelog indicates:
– Fix a possible infinite-loops that blocked wp-admin for the superadmin in rare cases.
– Add an additional timeout to really prevent infinite-loops in any case!
You would know if the plugin writes to that row and table??
Luckily this only happened on a development site, this would have been a disaster on a live site.
That all said I have 3 questions:
1. Did the Dashboard plugin cause the problem?
2. Will deleting that row (as above) cause problems in the functioning of the site?
3. is it possible to use your plugins without having to use the dashboard?