AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

AI Assistant
Notifications
Clear all

Trying to post a thread/post on our forums but it takes a long time (and sometimes times out).

9 Posts
5 Users
1 Reactions
446 Views
Posts: 31
Topic starter
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@languagecaster)
Trusted Member
Joined: 4 years ago
[#73259]

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 


8 Replies
1 Reply
wpForo Support
Moderator
(@wpforo-support)
Joined: 1 year ago

Member
Posts: 87
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian

Hi languagecaster,

Thanks for sharing those specific technical details from your hosting company—that's actually really helpful information to work with. What they're describing are common performance bottlenecks in database-heavy applications like forums, and they're pointing you toward some concrete issues worth addressing.

Let me break down what they're telling you and suggest some steps you can take:

  • Massive table bloat: This means your forum tables have accumulated a lot of unnecessary data or fragmentation over time. You'll want to run database optimization/repair operations. In phpMyAdmin or through your hosting control panel, look for options to optimize your wpForo tables. This should help reclaim space and improve query performance.
  • Table-level locking during forum posts: When users post, the database is locking entire tables instead of just the specific rows being modified. This prevents other users from posting simultaneously. This is often related to the table bloat issue—optimizing should help. You might also want to check if your database is using the right storage engine (InnoDB is generally better than MyISAM for concurrent access).
  • Connection pool exhaustion: Your hosting account only has a limited number of database connections available. When posting takes a long time, connections stay open longer, and you run out of available connections for new requests. This is why you're seeing timeouts. Your hosting company may need to increase your connection limit, or you may need to optimize how wpForo manages database connections.

I'd recommend starting with database optimization first, as that often resolves multiple issues at once. After that, reach out to your hosting support and specifically ask them to: (1) increase your database connection pool limit, and (2) verify you're using InnoDB storage engine for your wpForo tables. Have you already tried running a database optimization/repair, or would you like guidance on how to do that through your hosting control panel?


Reply
Posts: 31
Topic starter
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@languagecaster)
Trusted Member
Joined: 4 years ago

Thanks for the response! Yes, some guidance would be great! Thanks


Reply
Sofy
Posts: 5912
 Sofy
Admin
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@sofy)
Support Team
Joined: 9 years ago

Hi,

Also, please exclude wpForo from your caching plugin, as described in our FAQ:
https://wpforo.com/community/faq/wpforo-and-cache-plugins/#post-37150

You may also find this FAQ helpful for improving your forum's performance:
https://wpforo.com/community/faq/forum-is-slow/


Reply
Posts: 31
Topic starter
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@languagecaster)
Trusted Member
Joined: 4 years ago

Hello,

Our hosting company added this information:

After checking and investigating, we found that your wp-options is using the highest table size with 33GB. We also identified 286,046 expired transient records occupying approximately 18.31 GB of data The detailed table - wp option > damianf_wrdp1 Category Rows Storage Transient values 520,015 33,403.11 MB Other options 5,128 5.85 MB Transient timeout records 520,270 4.96 MB Site transient values 79 4.19 MB Site transient timeout records 78 0.00 MB Expired transient data identified 17.88 GiB Expired transient rows 286,046 Original table size ~33 GB These expired records are contributing significantly to the database size, and causing the database performance from your cPanel And this can come from your Theme or the plugins that you use.

 


Reply
1 Reply
Sofy
 Sofy
Admin
(@sofy)
Joined: 9 years ago

Support Team
Posts: 5912
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian

@languagecaster 

Expired transient records can generally be safely deleted. However, we recommend backing up your database before performing any cleanup.

Please ask your hosting provider to remove the expired transient records and check whether the database size decreases. If the issue recurs, further investigation may be needed to identify which theme or plugin is generating them.


Reply
Posts: 2
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@deepvyas)
New Member
Joined: 2 months ago

Posted by: @languagecaster
↑

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.


Reply
Page 1 / 2
Share: