- wpForo 3.2.2
- Megaphone Theme
- https://learnenglishthroughfootball.com/community/
Hello,
When trying to post a thread/post on our forums, it takes a long time (and sometimes times out). We sometimes receive an error establishing a database enquiry and our site crashes.
Our hosting company say it is due to the following:
1. Massive table bloat 2. Table-level locking during forum posts 3. Connection pool exhaustion
I don't fully understand this but wondered if there might be an answer to this as it means the forum has just become very slow (almost 5 minutes to open a post/thread).
Thank you
Damian
Thanks for the response! Yes, some guidance would be great! Thanks
Hello,
Our hosting company added this information:
After checking and investigating, we found that your wp-
We also identified 286,046 expired transient records occupying approximately 18.31 GB of data
Don't run DELETE based only on the transient name prefix. Some transient values may still be valid, and transient cleanup must account for their timeout records.