geekboy2000

Join Date 09/2001

mySQL errors and theme/tech sites

What is it with mySQL? Is it the traffic on these sites that brings mySQL to it's knees or the other way around? Neowin used to suffer from it, now ThemeXP regularly spits out mySQL erros, and ieXbeta is now similarly affected. If a site can't stand the traffic, why can't it be configured to simply be slow? That's bad enough, put presenting the viewer with a string of errors looks like sh*t.

Locked Post

Advanced Search

Watch this post

Do not email me updates for this post Email me updates for this post

Successfully updated karma reason!

Jafo

Join Date 03/2001

+1845

Mark....graphics and skinning sites are very demanding on bandwidth, and sites as hugely popular as Wincustomize have considerably more than just one or two people downloading 'stuff' at any one time...

Successfully updated karma reason!

I understand that, but I've never seen that kind of error here at WC, so I was wondering about these "other guys", and why they can't run a site/database that doesn't spew errors when it gets overloaded. It's as if a truck is overloaded with weight. Okay fine, run slow, stall out, but don't shoot parts through the hood.

Successfully updated karma reason!

WOM

Join Date 01/2002

+253

I love your analogy Mark.

Successfully updated karma reason!

Sign Up or Login and this ad disappears!
There are many great features available to you once you register. Sign Up for a free account and browse the forums without ads.

Well, for one, those site may not have the budget that Wincusto have. MySQL is free and good enough for modest web sites but is not made to handle hundreds of simultaneous connections (I think it's limited to 100 and some). MS SQL used for this site is very expensive.
And lets not forget that errors happen. I've seen a few time the infamous error "Maximum number of connection reached. Please contact your administrator" (or something like that) a few times even here.
Sometimes websites are victims of their success and being popular is not always good. :/

Successfully updated karma reason!

Though I am not familar with mySQL or PHP, I do know that in ASP trying to code error handling is not very simple. You put in error handling when you know you absolutely need it or until you find something that comes up often.

So initially I could understand why the error message would turn up. But after it coming up enough you would hope that they would attempt to but in some error handling around it.

And yes, WinCustomize has had its share of errors display. I try to keep on top of them and fix them as soon as possible but they still slip through from time to time.

Successfully updated karma reason!

I think that what I see most often is the connection limitation. I suppose they're trying to run as lean and mean as possible, but sometimes exceed the number of connections allowed by the license. Thanks all for the info!

Successfully updated karma reason!