Large installation, comments timeout

  • abergman

    (@abergman)


    11 years, 11 months ago

    Hi,

    First of all, yes we run a old version, updating isn’t an option.

    So, the issue.

    Yesterday all commenting started taking awfully long time, and after a while the wp-comments-post.php page turns white.

    The strange part is the lack of errors in the logs, we run a 3 tier installation with varnish, nginx/php-fpm and the database tables converted to InnoDB. We do have a project to implement MultiDB but haven’t had the time.

    Anyone got any suggestions? Besides the obvious ones, like to large database etc, we already got that covered. The site is about 24k blogs and around 30k users..

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    11 years, 11 months ago

    White page is PHP, and at the comment page, I’d guess you just have a LOT of comments.

    How many?

    Have you run a repair on the DB? Emptied spam and trash comments?

    Thread Starter abergman

    (@abergman)

    11 years, 11 months ago

    Thx for the answer!

    Since it’s a multisite, I don’t really know how many comments there are, as I said it’s about 24 000 blogs and most of them more or less active, so I would guess around 200 000 – 500 000 comments, at least.

    The issue affects all blogs, not just the busy ones. Writing new posts works great, so i can’t see that there should be an issue with slow writing or similar to the database.

    I enabled error reporting in PHP, but didn’t get any errors on that page, neither on screen nor in the error-log, (i did receive errors, so i know that the reporting works).

    Are there any functions in the wp-comments-post.php that are known to make a fuss?

    Ed

    (@coopeh)

    11 years, 11 months ago

    Do you have any third party comment plugins enabled, something could be timing out somewhere or limiting it at least?

    Also look at enabling APC opcode caching if you haven’t already, that sped ours up a lot. Definitely do a repair/optimize on the entire DB when it’s quiet if you can.

    Finally it would be good to check with something like the debugbar plugin to see what queries are being run, check slow queries log too in mysql.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Large installation, comments timeout’ is closed to new replies.