Board logo

WEBSITE CRASHING
matt.c - 12/9/06 at 08:50 PM

Whats wrong with this website?

Every night it crashes at least once.

Does anyone else have this problem and does anyone know how to solve it?


Sorry for ranting on but this is doing my head in!


big_wasa - 12/9/06 at 08:52 PM

1) yep

2)No


very busy on a night ?


givemethebighammer - 12/9/06 at 08:52 PM

Doesn't crash on me but it has been very slow lately. I guess it's getting much more traffic these days (such is the price of fame)


rjs - 12/9/06 at 08:55 PM

Thought it was just mine or my NTL broadband.
No ideas


dilley - 12/9/06 at 08:55 PM

Tonight is really bad for me. I hate puters.


Hellfire - 12/9/06 at 09:03 PM

I'm having problems with Locostbuilders too. Then again, I've had a few problems over the last few days with Tiscali Broadband in general

God damned infuriating it is too

Phil


nicksertis - 12/9/06 at 09:03 PM

The boring answer is that there are too many connections for the database to handle, so it takes a while for it to reset and for you to get your page.

Nothing to do with your broadband or your computer, could be solved with a larger scale database solution.

Oh did I mention that I'm a web developer? I don't just know boring computer stuff because I'm a spod. Honest. ;o)


matt.c - 12/9/06 at 09:07 PM

Well cant someone get a larger scale database thingy?

Sorry but i know bu**er all about computer thingy's.


tks - 12/9/06 at 09:08 PM

to be able to handle more connections the server will need more memory
and / or CPU power..

Tks


nicksertis - 12/9/06 at 09:12 PM

That'd be upto Chris then I suppose?

warning : nerd talk follows ...

Chris, does the database use connection pooling? Haven't touched a MySQL database in a while but can (if you like) have a look at ways to improve on the default settings if you have access to the server? (Assuming of course that you are using the default settings)

HTH,
Nick

Added : Not necessarily tks, the number of connections is usually set as a predefined number, in order to save on memory etc. Increasing the number of connections allowed might not solve the problem if they aren't being recycled effectively. Normally changing the way the connections are shared does the trick.

[Edited on 12/9/06 by nicksertis]


Deckman001 - 12/9/06 at 10:17 PM

Maybe if ChrisW had time to, he could re aply the list of users logged on as well as visitors, then we could all see why it was so slow, not knocking it chris, just trying to let people see why it's acting slow

Jason


ch1ll1 - 13/9/06 at 10:38 AM

always lately


JoelP - 17/9/06 at 04:58 PM

i guess its time and money really, hopefully it will all get sorted one day cos it is damned annoying!


Guinness - 17/9/06 at 05:09 PM

I have noticed on a couple of other forums, that various sections are "sponsored" by various firms.

Robin Hood have sections sponsored by ebay, insurance companies, Maplin, RAC, AA etc:-

http://community.rhocar.org/index.php?s=a4302cc719ffd93c6587f781cc5e6fae&

And Pistonheads have a couple of them sponsored by Lotus:-

http://www.pistonheads.com/gassing/

Not sure that we would get Lotus to sponsor us? but most of my car came from ebay!

Autotrader / Free Ads - Donor Cars.

Ebay - Bargains Elsewhere.

I'm sure we could come up with a good list / package, then ask Chris to make contact with them?

Perhaps ChrisW could do the same, and raise some extra cash that way, for improvements / maintenance?

Mike


Gav - 17/9/06 at 08:13 PM

quote:
Originally posted by nicksertis
Tdoes the database use connection pooling?



iirc its PHP thats the problem, for each connection to the webserver a new connection is spawned on the db server, their is (or was) no way for PHP to pool connections as this would involve PHP keeping track of things, iirc their was some sort plugin module for it on sourceforge but i remember hearing it didnt work very well.


scotmac - 27/9/06 at 07:21 AM

The next release of oracle has a feature for php pooling on the svr sides that allows you to reuse php svr sessions/connections. Beta of it is out now. So, switch to oracle!!! ;-)


ned - 27/9/06 at 08:13 AM

problem is that Chris is always busy and would rather be making money (fair enough) and i think he must have lost interest as I gather his viento is gathering rust and has never been finished. He's hardly ever (if at all) on here anymore aswell

shame he won't let anyone else help out or run the site, I know a few have offered over the last year +

Ned.


chockymonster - 27/9/06 at 08:13 AM

quote:
Originally posted by scotmac
So, switch to oracle!!! ;-)


Do you fancy donating the license fee?


scotmac - 27/9/06 at 04:04 PM

quote:
Originally posted by chockymonster
quote:
Originally posted by scotmac
So, switch to oracle!!! ;-)


Do you fancy donating the license fee?


Sure...since it is free. Oracle has an "express" version (called XE), which is free to download and use. There are restrictions on what you can do w/ the express version, tho, so would have to make sure it would fit the requirements...