Lighty Rocks My PHP/MySQL World



, , ,

A few weeks ago I was tasked with moving from an old, overloaded XServe to a newly appropriated Xeon box. The boards were notorious for going down after big games and during big news events and usually took other things on the same server down with them.

Thankfully that is no more. A week or so before the Big 12 and NCAA tournaments we finally bit the bullet and committed some time to move the boards over to their own box with more horesepower and more RAM.

I put the ubuntu-server version of Breezy Badger on the box and took the opportunity to see if I could get UBB Threads running under lighttpd and php fast-cgi. I’m glad that I took the time, because it’s smoking fast.

The process was quite painless thanks to the Ubuntu packing system. I had to build lighttpd by hand but everything else was installable with command-line tools (aptitude/apt-get). The changeover process consisted of little more than shutting down the boards on the old box, doing a dump/restore of the database to the new server, updating DNS entries and issuing temporary redirects to get the board users through the day.

The best thing about the conversion is that lighttpd, mysql, and php-fcgi barely register any load on the server, even at peak usage. While we were scrambling with stom coverage the other weekend, the boards box quietly registered a new high water mark for usage. After a painful first-round loss in the NCAA tournament, the boards registered yet another high water mark (1134 simultaneous users). The server barely flinched with a load anywhere from 0.00 to 0.20 with plenty of resources free. Previously a third of that number could potentially bring the XServe to its knees.

While we were turbocharging things, I also installed eAccelerator on the box, which was equally painless and yielded about a 20-30% performance increase.

All in all I’m gaga over lighty, mysql, and php-fastcgi for when the situation warrants it. It really is insanely fast. At the same time I’m really glad that I work in Python all day.


61 responses to “Lighty Rocks My PHP/MySQL World”

  1. Paketresorna Avatar

    keep up the good work on the blog. I love it. Could use some more frequent updates, but i am sure that you got more or better stuff to do like we all do. =)

  2. Hipolito M. Wiseman Avatar

    I come from India. Great blog.Hi I am from Iran. Keep on the good work.

  3. Columbus Goldrich Avatar

    This website is awesome. I continuously encounter some thing new & different right here. Thank you for that data.

  4. Burton Haynes Avatar

    Hi buddy, very informative post. Please keep them coming. Thanks, ssie Wollyung

  5. Issac Maez Avatar

    I come from Mexico. Great blog.Hi I am from Iraq. Keep on the good work.

  6. Digiturk Lig tv izle Avatar

    Hello, I found your blog site in a brand new directory of blogs. I dont know how your blog page came up, need to have been a typo, Your blog site appears good. Have a good day.

  7. Matthew C. Kriner Avatar

    Hi I am from Iraq. I wish their would be more blogs like this one.

  8. dance dvd workout Avatar

    A little off topic perhaps, but anyways – which template have you been utilizing? I truly really like the CSS design.

  9. oGuYld Avatar


  10. watercress recipes Avatar

    This site wasn’t working yesterday. i attempted accesing it however it timed out 3-4 times now but i will can get on now. Why did this occur? Am i the only one having one of these error?

  11. Thanh Donath Avatar

    Thank you for this intresting article. :-)ight Calvary