Want to subscribe to topics you're interested in?
Become a Member

Xenforo Slow TTFB on Specific Action

Discussion in 'Forum software usage' started by Matt, Jul 29, 2017.

  1. Matt

    Matt Well-Known Member

    932
    415
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +671
    Local Time:
    8:56 AM
    1.5.15
    MariaDB 10.2
    I've built a new server, same as EVERY other centminmod install I've done.


    However, there is a slight niggle, which I'm pulling my hair out trying to figure out.

    Specifically, the action of Inline Moderation is taking 5 or 10 seconds for the TTFB

    upload_2017-7-29_5-23-25.png

    This is reproducible, and it always either super fast (<200ms), 5.X seconds, or 10.X seconds for the TTFB.

    upload_2017-7-29_5-25-10.png

    It's ONLY this specific action that is slow. Nothing else on the site is slow. Nothing in the nginx or php-fpm logs.

    Have tried with PHP7 and PHP7.1, and the issue is still there.

    This is on a Hetzner E31275 v5 so plenty of horse power, and the site is small (average server load is 0.09 constantly.

    I've tried everything I can possibly think of, so looking for some assistance if possible?
     
  2. Matt

    Matt Well-Known Member

    932
    415
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +671
    Local Time:
    8:56 AM
    1.5.15
    MariaDB 10.2
    Think I've managed to track this down to an addon conflict, as disabled all addons via config.php, the overlay is instant each and every time. I can also see a MySQL query taking either 5 or 10 seconds while the overlay is waiting to display.
     
  3. eva2000

    eva2000 Administrator Staff Member

    55,180
    12,250
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,828
    Local Time:
    5:56 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    interesting which addon is this ? moderation related ?
     
  4. Matt

    Matt Well-Known Member

    932
    415
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +671
    Local Time:
    8:56 AM
    1.5.15
    MariaDB 10.2
    No idea, there are 79 addons installed.
     
  5. eva2000

    eva2000 Administrator Staff Member

    55,180
    12,250
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,828
    Local Time:
    5:56 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    enable xenforo debug mode ?
     
  6. Matt

    Matt Well-Known Member

    932
    415
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +671
    Local Time:
    8:56 AM
    1.5.15
    MariaDB 10.2
    Thread Reply Banner :)

    Just disabled that addon, and overlay is instant.
     
  7. eva2000

    eva2000 Administrator Staff Member

    55,180
    12,250
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,828
    Local Time:
    5:56 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    ah ha - mental note made :D
     
  8. Matt

    Matt Well-Known Member

    932
    415
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +671
    Local Time:
    8:56 AM
    1.5.15
    MariaDB 10.2
    Don't think it was this one, think it was the Last Post Avatar causing the issue.
     
  9. eva2000

    eva2000 Administrator Staff Member

    55,180
    12,250
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,828
    Local Time:
    5:56 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  10. Matt

    Matt Well-Known Member

    932
    415
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +671
    Local Time:
    8:56 AM
    1.5.15
    MariaDB 10.2
    Well it wasn't that one either. We've 100% identified the issue now........Tapa..........Talk :facepalm:
     
  11. eva2000

    eva2000 Administrator Staff Member

    55,180
    12,250
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,828
    Local Time:
    5:56 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    oh dear Tapatalk should of been blown away long ago ???
     
  12. elargento

    elargento Member

    352
    17
    18
    Jan 4, 2016
    Ratings:
    +44
    Local Time:
    4:56 AM
    10
    It is supposed it was going to happen after Slavik app release...but life isn't happy as we wish