mySQL errors and theme/tech sites

Sunday, September 15, 2002 by geekboy2000 | Discussion: WinCustomize Talk

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.
Jafo
Reply #1 Sunday, September 15, 2002 9:09 PM
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...
geekboy2000
Reply #2 Sunday, September 15, 2002 10:38 PM
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.
WOM
Reply #3 Sunday, September 15, 2002 10:41 PM
I love your analogy Mark.

Powered by SkinBrowser!
paxx
Reply #4 Monday, September 16, 2002 5:41 AM
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. :/
T-Man
Reply #5 Monday, September 16, 2002 9:44 AM
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.
geekboy2000
Reply #6 Monday, September 16, 2002 11:06 AM
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!

Please login to comment and/or vote for this skin.

Welcome Guest! Please take the time to register with us.
There are many great features available to you once you register, including:

  • Richer content, access to many features that are disabled for guests like commenting on the forums and downloading skins.
  • Access to a great community, with a massive database of many, many areas of interest.
  • Access to contests & subscription offers like exclusive emails.
  • It's simple, and FREE!



web-wc01