• 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

Dakis

Well-known member
#1
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/
 

Chris D

XenForo developer
Staff member
#2
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?
 

Dakis

Well-known member
#3
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:

Chris D

XenForo developer
Staff member
#4
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).
 

Slavik

XenForo moderator
Staff member
#5
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.
 

MattW

Well-known member
#6
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.
 

Dakis

Well-known member
#7
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!!
 

Jeremy

Well-known member
#8
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.
 

Dakis

Well-known member
#10
Ok thanks that's the adserver behaving weird, that's why the page never finished loading. I'm deactivating all ad codes now...
 

Dakis

Well-known member
#11
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.
 

Dakis

Well-known member
#12
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).
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.
 

dbembibre

Active member
#13
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.
 

Dakis

Well-known member
#16
[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