Universal Videogame List - www.uvlist.net

Database overloaded

posted in bugs

threads list     
by Sanguine
# 6 months and 22 days ago
These are unfortunately frequent for me:
Could not connect: Too many connections
Please stand-by for a while and retry.

I suggested a solution here, but it seems to have been missed. The mysql_pconnect() function.

(Also, moving from PHP to some other language and FastCGI should improve the site's performance, may require a bit too much of effort to accomplish though.)
by teran01
# 6 months and 22 days ago
I also experience problems with the site not reacting for a few minutes sometimes. I never get an error message though.
by Sanguine
# 6 months and 22 days ago
For other improvements on performance, if the gzip/deflate thing is in use, I'd suggest using compression level 2 over anything higher. The system resources needed to accomplish anything higher go way over the benefits in compression ratio.
by andread
# 6 months and 22 days ago
I did a lot of optimizations, for example caching the most common (or the heaviest) results, reducing dramatically the overall number of queries.
Sadly the reason for these problems is different.

The real problem is that the web server is hosting another site that has seven times the activity of UVL.
What's worse, it isn't a finely coded site, but a junk made using Php-Nuke CMS, so that "seven" should multiplied by 4 at least..
Junk ... I'm playing Wii Scarface these days so my dictionary is full of Tony Montana words-style, I'm doing my best to be polite ;-)

The obvious "next step" should be to find a better hosting solution, but the server and "that" site is maintained by a my colleague, and he is finely rewriting it from scratch, using another database engine (I designed the new graphics too, and this pays the UVL hosting) so when ready, I'm quite sure this choppiness will end.

I would love to have a my own server, but I've no idea how to properly configure a web server, and right now the bandwidth used is 40 gigabyte / month (and growing).
I've not yet found a good hosting solution with so much bandwidth and a "we'll configure and manage it for you" at an accessible price...

I'm sorry for these inconveniences.
by andread
# 6 months and 12 days ago
I've just (insanely) signed for a MY OWN web account at www.hostmonster.com
PHP5, FastCGI and a ton of features... Can't wait to see how it behaves.
threads list     
Welcome new user!

You can create a free account to vote, review, tag games, add images, view galleries and more.
login:
password:
Forum search
forum threads

Select your language





DISCLAIMER: All image galleries, logos and names are property of the respective authors - This site doesn't make use nor permits the download of copyrighted material such as ISO, game roms, software, music, movies or similar. The site is primarily based on reviews, screenshots and various game details. - Please contact me if you believe your work has been used in a way that may constitute copyright infringement.