vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   HELP: Huge number of simultaneous connections to the db server (https://vborg.vbsupport.ru/showthread.php?t=303007)

Simon Lloyd 10-07-2013 09:13 AM

As a side note you should show guests as little as possible, one thing thats a load on your server is showing the "who's Online" to guests, disable it for them. Try to cut down on the amount of things you let them see, also with my mod, if they still exist in your list, prune out "custo" and "DA".

Mostly when you see a bot/spider on your forum you can enter it's name (one name on one line) in the list and after your whos online timeout period has expired the offending bot will be no more :), some bots have variations of their name in their useragent and some dont have their display name in the useragent string at all!

make sure you make use of these tools in the mod description here https://vborg.vbsupport.ru/showthread.php?t=264932

jl255 10-07-2013 09:20 AM

cool tips. i've disabled who's online for guests now. contemplating whether to disable it altogether....

Simon Lloyd 10-07-2013 09:39 AM

Your members generally like to see it and browse it so maybe put up a poll and ask your memebers to vote whether they want to see it or not?

BTW i'm on your site as a guest and i can see whos on line!!, i'd also turn off stats for guests too, that will save plenty of queries and overheads.

Max Taxable 10-07-2013 02:56 PM

Quote:

Originally Posted by jl255 (Post 2450660)
cool tips. i've disabled who's online for guests now.

You have not. You have only removed the link to online.php from the main page. Disable permission to view online.php in usergroup permissions if you really want it gone to visitors and guests.

http://forums.sgclub.com/online.php <--- Anyone going here can still get the who's online page load.

I note SIGNIFICANT improvement in both number of visitors and also page load speed!

But you still have many problems:

http://www.webpagetest.org/result/131007_1W_M2J/

First byte time is still terrible - this is your host. You're still loading a huge number of requests (277, that's you.)

I agree with Simon, you should dump the advanced stats for visitors. But if you keep it, make it only five instead of 12. Also you should restore the "What's going on" on main page, this tells legitimate humans you have a busy site and encourages more registrations.

jl255 10-08-2013 09:12 AM

is it really necessary to disable the online.php? pretty sure most visitors won't deliberately go to that php without any link?

my images are already served from CDN. not sure how else i can improve FBT?

isn't the 'whats going on' still there on the homepage?

again, appreciate all the suggestions and feedback. i'm seriously looking into it.

Simon Lloyd 10-08-2013 11:05 AM

Bots and search engines don't need the link in order to crawl it, most bots have a preprogrammed list of urls to start at. You can leave online.php enabled including the links but you turn off all guest privilidges to view it, do the same for the stats.

I think Max_Taxable is making reference mostly to your host, your system, provided by the host, is delivering the first byte, or if you like shaking hands with the person requesting the page, in far to long a time.

As for your requests either reduce the number of stats you show and auxiliary bits n pieces or use some type of compression, try to amalgamate js files and minify them, compress your css files. Change your images from being a lot of individual images to one sprite and then deliver them from co-ordinates on the sprite.

There really is a ton of stuff to do if you know how and can be bothered ( I don't say that like you're not I say it because sometimes it all gets a bit to much and can put you off)!

Max Taxable 10-08-2013 10:29 PM

Quote:

Originally Posted by jl255 (Post 2450851)
my images are already served from CDN.

Actually, no they are not.

Having the URL be "cdn.mysite/image" is NOT the same thing as having a CDN.

Here's every image your site loads, none of them are coming from a actual CDN.

http://www.webpagetest.org/pageimage...run=1&cached=0

Here are the details of your pageload, every call and how it served. No CDN here either.

http://www.webpagetest.org/result/13...M2J/1/details/

Quote:

Originally Posted by Simon Lloyd (Post 2450855)
I think Max_Taxable is making reference mostly to your host, your system, provided by the host, is delivering the first byte, or if you like shaking hands with the person requesting the page, in far to long a time.

Bingo.

jl255 10-09-2013 03:02 AM

Quote:

Originally Posted by Simon Lloyd (Post 2450855)
Bots and search engines don't need the link in order to crawl it, most bots have a preprogrammed list of urls to start at. You can leave online.php enabled including the links but you turn off all guest privilidges to view it, do the same for the stats.

I think Max_Taxable is making reference mostly to your host, your system, provided by the host, is delivering the first byte, or if you like shaking hands with the person requesting the page, in far to long a time.

As for your requests either reduce the number of stats you show and auxiliary bits n pieces or use some type of compression, try to amalgamate js files and minify them, compress your css files. Change your images from being a lot of individual images to one sprite and then deliver them from co-ordinates on the sprite.

There really is a ton of stuff to do if you know how and can be bothered ( I don't say that like you're not I say it because sometimes it all gets a bit to much and can put you off)!

tks for the tips. online.php permissions have been turned off for guests as suggested.

i have contacted my host to see what they can do about the first byte issue.

i am contemplating a redesign of the forum and will definitely get the coder to look into your suggestions on compression and sprites. :)


Quote:

Originally Posted by Max Taxable (Post 2451032)
Actually, no they are not.

Having the URL be "cdn.mysite/image" is NOT the same thing as having a CDN.

Here's every image your site loads, none of them are coming from a actual CDN.

http://www.webpagetest.org/pageimage...run=1&cached=0

Here are the details of your pageload, every call and how it served. No CDN here either.

http://www.webpagetest.org/result/13...M2J/1/details/

Bingo.

hmm, cdn.xxxx.com is setup to point to my amazon cdn account where a copy of the image files reside as well. how do you tell if they come from the actual CDN?

Max Taxable 10-09-2013 06:00 PM

Quote:

Originally Posted by jl255 (Post 2451136)
tks for the tips. online.php permissions have been turned off for guests as suggested.

i have contacted my host to see what they can do about the first byte issue.

i am contemplating a redesign of the forum and will definitely get the coder to look into your suggestions on compression and sprites. :)




hmm, cdn.xxxx.com is setup to point to my amazon cdn account where a copy of the image files reside as well. how do you tell if they come from the actual CDN?

There's no actual, real Content Delivery Network (CDN) involved in your pageload, is all I know. You can put images in a 3rd party server all day long and point the script to those files on that server, doesn't make it a cloud server or a CDN. Look at the webpage test results - it's clear and evident that your "CDN" not only is causing many more unnecessary calls, it's also actually slowing your page load down. See that big black X at the upper right hand corner of the test page under "Effective use of CDN?"

final kaoss 10-09-2013 08:28 PM

I doubt he would have to worry about using a cdn after implementing one or more steps from my guide (its in the sig). Unless his website consumes over 5GB worth of bandwidth daily, then he might want to pursue the cdn issue. Even then, there are some free cdn's he can use if needed.


All times are GMT. The time now is 01:31 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.01014 seconds
  • Memory Usage 1,752KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete