The Arcive of Official vBulletin Modifications Site.

Ghostt · #1 05-17-2014, 04:32 PM

there is a a very big overload problem and there are many long querys.

very much SLEEP with long duration like 0-200. what does it meaN?

and can you explain me this query ? it processes very often and long 10-100 duration

PHP Code:


			
SELECT threadid, title, prefixid, lastpost, replycount
FROM vbthread AS thread
WHERE forumid =

and

PHP Code:


			
Sorting result     SELECT thread.threadid, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount

is it like this link?:
/forumdisplay.php?s=&f=161&page=1&pp=20&sort=views& order=desc&daysprune=2

how to fix?

is it also possible to limit the "&pp=20" part so no one can abuse and slowing down site by visiting this page on "&pp=200" ? or does it make no sense.

kh99 · #2 05-17-2014, 05:26 PM

That query is from the archive. You can disable the archive by going to "Search Engine Friendly Archive" in the settings. I don't know much about the advantages of the archive to search engine optimization, but someone recently asked about the same query, and someone else said that the archive doesn't make any difference to search engines these days.

You could also use a mod to block spiders (I don't have the link but it's probably easy to find with a search).

CAG CheechDogg · #3 05-17-2014, 06:14 PM

You should turn archives off , it does nothing for SEO ...

As for blocking spiders use this ...

https://vborg.vbsupport.ru/showthread.php?t=268208

You can also use the following list of all the blocked spiders "I" personally use to keep unnecessary crawlers from your site : (Please note that I block Facebook from crawling "MY" site, remove any of the spiders below from the list if you wish for them to crawl it)

You can also use htacces to block IP block ranges from certain countries such as China and Russia to help even more ....if you want that list let me know ...

almaden
Anarchie
Artabus
ASPSeek
attach
autoemailspider
BackWeb
Baidu
Bandit
BatchFTP
BlackWidow
Bot\mailto:craftbot@yahoo.com
Buddy
bumblebee
CherryPicker
ChinaClaw
CICC
Collector
Copier
Copyscape
Crescent
DIIbot
DISCo
DISCo\Pump
dotbot
Download\Demon
Download\Wonder
Downloader
Drip
DSurf15a
eCatch
EasyDL/2.99
EirGrabber
email
EmailCollector
EmailSiphon
EmailWolf
Express\WebPictures
ExtractorPro
EyeNetIE
FileHound
FlashGet
FrontPage
GetRight
GetSmart
GetWeb!
gigabaz
GNIP
Go\!Zilla
Go!Zilla
Go-Ahead-Got-It
gotit
Grabber
GrabNet
Grafula
grub-client
HMView
HTTrack
httpdown
.*httrack.*
ia_archiver
Ichiro
Image\Stripper
Image\Sucker
Indy*Library
Indy\Library
InterGET
InternetLinkagent
Internet\Ninja
InternetSeer.com
Iria
JBH*agent
JetCar
JOC\Web\Spider
JustView
larbin
LeechFTP
LexiBot
lftp
Link*Sleuth
likse
//Link
LinkWalker
Mag-Net
Magnet
Magpie
magpie
Mass\Downloader
Memo
Microsoft.URL
MIDown\tool
Mirror
Mister\PiX
Mozilla.*Indy
Mozilla.*NEWT
Mozilla*MSIECrawler
MS\FrontPage*
MSFrontPage
MSIECrawler
MSProxy
Navroad
NearSite
NetAnts
NetMechanic
NetSpider
Net\Vampire
NetZIP
NICErsPRO
Ninja
Nutch
Octopus
Offline\Explorer
Offline\Navigator
omgili
Openfind
PageGrabber
Papa\Foto
PaperLiBot
pavuk
pcBrowser
Ping
PingALink
Pockey
psbot
Pump
QRVA
RealDownload
Reaper
Recorder
ReGet
Scooter
Seeker
Siphon
sitecheck.internetseer.com
SiteSnagger
SlySearch
SmartDownload
Snake
sogou
Soso
SpaceBison
speedy
Spinn3r
sproose
Stripper
Sucker
SuperBot
SuperHTTP
Surfbot
Szukacz
tAkeOut
Teleport\Pro
URLSpiderPro
Vacuum
VoidEYE
Web\Image\Collector
Web\Sucker
WebAuto
[Ww]eb[Bb]andit
webcollage
WebCopier
Web\Downloader
WebEMailExtrac.*
WebFetch
WebGo\IS
WebHook
WebLeacher
WebMiner
WebMirror
WebReaper
WebSauger
Website
Website\eXtractor
Website\Quester
Webster
WebStripper
WebWhacker
WebZIP
Wget
Whacker
Widow
WWWOFFLE
x-Tractor
Xaldon\WebSpider
Xenu
Yandex
Yeti
YOUDAOBOT
Zeus.*Webster
Zeus
baiduspider
beta.statsit.com
statsit
SiteIntel
Yandex
GomezAgent
FunWebProducts
Nesotebot
DCPbot
AOL Advertising R&D
DataCha0s
aiHitBot
Apache-HttpClient
Zend_Http_Client
ReverseGet
XXX bot Content
vBSEO
spbot
OffByOne
thyroidbuzz
AcoonBot
coccoc
xpymep
proxyproxy2884
AppEngine
start.exe
Semiocast HTTP client
Firefox/3.6.23
TurnitinBot
curl
SwpLc/1.6
GrepNetstat.com
news bot
AskTbPTV
checks
panopta
App3le
PhantomJS
AlwaysOnline
SISTRIX
proximic
CRAWL-E/0.6.4
WebMoney
Maxthon
HTMLParser
oBot
UnisterBot
ERACrawler
Butterfly
Topsy
Butterfly Topsy Crawler
Ezooms
Deepnet
Alexa
Bitlybot
Seznam
Fulltext
Facebook
Sunrise Communications AG
crawl
Crawl
MJ12bot
Bimbot
Snapbot
thunderstone
Thunderstone
grub-client
Bing
MSN
OOZBOT
Wayback Machine
Crowsnest Spider
FlipboardProxy

Ghostt · #4 05-17-2014, 06:23 PM

very nice! i dont see this query anymore. and the big overload stopped

and theother query is ? someone know from what it is? its processing all the time every second many processes duration 2-30

PHP Code:


			
 Sorting result     SELECT thread.threadid, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount

thanks again kh99, you are the top supporter here

/edit
thanks CAG CheechDogg , i ll install that.

tbworld · #5 05-17-2014, 07:16 PM

Quote:

Originally Posted by Ghostt

thanks again kh99, you are the top supporter here

Thank you for thanking those that assist you!. The fat paychecks @kh99, @CAG-CheechDog receives is sometimes not enough - joking. We are all volunteers here.

Lynne · #6 05-17-2014, 07:24 PM

Do you any users set in AdminCP > Settings > Options > User Banning Options > Tachy Goes to Coventry? Try removing them and then see if you still have problems with that query.

Ghostt · #7 05-17-2014, 07:33 PM

no i dont have any users there. but 100 email provider in banlist.

@tbworld yes we honor your work

CAG CheechDogg · #8 05-17-2014, 09:20 PM

Quote:

Originally Posted by tbworld

Thank you for thanking those that assist you!. The fat paychecks @kh99, @CAG-CheechDog receives is sometimes not enough - joking. We are all volunteers here.

Wait ...what ! How comes I hasn't gottten' payed ! ...lol ...

But yes, we are all here to help each other out ...the more we help others the more we get help a well ...things just run smoother when we are all willing to help each other out ...

Ghostt · #9 05-18-2014, 01:02 PM

Here are 2 screenshots of phpmyadmin with that process.
this query is really all the time i refresh it...

http://imgur.com/Q3urvVn

http://imgur.com/E30I3Ez

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04346 seconds Memory Usage 2,258KB 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 (3)bbcode_php (2)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (9)post_thanks_box (4)post_thanks_box_bit (9)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (2)post_thanks_postbit (9)post_thanks_postbit_info (9)postbit (9)postbit_onlinestatus (9)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 tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

3 благодарности(ей) от:
Ghostt, kh99, tbworld

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!