Why You Should Not Rent an Unmanaged Server...
Submitted by Xaviar Xerexes on May 17, 2006 - 13:41
Oh Comixpedia - I can't watch you 24 hours a day. Why do you need to collapse on the floor in a puddle of too many MySQL connections when I'm not around to help?
I think somebody is screwing
by Joey Manley - 05/17/2006 - 14:57
I think somebody is screwing with "downtown-oriented" (to use Joe Zabel's term) webcomics-community sites on purpose. But that could be just my paranoia. I hired a guy to work on one of my unmanaged servers recently for exactly this problem -- he did some stuff to Apache, and did some stuff to MySQL, and now the server is running faster than ever before, and doesn't have these problems. He charged about $75 for the service. Pop me an email if you want his contact info.
Joey
www.webcomicsnation.com
Problem with MySQL, not hosting?
by Fabricari - 05/17/2006 - 14:28
I'm not terribly MySQL savvey, but I understand that there are connection limitations. It may not be the hosting that's the problem, but rather, the database. One possible work around might be some sort of caching. Even a short caching time, like 30 secs could make a huge difference.
You might also consider a different data-source, like Post-gres or Ms-sql?
Fabricari - Sexy Robots and Violent Cyberpunk Comics
Steve "Fabricari" Harrison
It was the MySQL
by Xaviar Xerexes - 05/17/2006 - 15:15
What happened this morning was too many connections which shut down the MySQL process. If I had Comixpedia on this morning I would have noticed and restarted it.
Not sure why there were too many connections though - could have been some kind of attack (been a lot of those in the last 2 months) or something else. If I have time I'll look at the logs tonight.
____
Xaviar Xerexes
I am a Modern Major Generality.
I run this place! Tip the piano player on the way out.
Are you still with
by djcoffman - 05/17/2006 - 14:10
Are you still with Dreamhost? -- I've never had a problem, even when linked from PA and American Idol fanboards.
Weird.
DJ Coffman
http://djcoffman.com
Not On Dreamhost Right Now
by Xaviar Xerexes - 05/19/2006 - 01:10
I decided to try a dedicated server. I"ll probably switch off of it soonner or later. I don't really need it and it's a huge pain. But I don't regret giving it a shot - I've learned a hell of a lot about APACHE and the command line.
____Xaviar Xerexes I am a Modern Major Generality.
I run this place! Tip the piano player on the way out.