The lagosaurus has been stomping on buildings and kicking puppies in our community for too long, so I finally did something about it. Let's just see if this anti-lagosaurus defense works...
General Background
The server had tons of things running at the same time, including the Apache Web server, the MySQL database server, Postfix email server, and a bunch of other necessities to get everything available for us to e-hang out.
Problem
As popularity grew, the two most used components of the physical server were the Apache Web server and the MySQL database server. They are needed for outputting all the webpages and getting all our community data, respectively. Both were competing for memory and processor power until the lagosaurus took advantage of the situation and brought things to a crawl during peak time (generally late evenings in the USA).
Solution
I've set up a new physical server and installed just the MySQL database server on it. Most databases are migrated to it right now, with just a few remaining. This divides the workload, like adding a second army to fight the lagosaurus. It's increasing hosting costs about $40/month, so let's hope ad revenue covers it!
Yep, I've noticed the slow opening of web pages while I was on. Even noticed that foul excuse of a prehistoric animal a few times. I was wondering why it was so laggy. Thanks for clearing this up.
i've been lagging horribly for days, even on a computer it would barely let me open pages, maybe because of my ping (i live in Brazil, the server is in Ohio, US.) now its working like a charm, the lagosaurus will be quiet for good now, i hope.
I liked how you said that the Lagosaurus was kicking puppies! xD
lol
And setting up a new server for MySQL sounds great.
Since you run your own servers, you CAN connect MySQL to other webservers with the PHP MySQL mysql_connect() function.
That's something hardly any free or even certain paid hosts offer.
Take advantage of it, Danny.
You earned it, bud.