1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Load problem - Help with server / xenforo optimization

Discussion in 'Server Configuration and Hosting' started by Dakis, Jul 18, 2013.

  1. Dakis

    Dakis Well-Known Member

    My website is having huge problems, pages take forever to load, all of a sudden, not sure if that's a software issue or server problem, I haven't changed anything, could it be just server load? Can someone help me to optimize xenforo as the site is practically unusable right now?

    http://www.travelstories.gr/community/
     
  2. Chris D

    Chris D XenForo Developer Staff Member

    Did you get anywhere with disabling all add-ons?

    For a quick way to do this, you could add the following to your config.php file:

    $config['enableListeners'] = false;

    If things clear up after that then we've isolated it being an add-on problem... and hopefully not one of the ones I wrote for you! :)

    Also has your host been able to rule anything out?
     
  3. Dakis

    Dakis Well-Known Member

    No, site was working perfectly fine in regards to server load, with double the people online than it has this time of night.

    Server load right now is above 70 :eek:

    My host says that a site "this big" needs a huge server to host and can't be handled by a vps...

    BTW, the vps is an 8-core, 8-gb ram one.
     
    Last edited: Jul 18, 2013
  4. Chris D

    Chris D XenForo Developer Staff Member

    That, to me, sounds like an excuse.

    The online stats we have at ValveTime.net (http://www.valvetime.net/) are never much less than yours. And I notice your most online users ever is about 500. Ours is 2,500. When that happened (very recently), our VPS didn't buckle once.

    Yet, it only has 3GB of RAM. Not sure about processor cores but I don't think it's as many as 8.

    My point is, for your server to be that spec, and for him to be telling you that your server isn't good enough is frankly bull.

    We use the Typhoon package at Nimbus Hosting (http://www.nimbushosting.co.uk/).

    Oh. And our VPS hosts http://www.valvetime.net, http://xenmediagallery.com, http://combineoverwiki.com and in addition to all of that it also used to run http://8thos.com at the same time (we temporarily helped them out while they were between hosts).
     
    DRE and Dakis like this.
  5. Slavik

    Slavik XenForo Moderator Staff Member

    1. Log in via SSH and use the top command to see what process is causing the load.

    2. Try disabling addons, you may have something adding some dodgy code in causing excessive queries per page load.

    3. Run a check on the database to ensure all the tables are working and correct.

    4. Check any custom rewrite rules you may have.
     
  6. MattW

    MattW Well-Known Member

    Your host is talking rubbish about a site that large needing a huge server.

    Your page never finishes loading when I try accessing it, and there are a lot of 404 errors

    404_errors.PNG

    I'd not be surprised if you are having disk IO issues causing a load in the 70's, which is usually another VPS on the same node as you using all the IO.
     
    Jeremy and Chris D like this.
  7. Dakis

    Dakis Well-Known Member

    Thanks for your replies everyone I really appreciate them, can you please tell me if you see a 728x90 banner on the top right? Because what I see there is a "repetition" of the site's homepage!!
     
  8. Jeremy

    Jeremy XenForo Moderator Staff Member

    The duplication is your 404 page. Inspecting the element shows a class of error404 body-class on the element.

    It also appears as if you have debug mode running, you may want to turn that off for a boost in performance.
     
  9. MattW

    MattW Well-Known Member

    no_banner.PNG

    no banner
     
    Dakis likes this.
  10. Dakis

    Dakis Well-Known Member

    Ok thanks that's the adserver behaving weird, that's why the page never finished loading. I'm deactivating all ad codes now...
     
  11. Dakis

    Dakis Well-Known Member

    Ok it looks like the speed of the site has improved immediately after I closed the ad server code.

    And I see the load dropped from 70 to 5 :)

    The ad server code was requesting something that wasn't there (from the 404 error I see a request to a folder that doesn't exist), perhaps this was the problem.

    Thanks for your help fellows, I'll keep an eye on this see how it goes today.
     
    CyclingTribe and Chris D like this.
  12. Dakis

    Dakis Well-Known Member

    Thanks for that info Chris, this does look like very weird to me, I don't know.

    Should I activate some caching mechanism to help out for the load? It's constantly above 5.
     
  13. dbembibre

    dbembibre Active Member

    Install APC or xCache and your load down a 30%. Move your htaccess to httpd.confg, you can install also nginx as reverse proxy for apache.
    Post here your mysql configuration and apache config.
     
  14. Dakis

    Dakis Well-Known Member

    Where can I get those configs from? my WHM ?
     
  15. dbembibre

    dbembibre Active Member

    Enter via SSH and type cat /etc/my.cnf
     
  16. Dakis

    Dakis Well-Known Member

    [mysqld]

    max_allowed_packet=64M
    tmp_table_size=512M
    table_open_cache=1024
    read_rnd_buffer_size=2M
    skip_external_locking
    skip_networking
    query_cache_size=128M
    innodb_file_per_table=1
    long_query_time=2
    max_user_connections=100
    default-storage-engine=MyISAM
    local_infile=0
    server_id=1
    open_files_limit=8192
    max_heap_table_size=512M
    read_buffer_size=2M
    thread_cache_size=256
    max_connect_errors=20
    sort_buffer_size=2M
    join_buffer_size=2M
    collation_server=utf8_general_ci
    key_buffer_size=512M
    query_cache_limit=1M
    max_connections=400
    connect_timeout=100
    datadir="/var/lib/mysql"
    interactive_timeout=100
    table_definition_cache=1024
    wait_timeout=100
    slow_query_log_file="/var/log/mysql-slow-queries.log"
    myisam_sort_buffer_size=64M
    character_set_server=utf8
    query_cache_type=1
    slow_query_log=1

    [isamchk]

    sort_buffer_size=256M
    read_buffer_size=64M
    write_buffer_size=64M
    key_buffer_size=256M

    [mysqlhotcopy]

    interactive_timeout

    [mysql]

    no-auto-rehash

    [mysqldump]

    max_allowed_packet=64M

    [myisamchk]

    sort_buffer_size=256M
    read_buffer_size=64M
    write_buffer_size=64M
    key_buffer_size=256M
     
  17. Tracy Perry

    Tracy Perry Well-Known Member

    Any particular reason you are uisng MyISAM as your default storage engine?
     
  18. Dakis

    Dakis Well-Known Member

    No, but what does that mean? Because I see most of my database tables are Innodb anyway.
     
  19. Tracy Perry

    Tracy Perry Well-Known Member

  20. Dakis

    Dakis Well-Known Member

    All of my tables are InnoDB except 4-5.
     

Share This Page