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

Moved XenForo to new server and now it's slow - 240s load time

#1
Hi there, I backed up my files and database and moved to a new server. The website takes upwards of 240 seconds to load now.

I have disabled all add ons, and reverted back to default theme. Still very very slow.

internal_data and data directories are both chmod -R 777 as well.

URL did not change, just server hardware/software upgrade

Wondering if my new server is missing an Apache mod, or caching is stuck? or any other thoughts?

It is http://blocktown.org
 

fly

Active member
#2
Have you contacted your host? I'd start there.

Otherwise, does a simple 'hello world' HTML test page display?
 
#3
Have you contacted your host? I'd start there.

Otherwise, does a simple 'hello world' HTML test page display?

It's a VPS - so I am the "host". Also, not my first VPS - but it is my first XF.

Hello world, and a dozen other WP sites work. It's just the 1 (and only) XF site that's not working.
 
#5
Run the requirements test yet?
Just did; flying colors

Code:
XenForo System Requirements Test
Requirements Met
Your server meets all of XenForo's PHP requirements.

XenForo also requires MySQL 5.0 or newer. Please manually check that you meet this requirement.
Also;

Code:
 mysql --version
mysql  Ver 15.1 Distrib 5.5.50-MariaDB, for Linux (x86_64) using readline 5.1
 
#6
To be clear, XF does work if you want to wait the 2.2 minutes load time.

So maybe slow SQL queries?

This is a mirror copy from my old VPS (which is still online). Things seem mostly identical
 

Brogan

XenForo moderator
Staff member
#7
This works: http://blocktown.org/rgba.php
Which shows that general server performance is okay (it doesn't hit the database).

This also works: http://blocktown.org/sitemap.php
Which proves that a connection can be made to the database.

As does this: http://blocktown.org/deferred.php

That would suggest the error is more fundamental to the server configuration and set up.
You will have to start monitoring and checking logs, etc. to determine why pages are taking so long to be served.
 
#12
That would suggest the error is more fundamental to the server configuration and set up.
Exactly right. This website has a few MySQL queries to a remote MySQL host that I forgot about. Once I remember them, I then forgot to add some firewall rules.... *facepalm*.

I'm good to go now. It's always the "simple" things that are overlooked...

Thanks for the help!
 

Digital Doctor

Well-known member
#14
Exactly right. This website has a few MySQL queries to a remote MySQL host that I forgot about. Once I remember them, I then forgot to add some firewall rules.... *facepalm*.

I'm good to go now. It's always the "simple" things that are overlooked...
For the benefit of future webmasters ... what did you need to add ?
You definitely aren't the first or last to overlook firewall rules.
Post how you figured it out to help others do the same !
 
#15
Sure, on my remote (non Xenforo) host, which is Ubuntu today, I had to allow explicit permission to port 3306 from my new VPS IP.

The problem with the 240 seconds was simply a timeout and my server giving up on trying to get a response from the remote MySQL database. Once I remember to open the port, all is well.

Anyways, this is for Ubuntu using ufw, and is not anything special (a Google search will yield the same sample code).

Code:
ufw allow from 1.2.3.4 to any port 3306
Replace 1.2.3.4 with your host IP
 

Tracy Perry

Well-known member
#17
yeah, typically you have to allow the MySQL port in most firewalls. In CSF it's handled via the
Code:
TCP_IN =
TCP_OUT =
TCP6_IN =
TCP6_OUT =
setting in csf.conf for both IPv4 and IPv6.