Site iis running slow..

[mike2902]

My site is running really slow....its taking 30 seconds for posts to hit. That slow. I have contacted my host and they say the server is fine and said it was vbulletin . I have uploaded all new files, disabled all my modifications and its still slow. Im looking for some tool to diagnose where the slow down is happening, hopefully to prove the server is the issue so I can prove to my host its the server. Oh and Ive rebooted the server,, updated and repair tables as well. Any thoughts, tools, diagnostics on how to located the source of the problem

www.hangin-out.net

running 3.8.7



If you want to log in to see how slow

Login: Test User
Password: password



Thanks i advance for any help

[Dave]

It might be because your server takes a long time to connect to the database server.
Is MySQL hosted on the same server? What did you enter as host in the config.php file? 127.0.0.1?

[Max Taxable]

I have contacted my host and they say the server is fine and said it was vbulletin.It's not, it never is. That is total crap these call center mop swingers and burger flippers read from a script and have zero idea what they're talking about. Remember, with most any host the script is "blame the customer first."

WebPageTest is the best tool to use to diagnose issues. It is real world browsers on real world connections that don't cache and give you a real picture of what is going on. It is 100% objective and scientific - unlike most other "performance testers" out there, WPT isn't trying to sell you anything. Here is a test I ran on you:

http://www.webpagetest.org/result/150905_G4_TCG/

The server is not responding. First byte time is 15 seconds then total load time is only a second more. This is THEM, not you. I see this all the time, on oversold shared hosting machines, and machines with software issues.


You're loading only 450kb which shouldn't take long to load at all. However, 300kb of that is your header image. It's linked to and listed as a jpg but it's not, it is a very fat PNG.

I have optimized this image for you, downloadable here. It's only 52kb now. Saving you about 250kb of unnecessary bloat. Upload this to your server in the /images/misc folder.

http://eipnetworks.com/HO_Rambo.jpg

NOTE: Leave the underscore in the filename and change your script to match. You have a space in the filename and that's problematic for browsers.

Visit our vBulletin optimization workshop at OzzModz to get help with optimizing your site further.

http://ozzmodz.com/forumdisplay.php/93-vBulletin-Optimization

[mike2902]

It might be because your server takes a long time to connect to the database server.
Is MySQL hosted on the same server? What did you enter as host in the config.php file? 127.0.0.1?



I dont remember putting that there but 127.0.0.1 is in there


$config['Misc']['memcacheserver'][$i] = '127.0.0.1';

[RichieBoy67]

I dont remember putting that there but 127.0.0.1 is in there


$config['Misc']['memcacheserver'][$i] = '127.0.0.1';

What does this line say?


// ****** MASTER DATABASE SERVER NAME AND PORT ******
// This is the hostname or IP address and port of the database server.
// If you are unsure of what to put here, leave the default values.
//
// Note: If you are using IIS 7+ and MySQL is on the same machine, you
// need to use 127.0.0.1 instead of localhost
$config['MasterServer']['servername'] = '#############';
$config['MasterServer']['port'] = 3306;


What else is running on your server and who is your host?

[mike2902]

I have a VPS server. So im sure there are lots of other people on it. I personally have nothing else on it. The thing has been running fine for years...then it just became unusable. This is the reply from my host that you guys say its the server




http://hangin-out.net/test.html , a test "html" page we made is opening really fast from our side, as it appears your scripts are resolving slowly.

If you look at http://tools.pingdom.com/fpt/#!/c9KIWr/http://hangin-out.net , it appears cron.php is the culprit here.

--------------- Added 1441545573 at 1441545573 ---------------

What does this line say?


// ****** MASTER DATABASE SERVER NAME AND PORT ******
// This is the hostname or IP address and port of the database server.
// If you are unsure of what to put here, leave the default values.
//
// Note: If you are using IIS 7+ and MySQL is on the same machine, you
// need to use 127.0.0.1 instead of localhost
$config['MasterServer']['servername'] = '#############';
$config['MasterServer']['port'] = 3306;


What else is running on your server and who is your host?



It says local host

[RichieBoy67]

What plugs do you have or are you doing a mass mail or something?

[Dave]

I remember a while ago I came across the same problem, I found out that PHP never cleaned the PHP session folder of old files. At some point it contained over 2.5 MILLION session files which made the site extremely slow.

You should take a look at the folder where PHP is saving the session files and see if PHP is correctly garbage cleaning the folder.

If that's also not the case, you may want to consider paying someone to look into it. It's really hard for us to figure out what's going on without having access to the server.

[Max Taxable]

I have a VPS server. So im sure there are lots of other people on it. I personally have nothing else on it. The thing has been running fine for years...then it just became unusable. This is the reply from my host that you guys say its the server:

"it appears cron.php is the culprit here."That's interesting because if you look at the test I ran before, this was NOT happening but, now it is.

http://www.webpagetest.org/result/150906_52_JW1/1/details/

From this test it does look like cron is hanging now. It wasn't before. They have done something to improve this first byte time. There is nothing you can do or that vBulletin can do, to affect first byte time.

Personally I have no idea what to do if cron is hanging, maybe someone else here will know.

Understand: This is a totally DIFFERENT PROBLEM now from the one you originally had. The two tests I have posted here prove it.

[Max Taxable]

And on this repeat test done just now, cron is not hanging and you have very slow response from server, again.

http://www.webpagetest.org/result/150905_G4_TCG/

Ask them to move you to a different machine. I think the one you're on is ill.

[TheLastSuperman]

Discussed before... do as the members here stated: https://vborg.vbsupport.ru/showthread.php?t=254737

i.e. What scheduled task was running when cron.php decided to go slow-mo on you?

If you find that, Grasshopper... you find inner peace and perhaps a resolution!

[HM666]

i.e. What scheduled task was running when cron.php decided to go slow-mo on you?

Yeah exactly what I was thinking. Have you recently added a new cron job to either vBulletin or your server? Or installed a new mod you did not have before? A mod could be the culprit putting too much strain on the cron job on your server.

[mike2902]

Discussed before... do as the members here stated: https://vborg.vbsupport.ru/showthread.php?t=254737

i.e. What scheduled task was running when cron.php decided to go slow-mo on you?

If you find that, Grasshopper... you find inner peace and perhaps a resolution!


I checked the log list and the only task that even ran that day, and not at the same time was a couple of robot posts

[RichieBoy67]

robot posts?

[TheLastSuperman]

robot posts?

Ditto!

?

[Max Taxable]

robot posts?RSS feed robot, for example.

[TheLastSuperman]

^ What I assumed but with issues, best to never assume - I've been surprised before and won't be the last time!

[mike2902]

robot posts?

Ditto!

?

They are auto post twice a day (4 total) TIL posts from reddit and NASA RSS feeds.




And I posted all the replies from you guys on my ticket with my host and this is the reply back. They basically say the site loads really fast and then there is a 10-16 second delay. Im not sure the webpagetest results show that?




I wasn't able to find any cause for this on server side. Server
load and memory usage are consistently low (near 0 all the time) and hardware
node your VPS is located on is also under minimum load.

Website momentarily
loads really fast and most of times load time is around 12 - 16 seconds.




Unfortunately we weren't able to find any cause for such slowness on
server side and we can only advise you to have web developer check scripts on
account to find what is causing this.

If you need us to tweak or modify
anything from server side we will gladly assist you.

[the one]

Have you a proxy plugin installed

cheers

[Max Taxable]

And I posted all the replies from you guys on my ticket with my host and this is the reply back. They just need to move you to another of their machines.

But here again we see, they are sticking to the script, it's your fault. Blaming you.

[Seven Skins]

As far as I can guess ... connection to and from your MySQL server is an issue, look into that why connection to MySQL server has to wait for 15 seconds.

All your image are loading fine e.g. http://www.hangin-out.net/images/misc/HO%20Rambo.jpg

[mike2902]

As far as I can guess ... connection to and from your MySQL server is an issue, look into that why connection to MySQL server has to wait for 15 seconds.

All your image are loading fine e.g. http://www.hangin-out.net/images/misc/HO%20Rambo.jpg



Thats the thing. Even when the page loads, the avatars dont load immediately and attachments take seconds longer to load too. ITs not just the page loading time. Everything is slow. Posts take 10 seconds to post. Every click I make in the AdminCP takes 10 seconds to load. Everything

[Seven Skins]

Avatar links are getting served via database hence delay.

Try loading ANY images on your website directly they load fast ... e.g. http://www.hangin-out.net/images/buttons/quote.gif

Check these two settings in php.ini .. if not -1 try setting them to -1 and restart your VPS.

mysql.max_persistent = -1
mysql.max_links = -1

Also check my.ini for max_connection or max_user_connections if they are there.


PS. Remember all the settings you change in case you need to revert them.

.

[mike2902]

Avatar links are getting served via database hence delay.

Try loading ANY images on your website directly they load fast ... e.g. http://www.hangin-out.net/images/buttons/quote.gif

Check these two settings in php.ini .. if not -1 try setting them to -1 and restart your VPS.

mysql.max_persistent = -1
mysql.max_links = -1

Also check my.ini for max_connection or max_user_connections if they are there.


PS. Remember all the settings you change in case you need to revert them.

.


Where might I find php.ini ?

[Max Taxable]

Where might I find php.ini ?Look. This problem you are having is going to continue as long as YOU allow it to continue. Let's look at it logically:

#1: You made NO changes at all just prior to the problems, correct? And there's been no hacking or defacing?

#2: Software and platforms and scripts don't get "tired" or wear out, or lose tolerance, or anything like that. If you don't alter it, it stays consistent.

MACHINES DO WEAR OUT, LOSE TOLERANCE, AND GET "TIRED." They also outright break.

You are on a MACHINE and the MACHINE is the problem, if #1 above is true.

It's really just this simple and no amount of worrying about php.ini files and other stuff that was NEVER CHANGED gets you any closer to ending this problem.

IT'S THE MACHINE! I have seen this about a dozen times the last 12 years. It is NEVER the vBulletin, when #1 above is true.

How about this. Let's try something really simple and easy to do: HAVE THEM PUT YOU ON A DIFFERENT MACHINE AND THEN WATCH THE PROBLEMS MAGICALLY DISAPPEAR.

Works every time it is tried, when the situation is as you have described and #1 above is true.

[z3r0]

I have a VPS server. So im sure there are lots of other people on it. I personally have nothing else on it. The thing has been running fine for years...then it just became unusable. This is the reply from my host that you guys say its the server






--------------- Added 1441545573 at 1441545573 ---------------





It says local host

vbulletin will run stupidly slow in IIS if you have localhost as the hostname, you should change it to 127.0.0.1

[RichieBoy67]

It may help to move attachments from your database to your file system if they are being stored in the database. Check avatars, etc as well. This may help.

[Dave]

OP should also take a look at http://ozzmodz.com/showthread.php/2580-Speed-Up-Your-Site-Within-The-ACP :)