I'm assuming your MySQL was on the same system? I have noticed that SourceMod likes to keep open MySQL users/sessions, and I have long since changed the code so that it opens and closes a MySQL connection when it needs to send a query, rather than keeping it open for the lifetime of the script. I went from having like 100+ connections to about 30 after the change. So that might have been the problem. As always you should run the latest version of stuff.
On Mon, 2009-08-31 at 15:23 -0400, Alec Sanger wrote: > The box was a Celeron 2.0 with 1GB. I can't remember exactly how many players > we were tracking, but I believe it was under 250,000. We had quite a few > websites running on the same box, though, so the stats may have just put it > over the edge. Once we removed them things were back to running like normal. > We were running 14 servers at the time. > > Thank you, > Alec Sanger > P: 248.941.3813 > F: 313.286.8945 > > > > > From: [email protected] > > To: [email protected] > > Date: Mon, 31 Aug 2009 14:58:08 -0400 > > Subject: Re: [hlds] L4D Stats recommendations > > > > Thanks for the recommendations to my stats. I of course have to agree, > > if you are looking for a L4D-specific stats plugin, I wrote my stats > > from the ground up with L4D in mind. > > > > I haven't had much time to work on this recently because of some Real > > Life issues, but I've been going back to it the past few weeks. I'm > > trying to get Survival and Versus stats working, and I have a basic > > admin panel working as well. The admin panel is useful because you can > > use it to generate a list of "bad players" based on behavior, and you > > can also prune older players from the player list which should decrease > > any slowdowns you might be experiencing. > > > > I'm curious what sort of hardware your webserver is running on which > > would make you think is slowing down. I'm using an ancient P3 1.8ghz I > > believe and there's almost no slowdown for me, and I had about 750,000 > > people in the database. > > > > > > On Fri, 2009-08-28 at 19:18 -0400, Alec Sanger wrote: > > > we used his stats for several months, but we started to see performance > > > issues with the websites hosted on the same box. Not a huge deal, just > > > slower website loads. Worked great until the db got huge. I would > > > definitely give it a shot to see if you like it. I was using early > > > builds, so it may have been optimized since then > > > > > > Thank you, > > > Alec Sanger > > > P: 248.941.3813 > > > F: 313.286.8945 > > > > > > > > > > > > > Date: Fri, 28 Aug 2009 15:53:46 -0700 > > > > From: [email protected] > > > > To: [email protected] > > > > Subject: Re: [hlds] L4D Stats recommendations > > > > > > > > I use msleeper's l4d stats plugin as well. It's easy to setup and works > > > > well. > > > > > > > > On Fri, Aug 28, 2009 at 3:45 PM, Rick Payton <[email protected]> > > > > wrote: > > > > > > > > > I 2nd this suggestion. It works with very minimal configuration, and > > > > > still provides plenty of "fun" data to look at - my favorite being the > > > > > death of zombies = to the population of various cities ... :) > > > > > > > > > > --mauirixxx > > > > > > > > > > -----Original Message----- > > > > > From: [email protected] > > > > > [mailto:[email protected]] On Behalf Of Nightbox > > > > > Sent: Thursday, August 27, 2009 9:35 PM > > > > > To: Half-Life dedicated Win32 server mailing list > > > > > Subject: Re: [hlds] L4D Stats recommendations > > > > > > > > > > msleeper rankign system ? > > > > > > > > > > 2009/8/28 Hyphon <[email protected]> > > > > > > > > > > > we are using HLstatsX. no problems till now. > > > > > > > > > > > > Ook <[email protected]> schrieb: > > > > > > > > > > > > >What are you L4D server operators using for L4D stats? I'm > > > > > > >currently > > > > > using > > > > > > >HLStats for my OP4 server, but it doesn't support L4D. I don't know > > > > > that I > > > > > > >like HLStatsx all that much, and am open to alternatives. > > > > > > > > > > > > > > > > > > > > >_______________________________________________ > > > > > > >To unsubscribe, edit your list preferences, or view the list > > > > > archives, > > > > > > please visit: > > > > > > >http://list.valvesoftware.com/mailman/listinfo/hlds > > > > > > > > > > > > _______________________________________________ > > > > > > To unsubscribe, edit your list preferences, or view the list > > > > > > archives, > > > > > > please visit: > > > > > > http://list.valvesoftware.com/mailman/listinfo/hlds > > > > > > > > > > > > > > > > > _______________________________________________ > > > > > To unsubscribe, edit your list preferences, or view the list archives, > > > > > please visit: > > > > > http://list.valvesoftware.com/mailman/listinfo/hlds > > > > > > > > > > _______________________________________________ > > > > > To unsubscribe, edit your list preferences, or view the list archives, > > > > > please visit: > > > > > http://list.valvesoftware.com/mailman/listinfo/hlds > > > > > > > > > _______________________________________________ > > > > To unsubscribe, edit your list preferences, or view the list archives, > > > > please visit: > > > > http://list.valvesoftware.com/mailman/listinfo/hlds > > > > > > _________________________________________________________________ > > > Hotmail® is up to 70% faster. Now good news travels really fast. > > > http://windowslive.com/online/hotmail?ocid=PID23391::T:WLMTAGL:ON:WL:en-US:WM_HYGN_faster:082009 > > > _______________________________________________ > > > To unsubscribe, edit your list preferences, or view the list archives, > > > please visit: > > > http://list.valvesoftware.com/mailman/listinfo/hlds > > > > > > _______________________________________________ > > To unsubscribe, edit your list preferences, or view the list archives, > > please visit: > > http://list.valvesoftware.com/mailman/listinfo/hlds > > _________________________________________________________________ > Windows Live: Make it easier for your friends to see what you’re up to on > Facebook. > http://windowslive.com/Campaign/SocialNetworking?ocid=PID23285::T:WLMTAGL:ON:WL:en-US:SI_SB_facebook:082009 > _______________________________________________ > To unsubscribe, edit your list preferences, or view the list archives, please > visit: > http://list.valvesoftware.com/mailman/listinfo/hlds _______________________________________________ To unsubscribe, edit your list preferences, or view the list archives, please visit: http://list.valvesoftware.com/mailman/listinfo/hlds
