The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
HELP: Huge number of simultaneous connections to the db server
My forum is running very slowly and even after disabling all plugins. The issue seems to be stemming from the huge number of connections that are being made to the database server. Currently there are over 5000 simultaneous connections and while there are only about 65 PHP processes, these are taking up a large amount of resources - possibly because of poor queries being made to the MySQL server.
I did check the queries that are running on MySQL and they are not running slowly - the server is responding well, but the forum server is just opening so many connections for whatever reason. Can I get some assistance on this? My forum version is 3.8.7. Tks. --------------- Added [DATE]1380994648[/DATE] at [TIME]1380994648[/TIME] --------------- i've checked google analytics and it reports only 80 concurrent users. Though on my forum homepage, it reports 20000 current active users, most of which are guests. |
#2
|
||||
|
||||
A link might help
|
#3
|
|||
|
|||
What do you see in Who's Online (with it set to see guests)? Recently I saw on my little forum about quarter of the users were a(?) guest(s) all viewing the same thread with the same browser. All I remember of the user agent is it was Mozilla 4 and MSIE.
|
#4
|
||||
|
||||
This is what I see right now:
Currently Active Users: 21729 (107 members and 21622 guests)This looks suspiciously like a DDoS attack. It might also be some Baidu bombing, do you block bad spiders? |
#5
|
|||
|
|||
Install this will help with all them bad bots
|
2 благодарности(ей) от: | ||
CAG CheechDogg, Max Taxable |
#6
|
|||
|
|||
My server admin checked and it doesn't seem like its a ddos. All the connections are started internally within the site, so it's vb that is opening all the connections.
What is Baidu bombing? |
#7
|
||||
|
||||
What you are dealing with is a ton of bots, spiders, search engines crawling your forums all at the same time.
What do you have your session timeout set at? If you have it really high it would be a good indication of why you have so many guests in your whos online. using Simon Lloyd's Ban Spiders by User Agent will help you a lot to help combat this. You will also have to use some IP blocks in your htaccess to stop Chinese bots from hitting your site, which is what Baidu is , they just don't care about rules and will just hit your site or forums like they are going out of style. You should have this taken cared of in a couple of hours, if you need help let me know, take a look at this thread to help you more if you feel you can do what we did for Dave's website. https://vborg.vbsupport.ru/showthrea...53#post2448953 |
#8
|
|||
|
|||
tks everyone. am thinking of installing the ban spiders plugin as recommended. however, i've no idea what to ban or who. how shld i approach this problem?
and what is a recommended session timeout setting? mine is currently set at 7200 |
#9
|
||||
|
||||
Once you install the mod you can replace the default list with this one :
Please note that I block facebook, MSN, Bing, Alexa and a couple others that you might not want to block, just remove them from the list and you are good to go .... 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 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 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 Sunrise Communications AG crawl Crawl MJ12bot Bimbot Snapbot thunderstone Thunderstone grub-client Bing MSN |
2 благодарности(ей) от: | ||
Disco_Dave, jl255 |
#10
|
|||
|
|||
Tks alot dude. Have installed and activated it using the list you recommended without Bing, MSN and Alexa. Let's see if it works.
One thing i don't understand is why like this all of a sudden?? |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|