vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Site iis running slow.. (https://vborg.vbsupport.ru/showthread.php?t=320117)

mike2902 09-05-2015 11:14 AM

Site iis running slow..
 
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 09-05-2015 05:37 PM

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 09-05-2015 06:58 PM

Quote:

Originally Posted by mike2902 (Post 2554319)
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/...n-Optimization

mike2902 09-05-2015 11:07 PM

Quote:

Originally Posted by Dave (Post 2554333)
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 09-06-2015 12:30 AM

Quote:

Originally Posted by mike2902 (Post 2554349)
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?

PHP Code:

        //        ****** 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 09-06-2015 11:10 AM

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




Quote:

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/#!/c9KI...hangin-out.net , it appears cron.php is the culprit here.
--------------- Added [DATE]1441545573[/DATE] at [TIME]1441545573[/TIME] ---------------

Quote:

Originally Posted by RichieBoy67 (Post 2554353)
What does this line say?

PHP Code:

        //        ****** 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 09-06-2015 11:48 AM

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

Dave 09-06-2015 12:33 PM

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 09-06-2015 01:49 PM

Quote:

Originally Posted by mike2902 (Post 2554387)
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/15...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 09-06-2015 01:56 PM

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 09-06-2015 06:11 PM

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 09-07-2015 08:23 AM

Quote:

Originally Posted by TheLastSuperman (Post 2554424)

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 09-07-2015 11:56 AM

Quote:

Originally Posted by TheLastSuperman (Post 2554424)
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 09-07-2015 12:06 PM

robot posts?

TheLastSuperman 09-07-2015 05:48 PM

Quote:

Originally Posted by RichieBoy67 (Post 2554473)
robot posts?

Ditto!

?

Max Taxable 09-07-2015 05:54 PM

Quote:

Originally Posted by RichieBoy67 (Post 2554473)
robot posts?

RSS feed robot, for example.

TheLastSuperman 09-07-2015 05:57 PM

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

mike2902 09-09-2015 07:04 AM

Quote:

Originally Posted by RichieBoy67 (Post 2554473)
robot posts?

Quote:

Originally Posted by TheLastSuperman (Post 2554489)
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?




Quote:

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 09-09-2015 07:06 AM

Have you a proxy plugin installed

cheers

Max Taxable 09-09-2015 04:36 PM

Quote:

Originally Posted by mike2902 (Post 2554634)
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 09-09-2015 06:47 PM

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 09-09-2015 08:04 PM

Quote:

Originally Posted by Seven Skins (Post 2554673)
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 09-09-2015 08:34 PM

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 09-10-2015 08:33 PM

Quote:

Originally Posted by Seven Skins (Post 2554688)
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 09-10-2015 08:42 PM

Quote:

Originally Posted by mike2902 (Post 2554781)
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 09-14-2015 03:38 PM

Quote:

Originally Posted by mike2902 (Post 2554387)
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 [DATE]1441545573[/DATE] at [TIME]1441545573[/TIME] ---------------





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 09-15-2015 12:30 PM

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 09-16-2015 07:56 PM

OP should also take a look at http://ozzmodz.com/showthread.php/25...Within-The-ACP :)


All times are GMT. The time now is 12:21 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02025 seconds
  • Memory Usage 1,828KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php_printable
  • (18)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (28)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete