- This topic has 5 replies, 4 voices, and was last updated 10 years ago by
.
-
Posts
-
We have noticed since our site has been up for a while that it has been getting slower and slower (on both the front end for users and the wordpress admin side). Our host has bumped up our hosting speed but it didn’t make any difference. On further inspection of the database, it seems that your plugin is using more cpu that I would expect so something might be awry. A quick look shows that there may be something going on with the wp_options table — it’s got around 70,000 entries and is over 2 GB in size. We think this is causing it to be very slow when doing anything at all with the data in it. It seems to be a lot of tribe-related messages with transient timeouts and such.
Can you help us figure out why the plugin isn’t going through and deleting unnecessary files?
Howdy Jessie,
Thank you for the background info. I am not 100% familiar with your past posts here, but I appreciate you bringing me up to speed with the most relevant info.
Do you have Month View Cache enabled in WP-Admin > Events > Settings > Display ? It’s extremely probable that this is a symptom of having that enabled while your site was extensively spidered or crawled by a robot. Most of the time only a few month view pages are crawled, so you get a few entries in the cache. But, this would mark the second time I’ve seen it where an incredible amount of months were crawled, and a correspondingly huge wp_options table resulted.
If you have month view cache enabled could you disable it? Now we need to clean up the Database. This should actually be pretty easy using a plugin like this. What that will do is clean up every WP Cache (transient) in the wp_options table. By their very nature it should be completely safe to delete all of those transients indiscriminately. But anytime you are doing massive changes to a DB a backup is highly recommended, just to be doubly safe. Once that script has completed try loading your site again. Is it faster?
Do you have a caching solution already in place, such as a plugin like Total Cache or some other server side caching mechanism? Let me know and I can make some followup recommendations.
Cheers!
– Brook
Quick followup, if you did go ahead with making the backup I recommended, after running the transient cleanup plugin you might run an OPTIMIZE_TABLE command on your wp_options tables. Perhaps your wp_posts and wp_postmeta tables as well. When you have removed a massive amount of data from a DB this command can sometimes further speed up the database. This command can be run from PHPMyAdmin as well, just click on the wp_options table then click over to the Operations tab. One of the links on this page is the Optimize table command.
- Brook
Hi – I’m having the same issue on livemusicproject.org with caching. My database size increased from 18MB to 78MB and it took me a while to track down the cause. I’d recommend adding a note about this on your documentation page (https://theeventscalendar.com/knowledgebase/caching-month-view-transients/). For now, I’m turning off caching.
Howdy Pickleshy,
That’s a good idea. I’d also like to see us consider the option of limiting caching to +/- 12 months, that way at most you will have 24 months of entries caches. Anything viewed outside of that window is unlikely to be viewed twice. Do you think that would be a good permanent solution?
- Brook
- The topic ‘Database issues causing very slow loading of site on front and back end’ is closed to new replies.