Theme can’t handle database with large amount of posts

Posted in: Newspaper
Post count: 24

We have a site that has 240K posts and regularly DB connections jump from 25 to 250 and 350 until DB server chrashes and we get error 502 “Unable to establish a database connection”.

We resized the DB server which helped just a little but following day crashes started again.

The site has WP Rocket, Sucuri and Redis object & page caching set up, and even on some pages we have block cache enabled. It doesn’t seem like a frontend problem because page speeds are okay but rather a DB problem.

This started happening after theme update to v12.

Any help would be appreciated because site is basically unusable every 2 or 3 days when this happens and manual intervention is needed every time.

Post count: 27744

Hello,

I apologize for the delay.
Do you have set the block on the page to be sorted by popularity? If yes, then please do a test and don’t use this option and check after.

Thank you!

Viewing 2 posts - 1 through 2 (of 2 total)
The forum ‘Newspaper’ is closed to new topics and replies.