Support » Plugin: Yet Another Related Posts Plugin (YARPP) » [Plugin: Yet Another Related Posts Plugin] yarpp causes entire server timeouts – tag related

  • Hey!
    So I was reading in a few posts that sites with lots of tags were having issues with the browsers. Well, we just spent a week trying to sort out why my entire server was having 504 Gateway Timeout errors. This is a VPS with 1024megs of ram running a couple of sites with low traffic.

    After a week with 2 techs and DBA, we were able to isolate it to the YARPP plugin running on one of the sites. Everytime the page loaded, the sql daemon would max out the cpu core. With more than 1 person looking at a page, it would simply timeout the entire server for several seconds effecting all the sites. Further investigation show that if I told it to not consider the tags, everything went back to normal.

    So just wanted to let you know. I’m running the latest beta version at this point (3.2b3)

    The site running the plugin had 1200 tags.

    Hope you come up with a solution for this. 🙂 It’s a great plugin but without tag considering, it’s severally limited for our needs 🙁

    Cheers and keep up the great work!

Viewing 1 replies (of 1 total)
  • Hi @tamerax, there is information in the FAQ recommending turning off “consider tags” or “consider categories” to make the queries less computationally intensive.

    I have an idea as to how to improve this, though, and hope to incorporate a slight optimization in 3.2 beta 5, later today.

Viewing 1 replies (of 1 total)
  • The topic ‘[Plugin: Yet Another Related Posts Plugin] yarpp causes entire server timeouts – tag related’ is closed to new replies.