Join the community today
Become a Member

Xenforo Slow TTFB on Specific Action

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

  1. Matt

    Matt Moderator Staff Member

    680
    314
    63
    May 25, 2014
    Sheffield, UK
    Ratings:
    +433
    Local Time:
    12:20 PM
    1.7.1
    MariaDB 10
    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?
     
    • Informative Informative x 1
  2. Matt

    Matt Moderator Staff Member

    680
    314
    63
    May 25, 2014
    Sheffield, UK
    Ratings:
    +433
    Local Time:
    12:20 PM
    1.7.1
    MariaDB 10
    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.
     
    • Like Like x 1
  3. eva2000

    eva2000 Administrator Staff Member

    28,971
    6,575
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,759
    Local Time:
    9:20 PM
    Nginx 1.13.x
    MariaDB 5.5
    interesting which addon is this ? moderation related ?
     
  4. Matt

    Matt Moderator Staff Member

    680
    314
    63
    May 25, 2014
    Sheffield, UK
    Ratings:
    +433
    Local Time:
    12:20 PM
    1.7.1
    MariaDB 10
    No idea, there are 79 addons installed.
     
  5. eva2000

    eva2000 Administrator Staff Member

    28,971
    6,575
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,759
    Local Time:
    9:20 PM
    Nginx 1.13.x
    MariaDB 5.5
    enable xenforo debug mode ?
     
  6. Matt

    Matt Moderator Staff Member

    680
    314
    63
    May 25, 2014
    Sheffield, UK
    Ratings:
    +433
    Local Time:
    12:20 PM
    1.7.1
    MariaDB 10
    Thread Reply Banner :)

    Just disabled that addon, and overlay is instant.
     
    • Like Like x 1
  7. eva2000

    eva2000 Administrator Staff Member

    28,971
    6,575
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,759
    Local Time:
    9:20 PM
    Nginx 1.13.x
    MariaDB 5.5
    ah ha - mental note made :D
     
  8. Matt

    Matt Moderator Staff Member

    680
    314
    63
    May 25, 2014
    Sheffield, UK
    Ratings:
    +433
    Local Time:
    12:20 PM
    1.7.1
    MariaDB 10
    Don't think it was this one, think it was the Last Post Avatar causing the issue.
     
    • Informative Informative x 1
  9. eva2000

    eva2000 Administrator Staff Member

    28,971
    6,575
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,759
    Local Time:
    9:20 PM
    Nginx 1.13.x
    MariaDB 5.5
  10. Matt

    Matt Moderator Staff Member

    680
    314
    63
    May 25, 2014
    Sheffield, UK
    Ratings:
    +433
    Local Time:
    12:20 PM
    1.7.1
    MariaDB 10
    Well it wasn't that one either. We've 100% identified the issue now........Tapa..........Talk :facepalm:
     
    • Funny Funny x 1
  11. eva2000

    eva2000 Administrator Staff Member

    28,971
    6,575
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,759
    Local Time:
    9:20 PM
    Nginx 1.13.x
    MariaDB 5.5
    oh dear Tapatalk should of been blown away long ago ???
     
  12. elargento

    elargento Member

    284
    16
    18
    Jan 4, 2016
    Ratings:
    +37
    Local Time:
    8:20 AM
    10
    It is supposed it was going to happen after Slavik app release...but life isn't happy as we wish