Join the community today
Become a Member

xenForo forum slower when logged in

Discussion in 'Forum software usage' started by Jon Snow, May 21, 2020.

  1. Jon Snow

    Jon Snow Active Member

    842
    171
    43
    Jun 30, 2017
    Ratings:
    +258
    Local Time:
    4:01 PM
    Nginx 1.13.9
    MariaDB 10.1.31
    Let me just say first that it's fast, but not as fast when I'm logged out. My forum loads extremely fast as a guest, but it takes some 1-4 seconds to load between pages at times when logged in as a member.

    Is this normal or is there a way I can speed it up to guest-levels?


    Would I need a higher spec server or can this be done with tweaking values after centminmod's optimized values?
     
  2. rdan

    rdan Well-Known Member

    5,447
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    3:01 AM
    Mainline
    10.2
    Server specs?
    XF Forum size?
     
  3. Jon Snow

    Jon Snow Active Member

    842
    171
    43
    Jun 30, 2017
    Ratings:
    +258
    Local Time:
    4:01 PM
    Nginx 1.13.9
    MariaDB 10.1.31
    Linode $10 plan.
    Around 500K post database but member activity is <10.
     
  4. rdan

    rdan Well-Known Member

    5,447
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    3:01 AM
    Mainline
    10.2
    2 GB 1 Core 50 GB SSD?
    That isn't enough with your forum size :|

    At-least switch to one of this plans:
    upload_2020-5-21_0-58-15.png

    upload_2020-5-21_0-59-1.png
     
  5. rdan

    rdan Well-Known Member

    5,447
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    3:01 AM
    Mainline
    10.2
  6. eva2000

    eva2000 Administrator Staff Member

    54,931
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,812
    Local Time:
    5:01 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    That is normal, logged out members would have some form of caching in place if you implemented it so guests are faster than logged in members which would bypass such guest caching. Also logged in members would run up additional mysql queries and load from logged in member displayed data which guests won't have.

    But ultimately how fast logged in members experience a forum is down to server optimisation and server hardware backing that optimisation. Centmin Mod auto optimization is based on server specs and for the server. You'd have to further optimise based on your web apps usage requirements.
     
  7. Jon Snow

    Jon Snow Active Member

    842
    171
    43
    Jun 30, 2017
    Ratings:
    +258
    Local Time:
    4:01 PM
    Nginx 1.13.9
    MariaDB 10.1.31
    I was thinking about upgrading to the $20/month plan and killing off some smaller servers I have.
    I use redis guest caching so that's most likely why, but I'm always open to speeding it up for members too.
    I originally started off with the Linode $5 plan for this server and only recompiled nginx and php. I'm guessing since the number of cores haven't changed from $5 -> $10, I wouldn't have to reinstall centminmod to get the optimized values again? Would I have to do that if I upgrade to the $20/month plan?

    Should I do a fresh install of CMM on a $20/month test server and transfer configs anywhere after upgrading my live server to the $20/month plan on Linode? How should we go about this if we want to keep the optimizations?
     
  8. eva2000

    eva2000 Administrator Staff Member

    54,931
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,812
    Local Time:
    5:01 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    For PHP-FPM on upgraded VPS at Linode, you can recompile PHP via centmin.sh menu option 5 so auto redetects memory and server resources and manually re-run /usr/local/src/centminmod/tools/setio.sh as follows
    Code (Text):
    /usr/local/src/centminmod/tools/setio.sh set
    

    which will recalculate MariaDB MySQL innodb I/O variable values to set

    i.e.
    Code (Text):
    /usr/local/src/centminmod/tools/setio.sh set
    Full Reads: 24975
    Full Writes: 59362
    
    set innodb_flush_neighbors = 0
    
    innodb_io_capacity = 2900
    
    +------------------------+-------+
    /etc/my.cnf adjustment
    +------------------------+-------+
    existing value:
    Variable_name   Value
    innodb_io_capacity      2700
    innodb_io_capacity_max  5400
    new value:
    Variable_name   Value
    innodb_io_capacity      2900
    innodb_io_capacity_max  5800
    
    +------------------------+-------+
    innodb io threads adjustment
    +------------------------+-------+
    existing value:
    +------------------------+-------+
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    +------------------------+-------+
    new value:
    +------------------------+-------+
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    +------------------------+-------+
    
    Restart MySQL server for io thread changes
    
     
  9. Jon Snow

    Jon Snow Active Member

    842
    171
    43
    Jun 30, 2017
    Ratings:
    +258
    Local Time:
    4:01 PM
    Nginx 1.13.9
    MariaDB 10.1.31
    I know this because I think I've asked it before, but I think there was another thing that we couldn't do. Or maybe I'm not remembering correctly at 1 AM and need some sleep.
     
  10. Jon Snow

    Jon Snow Active Member

    842
    171
    43
    Jun 30, 2017
    Ratings:
    +258
    Local Time:
    4:01 PM
    Nginx 1.13.9
    MariaDB 10.1.31
    I'm still on the $10/month plan. Upgrading from PHP 7.2 to PHP 7.3 shaved off 1-2 seconds when browsing the XF 2 forum while logged in. It feels almost the same when browsing as a guest.

    I just wished everything was compatible for 7.4.