Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions

Reply
 
Thread Tools Display Modes
  #21  
Old 09-09-2015, 06:47 PM
Seven Skins's Avatar
Seven Skins Seven Skins is offline
 
Join Date: Sep 2008
Location: London, UK
Posts: 1,481
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #22  
Old 09-09-2015, 08:04 PM
mike2902's Avatar
mike2902 mike2902 is offline
 
Join Date: Apr 2009
Posts: 186
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Seven Skins View Post
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
Reply With Quote
  #23  
Old 09-09-2015, 08:34 PM
Seven Skins's Avatar
Seven Skins Seven Skins is offline
 
Join Date: Sep 2008
Location: London, UK
Posts: 1,481
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.

.
Reply With Quote
  #24  
Old 09-10-2015, 08:33 PM
mike2902's Avatar
mike2902 mike2902 is offline
 
Join Date: Apr 2009
Posts: 186
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Seven Skins View Post
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 ?
Reply With Quote
  #25  
Old 09-10-2015, 08:42 PM
Max Taxable's Avatar
Max Taxable Max Taxable is offline
 
Join Date: Feb 2011
Posts: 3,134
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by mike2902 View Post
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.
Reply With Quote
  #26  
Old 09-14-2015, 03:38 PM
z3r0's Avatar
z3r0 z3r0 is offline
 
Join Date: Apr 2005
Posts: 339
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by mike2902 View Post
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
Reply With Quote
  #27  
Old 09-15-2015, 12:30 PM
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Location: CT - Down in a hole..
Posts: 3,057
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #28  
Old 09-16-2015, 07:56 PM
Dave Dave is offline
 
Join Date: May 2010
Posts: 2,583
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

OP should also take a look at http://ozzmodz.com/showthread.php/25...Within-The-ACP
Reply With Quote
Благодарность от:
ozzy47
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:46 PM.


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.04352 seconds
  • Memory Usage 2,226KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (8)post_thanks_box
  • (1)post_thanks_box_bit
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete