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 Matt said at 10:03 pm on March 20th, 2006:

    We had good luck with Lighttpd, but it eventually turned out to be too buggy and quirky for us to use in production. For WordPress.com and similar things we’ve moved over to Litespeed, which is a bit faster, but commercial.

  2. 2 Endurance . said at 2:12 pm on August 10th, 2006:

    Dear Sales,
    I’m highly interesting in purchase some items in your
    store which i will like to know if the items can be
    shipped to my address below by Overnight Delivering
    VIA any fastest courier services Dhl,Ups,Fedex..I will
    be paying you with my Credit card(Visa,Master )as a
    method of payment.

    Ship To:
    4210 Illinois Street,
    San Diego California,
    92104 CA, USA.

    If all this is accepted, kindly get back to me as soon
    as possible before i can proceed to go ahead with the
    order.Looking forward to hear from you soonest..
    With Regards,

    Endurance .

  3. 3 Endurance . said at 1:10 pm on August 28th, 2006:

    Dear Sales,
    I’m highly interesting in purchase some items in your store which i will like to know if the items can be shipped to my address below by Overnight Delivering VIA any fastest courier services Dhl,Ups,Fedex.I will be paying you with my Credit card(Visa,Master )as a method of payment.

    Ship To:
    4210 Illinois Street,
    San Diego California,
    92104 CA, USA.

    If all this is accepted, kindly get back to me as soon as possible before i can proceed to go ahead with the order.Looking forward to hear from you soonest.
    With Regards,

    Endurance .

  4. 4 visa master card said at 8:53 am on July 21st, 2007:

    visa master card…

  5. 5 Daniel said at 8:30 am on August 6th, 2007:

    I couldn’t understand some parts of this article y Rocks My PHP/MySQL World at Matt Croydon::Postneo, but I guess I just need to check some more resources regarding this, because it sounds interesting.

  6. 6 âûâîç ñòðîèòåëüíîãî ìóñîðà said at 12:28 am on August 23rd, 2009:

    âûâîç ñòðîèòåëüíîãî ìóñîðà…

    âûâîç ñòðîèòåëüíîãî ìóñîðà…

  7. 7 Rubin Worthington said at 11:09 am on September 23rd, 2010:

    “Anyway, I guess I’m a trifle off topic right here?.
    . Precisely.!!!. It seems to be like that! Ha, Ha, Ha.!!!.”

  8. 8 Chinese Zodiac said at 2:09 pm on October 13th, 2010:

    “There are definitely loads of specifics like that to require into consideration. Which is a wonderful place to provide up. I offer the thoughts above as common inspiration but clearly you will discover questions like the 1 you provide up where probably the most important point will likely be operating in truthful great faith. I don?t know if greatest practices have emerged approximately things like that, but I’m certain that your work is plainly recognized like a fair sport. In any case, in my language, there are not very much good source like this.”

  9. 9 Raymon Collister said at 3:28 am on November 14th, 2010:

    I was doing tria laser hair removal system applications for over a year at this point on my facial beard. Before this I had quite a thick dark beard. I’m pleased about the results. The hairs are very thin and I have not gone back for re-application in about six months. I am going to point out that it did hurt somewhat on my upper lip and there were definitely instances where I got some redness on my face. I suggest Intense pulsed light to those having thicker hairs or currently have large areas of hair they want to eliminate. For the males who want to do their tough facial beard be prepard to get patches within the coming several weeks and lots of people saying dude whats wrong with your beard.

  10. 10 Margarita said at 8:31 am on December 2nd, 2010:

    Just recently looked an breathtaking lodge in Seattle. Listed below it is, by the residence address and so which a person can try to find it quite easily : Sorrento Hotel | 900 Madison Street | Seattle | WA 98104-1297 | (206) 622-6400

  11. 11 darmowe porno said at 8:16 pm on January 20th, 2011:

    I have browsed most of your posts. This post is probably where I got the most useful information for my research. Thanks for posting, maybe we can see more on this. Are you aware of any other websites on this subject.

  12. 12 zamek w Å‚Ä™czycy said at 1:05 am on January 21st, 2011:

    Wow that was really interesting, altought i would add few more deeper thoughts

  13. 13 luxury car rental said at 3:25 pm on January 22nd, 2011:

    A cool blog post there mate ! Thanks for it !

  14. 14 filmy tube said at 6:57 pm on January 23rd, 2011:

    This post written here was absolutely creativity, both of which we all need . really did it for me is all the interaction among posters at such good info… had to say thanks again!

  15. 15 buy propecia said at 8:03 am on January 24th, 2011:

    Willingly I accept. The question is interesting, I too will take part in discussion.

  16. 16 outdoor wedding rental said at 7:45 pm on January 24th, 2011:

    This blog site is extremely cool. How can I make one like this !?

  17. 17 seo said at 1:18 pm on January 26th, 2011:

    This website is extremely good. How can I make one like this !?

  18. 18 reverse mobile phone directory said at 12:17 am on January 29th, 2011:

    How did you make a blog site look this awesome!? Email me if you get the chance and share your wisdom. I’d appreciate it!

  19. 19 cheap seo services said at 12:27 am on January 30th, 2011:

    Nice post. I learn something more challenging on different blogs everyday. It will always be stimulating to read content from other writers and practice a little something from their store. I’d prefer to use some with the content on my blog whether you don’t mind. Natually I’ll give you a link on your web blog. Thanks for sharing.

  20. 20 Last minute maroko said at 11:36 am on January 30th, 2011:

    hi,now, i saw this site,is good

  21. 21 teeth whitening results said at 5:00 am on January 31st, 2011:

    Hello! I just would like to give a huge thumbs up for the great info you have here on this post. I will be coming back to your blog for more soon.

  22. 22 eNflhMiH said at 10:23 am on February 1st, 2011:

    pGoHeiTh

  23. 23 Milton Ray said at 6:36 pm on February 2nd, 2011:

    there was something similiar to the posted on destr0yed.com take a look it might be of particular interest for your requirements

  24. 24 wpolscemamymocneseo said at 10:02 am on February 3rd, 2011:

    Do you want my webpage?

  25. 25 vyvoz stroitelnogo musora said at 7:26 am on February 4th, 2011:

    vyvoz stroitelnogo musora spb…

    vyvoz musora…

  26. 26 Last minute maroko said at 1:39 am on February 5th, 2011:

    wow… thanks a lot writing this

  27. 27 Willena Peniston said at 12:10 pm on February 5th, 2011:

    Can I make a suggestion? I feel youve acquired one thing good here. However what if you happen to added a pair links to a web page that backs up what youre saying? Or perhaps you probably can give us something to look into, something that would join what you are expressing to one thing touchable? Only a advice. Nevertheless, in my terms, there will not be a lot good supply like this.

  28. 28 Shila Moede said at 8:25 pm on February 5th, 2011:

    Valuable information. Lucky me I found your web site by chance, and I’m surprised why this twist of fate didn’t happened earlier! I bookmarked it.

  29. 29 Koh Samui Reseguide said at 11:08 pm on February 5th, 2011:

    continue with the the nice work on the site. I kinda like it! :) Could use some more frequent updates, but i am sure that you got some better or other things to do like we all do. :p

  30. 30 gun safes for sale said at 2:18 pm on February 7th, 2011:

    Amazing article, thanks, I will subscribe to you RSS soon!

  31. 31 dieta said at 2:38 pm on February 8th, 2011:

    You are very smart….

  32. 32 versacheck 2010 said at 11:13 pm on February 8th, 2011:

    I’ll bookmark this page… Thank you for sharing.

  33. 33 obsluga informatyczna Krakow said at 2:46 am on February 9th, 2011:

    I can see that you are an expert at your field! I am launching a website soon, and your information will be very useful for me.

  34. 34 pisanie prac said at 10:26 am on February 9th, 2011:

    Super diary! I actually enjoy how it is easygoing on my eyes and also the information are good scripted. I am questioning how I might be notified whenever a newborn post has been successful. I have signed to your rss feed which must make the trick! By!

  35. 35 Best Way to Lose Weight said at 10:31 am on February 11th, 2011:

    The post you made was awesome!

  36. 36 wyspy kanaryjskie said at 7:35 pm on February 11th, 2011:

    Great blog! I genuinely love how it is easy on my eyes as well as the info are well written.

  37. 37 oczyszczanie organizmu said at 8:10 am on February 12th, 2011:

    Thanks for taking the time to talk about this, I feel fervently about this and I take pleasure in learning about this topic. Please, as you gain information, please update this blog with more information. I have found it very useful.

  38. 38 dentysta Krakow said at 11:04 am on February 12th, 2011:

    There’s a tremendous amount of high-quality information throughout this post. I will be signing up to your rss feed.

  39. 39 driving instructor courses said at 4:03 pm on February 12th, 2011:

    This website is really good. How was it made !?

  40. 40 sterydy said at 7:56 pm on February 12th, 2011:

    Mate nice website, but there is a problem with it in firefox

  41. 41 paraprotex said at 7:05 am on February 14th, 2011:

    Now that’s what exactly I was looking for. If it is really working then you need applause. I’ll try running it and give you feedback.

  42. 42 Antoinette29Neal said at 8:01 pm on February 14th, 2011:

    Every one remembers that our life seems to be expensive, however we require money for different things and not every one earns big sums money. Thus to get quick loan or collateral loan will be a right way out.

  43. 43 Tory Burch Heel shoes said at 11:07 pm on February 14th, 2011:

    tory burch shoe sale …

    Tory Burch flip flop online sale.For the younger working expat women,look at these tory burch Shoes.these tory burch flip flops are definitely fun,yet the glossy design and round-toe stay these lovely.These tory burch shoes with multiple.New arrivel To…

  44. 44 Resor said at 6:08 am on February 15th, 2011:

    keep up the good work on the site. Do like it! :p Could use some more frequent updates, but i’m quite sure that you got other things stuff to do like we all do. =p

  45. 45 zero friction marketing said at 1:44 pm on February 15th, 2011:

    What would many of us do without the presence of the wonderful suggestions you reveal on this web site? Who else comes with the persistence to deal with critical topics in the interest of common subscribers like me? My spouse and i and my pals are very fortunate to have your website among the types we regularly visit. Hopefully you know how significantly we get pleasure from your work! Best wishes through us all.

  46. 46 Duphaston (Dydrogesterone) said at 6:17 pm on February 15th, 2011:

    What goes up must come down

  47. 47 paraprotex said at 7:43 pm on February 15th, 2011:

    I have bookmarked your site for future reference.

  48. 48 Fay Agreste said at 10:35 am on February 16th, 2011:

    mondo chart you own

  49. 49 Pozycjonowanie Szczecin said at 4:45 pm on February 16th, 2011:

    Cheers for your posting, that’s some very useful info. I’ll be back again to learn more, maintain publishing.

  50. 50 Willian Erdley said at 10:02 pm on February 16th, 2011:

    Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Thanks, thann Aldrege

  51. 51 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. =)

  52. 52 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.

  53. 53 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.

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

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

  55. 55 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.

  56. 56 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.

  57. 57 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.

  58. 58 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.

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

    jxmjfZOv

  60. 60 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?

  61. 61 Thanh Donath said at 6:49 am on February 21st, 2011:

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