TranceAddict Forums

TranceAddict Forums (www.tranceaddict.com/forums)
- Chill Out Room
-- Goin Down...


Posted by DjSimonB on Sep-27-2004 21:58:

Goin Down...

Anyone else noticing TA go slow/grind to a halt almost every day? Like, database errors and such. Or is it just me


Posted by jp on Sep-27-2004 21:59:

There are just too many of us online


Posted by nchs09 on Sep-27-2004 21:59:

j00 is smokin the cr4ck f00l!


Posted by D-res on Sep-27-2004 22:03:

it does seem to be going slower than before and i do get some 'SQL database errors' or soemthign quite often. i dont know. sometimes it takes up to 4 minutes to load a thread, and i have 3 megabit internet cable connection


Posted by Sand Leaper on Sep-27-2004 22:04:

Yea, same thing over here too. Guess you just have to live with it when TA is as huge as it is.


Posted by enferno on Sep-27-2004 23:00:

pff . . i thought this was going to be anotha vagina thread


Posted by Rodrico on Sep-27-2004 23:12:

quote:
Originally posted by enferno
pff . . i thought this was going to be anotha vagina thread


yeah, I thought so too, god damn tricky titles..


Posted by trancebrat on Sep-27-2004 23:16:

quote:
Originally posted by Rodrico
yeah, I thought so too, god damn tricky titles..



You're back!!!


Posted by Rodrico on Sep-27-2004 23:21:

quote:
Originally posted by trancebrat
You're back!!!


With my own internet in my own house...so im back for good.


Posted by DjSimonB on Sep-28-2004 17:04:

quote:
Originally posted by Rodrico
yeah, I thought so too, god damn tricky titles..


Nothing wrong with making your thread titles a bit ambigously sexual


Posted by DJ_Bod on Sep-28-2004 17:19:

quote:
Originally posted by jp
There are just too many of us online


that's my guess.


Posted by Swamper on Sep-28-2004 19:25:

quote:
Originally posted by josh4
The user base is getting too big for the servers running TA. This site is getting more and more popular. Pretty soon they may have to upgrade their plan with whoever hosts the site or move to another host.

I keep getting a frequent error message from the boards saying there are too many connections.


Not exactly - I just upgraded hardware a few weeks ago.

Running a 64k chunk size on the raid array seems to have offered little performance increase over the 32k it was at before -- using thttpd (a lightweight webserver) to handle image loading (instead of relying on resource-heavy Apache) allows me to turn Keepalive on -- meaning that when you connect to the server to get an image it keeps that connection open knowing that you'll soon request more images - rather than closing it after serving 1 image and re-opening it for each subsequent request.

Now, by freeing up Apache in this way (which used to bottleneck with excessive image/database/page requests) I now have a situation where incoming forum requests (Threads/posts/searches) can be queued in a greater number -- thereby causing bottlenecks on the database end more frequently.

I'm gonna change a couple of other things tonight and see what happens, but that's it in a nutshell.


Posted by nchs09 on Sep-28-2004 19:29:

swampah is t3h n3rd!


Posted by ShadoWolf on Sep-28-2004 21:25:

Re: Goin Down...

quote:
Originally posted by DjSimonB
Anyone else noticing TA go slow/grind to a halt almost every day? Like, database errors and such. Or is it just me


the internet has sucked ass since the year 2000


Posted by DiMethGuy on Sep-28-2004 21:50:

things are going uber slow on here today...last week has been pretty sluggish actually. which is disappointing cause for the couple days after swampie made some upgrades things were great...now were back into dial up speeds


Posted by fitom tiel on Sep-28-2004 21:58:

yeah i like going down


Posted by Swamper on Sep-28-2004 22:15:

quote:
Originally posted by DiMethGuy
things are going uber slow on here today...last week has been pretty sluggish actually. which is disappointing cause for the couple days after swampie made some upgrades things were great...now were back into dial up speeds


Search is the problem - it KILLS everything.

So, for now, search results will be current as of 5AM (GMT -0500) that day - I'll look towards updating it so it has at most a 6 or 12 hour lag time.. we'll see how it goes - this is the easiest way to remove bottlenecking for now.


Posted by idoru on Sep-28-2004 22:22:

quote:
Originally posted by Swamper
Search is the problem - it KILLS everything.

So, for now, search results will be current as of 5AM (GMT -0500) that day - I'll look towards updating it so it has at most a 6 or 12 hour lag time.. we'll see how it goes - this is the easiest way to remove bottlenecking for now.


I thought it might be the search.

And yes, it's going damn slow. One minute and thirty seconds to go from page one to page two of this topic, on 4mbps.


Posted by Xenocreator_PG_ on Sep-28-2004 22:34:

I like it when the chicks start grinding on your chin!


Posted by Swamper on Sep-29-2004 00:03:

quote:
Originally posted by josh4
Well its not just the boards, the whole site is experiencing it. I mean you got the Unknown Tracks forum with the MP3s, the Music Videos, Live Sets, sheesh. I can't imagine what kind of bandwidth you must need. There are also connections coming from all over the world from Japan to Europe to North and South America.


Those are all non-factors, the slowdown comes from bottlenecking which occurs when the database is bogged down and can't send back results to the clients requesting them, meaning, hung web processes while people wait in their browsers to get the info they wanna see...

The downloads are load balanced across 4 servers and the unknown tracks section has mp3s streamed out (and they're small samples) so it is not a big deal...


Posted by smokeape on Sep-29-2004 00:18:

Damn, that might be true. After I ran a search for my post whoring, the damn thing shut down for a minute. Swamper is the man.


[[[smoke]]]

Audio Sweet - Sunshine After the Rain (Club Mix)


Posted by Sand Leaper on Sep-29-2004 13:32:

Hmm would it be possible to find another host for the search engine so that the forums don't suffer performancewise?


Posted by Swamper on Sep-30-2004 14:53:

Things should be faster now, yes?


Posted by Technaut on Sep-30-2004 14:55:

roger that



Powered by: vBulletin
Copyright © 2000-2021, Jelsoft Enterprises Ltd.