600mb database caused by events calendar

[akis2001]

I have a problem with a site using the events calendar, after some investigation we have discovered that the database for the site is in excess of 600mb. After checking the database via phpmyadmin we have found that the Events Calendar and the Events Calendar Category Colors is accounting for the majority of this. The site is lagging massively, backups are not working and site admin emails are no longer being sent and I believe this is all an impact of the huge database size.

Please can you advise if you have come across this before and how I can fix this.

thank you

[Brook]

Howdy Akis,

I would love to help you with this. It sounds like you might be suffering from an overly large amount of cached pages. You can confirm this by double checking which database table is the largest. If it is the wp_options table that is consuming much of the 600MB, it’s probably this issue.

There is a loophole in our calendar right now when you have Month View Caching enabled. We will cache any month you view in the WordPress cache. And that’s the problem. There are plenty of robots out there that visit your website, most of them like Google will not visit all of the month view pages because we have have a little flag on those pages saying they should not be indexed. But some robots will visit the pages anyways, and they can view many thousands of pages. When you have thousands of pages cached your database gets big.

We plan to introduce throttling in the future to put a maximum limit on how many pages can get cached. Until then this problem can be resolved by disabling the Month View Cache. WP will gradually empty all of the pages in the “transient” cache and your database will shrink. Or you can force it to clear the cache by using a plugin like Transient Cleaner.

Did that work? Does that all make sense?

Cheers!

– Brook

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts