A couple notes from the past few days of tweaks and fixes:

• Hyper-threading has a huge effect on LAMP performance.
   
• From now on, I’ll have bad dreams about running MySQL without Query Caching in the way that I used to have nightmares about going to school wearing only my underwear. The difference is that big.
   
• WordPress rocks, but it has some queries that will kill large databases. I’m playing with baseline when I fix ‘em, but it’s worth it.
   
• Being highly ranked for searches related to bears and bear lovers on the weekend that Grizzly Man airs on TV is both good and bad: it doubled my previous high for daily page-loads, but killed my server and taught me some lessons about sloppy coding.
   
• The support techs are Lunarpages continue to pretty much rock.
   
• Having friends who cut their teeth on high-performance PHP/MySQL and are willing to spend the night workshopping it with you is indispensable.
   
• It’s hard to beat the calming beauty of driving home through a snowfall on back roads at 2 AM carried by your life’s soundtrack.
   

lamp, mysql, php, server optimization, mysql optimization, server performance, hyperthreading, performance optimization

Posted February 7, 2006 by Casey Bisson
Categories: Technology. Tags: hyperthreading, lamp, mysql, mysql optimization, performance optimization, php, server optimization, server performance.

3 Comments

Comments RSS TrackBack Identifier URI

Leave a comment

Name (required)

Mail (will not be published) (required)

Website

 

User contributed tags for this post:

optimize leopard (553) - optimizing leopard (249) - leopard performance tweaks (176) - leopard optimization (126) - optimize wifi (95) - wifi optimization (95) - MySql Performance Tweaks (92) - mysql hyperthreading (81) - lamp optimization (78) - leopard optimize (77) - MySQL performance optimization (72) - mysql performance tweak (70) - leopard speed tweaks (62) - leopard performance tips (61) - optimize wow (52) - php performance optimization (50) - Mysql performance tweaking (48) - tweak mysql (47) - mysql optimization (42) - wifi optimize (42) - Hyperthreading tweaks (38) - leopard performance tweak (36) - hyperthreading optimization (35) - optimizing wifi (35) - optimize hyperthreading (34) - php5 optimization (32) - optimize lamp (30) - tweak mysql performance (30) - optimize leopard for audio (28) - leopard speed tips (28) - wow performance tweaks (28) - hyperthreading tweak (27) - optimize wow performance (27) - optimize leopard performance (26) - tweak leopard performance (26) - php mysql performance (25) - php mysql optimization (24) - tweak leopard (24) - how to optimize leopard (23) - leopard performance optimization (23) - mysql kill slow queries (22) - leopard optimizing (22) - leopard tweaks (22) - optimizing lamp (21) - hyperthreading mysql (20) - tweak hyperthreading (20) - optimizing leopard performance (19) - mysql tweak (19) - optimizing leopard tips (18) - optimizing WoW performance (18) - Leopard Tweeks (18) - tweaking mysql 5 (17) - performance optimization (16) - mysql hyper threading (16) - hyper threading tweak (16) - optimizing wow (16) - php performance tweak (15) - leopard slow (15) - optimizing leopard for audio (15) - php mysql slow (14) - optimize google maps (14) - lamp server optimization (14) - tweaking leopard (14) - wow performance tweak (14) - wow optimize (14) - php performance tweaks (13) - tweak php performance (13) - mysql 5 performance tweaks (13) - leopard tweak (13) - leopard optimizations (13) - time passing quote (12) - mysql slow performance (12) - php performance (12) - tweaking leopard performance (12) - leopard performance (12) - mysql 5 slow performance (11) - mySQL 5 performance (11) - optimize leopard speed (11) - performance leopard (11) - mysql query last week (10) - tweaking mysql performance (10) - mysql 3 optimize (10) - mysql 5 performance optimization (10) - mysql 5 tweak (10) - mysql5 performance (10) - performance tweak leopard (10) - wow performance optimization (10) - leopard speed tweak (10) - php optimizations (9) - optimize hyper threading (9) - tweak mysql 5 (9) - LAMP Performance Optimization (9) - hyper threading tweaks (9) - slow leopard (9) - leopard mysql performance (9) - mac leopard performance tweaks (9) - optimizing mac leopard (9) - mac performance tweaks (9) - tweak WoW performance (8) - optimize leopard 2008 (8) - wordpress mysql optimization (8) - php hyperthreading (8) - WIFI Tweaks (8) - mysql5 slow (8) - mysql tweak performance (8) - mysql kill optimize (8) - Mysql 5 tweaks (8) - optimize lamp server (8) - about (8) - F (8) - performance tweaks leopard (8) - optimization leopard (8) - optimize leopard mac (8) - hyper threading for leopard (8) - hyperthreading mysql performance (7) - google maps optimization (7) - Hyper Threading mysql (7) - mysql kill slow query (7) - mysql performance solaris (7) - php performance and (7) - optimize PHP performance (7) - HyperThread Tweak (7) - Optimize Wi Fi (7) - hyper threading optimization (7) - lamp optimize (7) - mysql leopard performance (7) - mysql performance leopard (7) - performance tweaks for leopard (7) - mysql slow (6) - mysql slow query (6) - mysql slow query response (6) - hyperthreading optimizations (6) - mysql optimizations (6) - mysql hyperthreading performance (6) - wifi performance tweaks (6) - optimization tweaks (6) - Hyperthreading Performance (6) - tweak wifi (6) - wordpress mysql performance (6) - mysql performance tips (6) - mac leopard optimization (6) - optimize wow mac (6) - mac leopard performance tweak (6) - leopard performance hacks (5) - mysql optimize (5) - performance tweaks mysql (5) - google map optimization (5) - mysql hyperthreading slow (5) - php mysql performance optimization (5) - wifi performance optimization (5) -