Welcome to Centmin Mod Community
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

    691
    319
    63
    May 25, 2014
    Sheffield, UK
    Ratings:
    +444
    Local Time:
    5:51 AM
    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

    691
    319
    63
    May 25, 2014
    Sheffield, UK
    Ratings:
    +444
    Local Time:
    5:51 AM
    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

    30,168
    6,784
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    2:51 PM
    Nginx 1.13.x
    MariaDB 5.5
    interesting which addon is this ? moderation related ?
     
  4. Matt

    Matt Moderator Staff Member

    691
    319
    63
    May 25, 2014
    Sheffield, UK
    Ratings:
    +444
    Local Time:
    5:51 AM
    1.7.1
    MariaDB 10
    No idea, there are 79 addons installed.
     
  5. eva2000

    eva2000 Administrator Staff Member

    30,168
    6,784
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    2:51 PM
    Nginx 1.13.x
    MariaDB 5.5
    enable xenforo debug mode ?
     
  6. Matt

    Matt Moderator Staff Member

    691
    319
    63
    May 25, 2014
    Sheffield, UK
    Ratings:
    +444
    Local Time:
    5:51 AM
    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

    30,168
    6,784
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    2:51 PM
    Nginx 1.13.x
    MariaDB 5.5
    ah ha - mental note made :D
     
  8. Matt

    Matt Moderator Staff Member

    691
    319
    63
    May 25, 2014
    Sheffield, UK
    Ratings:
    +444
    Local Time:
    5:51 AM
    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

    30,168
    6,784
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    2:51 PM
    Nginx 1.13.x
    MariaDB 5.5
  10. Matt

    Matt Moderator Staff Member

    691
    319
    63
    May 25, 2014
    Sheffield, UK
    Ratings:
    +444
    Local Time:
    5:51 AM
    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

    30,168
    6,784
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    2:51 PM
    Nginx 1.13.x
    MariaDB 5.5
    oh dear Tapatalk should of been blown away long ago ???
     
  12. elargento

    elargento Member

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