Busy making things: tinycast, github, links, photos, @mc.

Lighty Rocks My PHP/MySQL World

Posted: March 19th, 2006 | Author: | Filed under: Linux, MySQL, PHP, Web Services | 61 Comments »

A few weeks ago I was tasked with moving boards.kusports.com 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 Comments on “Lighty Rocks My PHP/MySQL World”

  1. 1 Paketresorna said at 2:11 am on February 17th, 2011:

    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. 2 Hipolito M. Wiseman said at 2:49 am on February 17th, 2011:

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

  3. 3 Columbus Goldrich said at 7:49 am on February 17th, 2011:

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

  4. 4 Burton Haynes said at 9:46 am on February 17th, 2011:

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

  5. 5 Issac Maez said at 5:06 pm on February 17th, 2011:

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

  6. 6 Digiturk Lig tv izle said at 9:16 pm on February 17th, 2011:

    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. 7 Matthew C. Kriner said at 9:47 pm on February 17th, 2011:

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

  8. 8 dance dvd workout said at 10:52 am on February 18th, 2011:

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

  9. 9 oGuYld said at 8:31 pm on February 18th, 2011:

    jxmjfZOv

  10. 10 watercress recipes said at 11:21 pm on February 18th, 2011:

    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. 11 Thanh Donath said at 6:49 am on February 21st, 2011:

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