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
User contributed tags for this post:
optimize leopard (578) - optimizing leopard (263) - leopard performance tweaks (189) - leopard optimization (132) - optimize wifi (95) - wifi optimization (95) - MySql Performance Tweaks (92) - lamp optimization (83) - mysql hyperthreading (81) - leopard optimize (81) - MySQL performance optimization (72) - mysql performance tweak (72) - leopard speed tweaks (65) - leopard performance tips (65) - optimize wow (60) - php performance optimization (56) - Mysql performance tweaking (51) - wow performance tweaks (50) - tweak mysql (47) - wifi optimize (44) - mysql optimization (42) - Hyperthreading tweaks (42) - php5 optimization (41) - leopard performance tweak (38) - optimize lamp (35) - hyperthreading optimization (35) - optimizing wifi (35) - optimize hyperthreading (34) - optimize leopard performance (31) - tweak mysql performance (30) - how to optimize leopard (29) - hyperthreading tweak (29) - leopard speed tips (29) - optimize leopard for audio (28) - optimize wow performance (28) - tweak leopard performance (27) - optimizing WoW performance (26) - php mysql performance (25) - leopard performance optimization (25) - php mysql optimization (24) - tweak leopard (24) - optimizing lamp (23) - hyperthreading mysql (22) - mysql kill slow queries (22) - leopard optimizing (22) - leopard tweaks (22) - tweak hyperthreading (21) - optimizing wow (21) - wow optimize (21) - optimizing leopard performance (20) - mysql tweak (19) - tweaking mysql 5 (19) - optimizing leopard for audio (19) - Leopard Tweeks (19) - optimizing leopard tips (18) - mysql hyper threading (17) - hyper threading tweak (17) - wow performance tweak (17) - performance optimization (16) - lamp server optimization (16) - php performance tweak (15) - tweak php performance (15) - leopard slow (15) - php mysql slow (14) - optimize google maps (14) - tweaking leopard (14) - leopard tweak (14) - leopard optimizations (14) - php performance tweaks (13) - mysql 5 performance tweaks (13) - wow performance optimization (13) - time passing quote (12) - mysql slow performance (12) - php performance (12) - mysql5 performance (12) - tweaking leopard performance (12) - leopard performance (12) - mysql 5 slow performance (11) - tweak mysql 5 (11) - mySQL 5 performance (11) - optimize leopard speed (11) - performance leopard (11) - optimizing mac leopard (11) - mysql query last week (10) - tweaking mysql performance (10) - mysql 3 optimize (10) - mysql 5 performance optimization (10) - mysql 5 tweak (10) - about (10) - performance tweak leopard (10) - leopard speed tweak (10) - php optimizations (9) - WIFI Tweaks (9) - optimize hyper threading (9) - Mysql 5 tweaks (9) - LAMP Performance Optimization (9) - hyper threading tweaks (9) - HyperThreading optimize (9) - slow leopard (9) - leopard mysql performance (9) - mac leopard performance tweaks (9) - optimize leopard mac (9) - mac performance tweaks (9) - tweak WoW performance (8) - optimize leopard 2008 (8) - wordpress mysql optimization (8) - php hyperthreading (8) - mysql5 slow (8) - mysql tweak performance (8) - mysql kill optimize (8) - optimize lamp server (8) - F (8) - hyper threading optimization (8) - performance tweaks leopard (8) - optimization leopard (8) - mysql leopard performance (8) - mac leopard optimization (8) - optimize mac leopard (8) - performance tweaks for leopard (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) - tweak wifi (7) - lamp optimize (7) - mysql performance leopard (7) - leopard performance hacks (6) - mysql slow (6) - mysql slow query (6) - mysql slow query response (6) - performance tweaks mysql (6) - hyperthreading optimizations (6) - mysql optimizations (6) - mysql hyperthreading performance (6) - wifi performance tweaks (6) - optimization tweaks (6) - Hyperthreading Performance (6) - wordpress mysql performance (6) - mysql performance tips (6) - optimize wow mac (6) - tweak leopard speed (6) - mac leopard performance tweak (6) - mysql optimize (5) - google map optimization (5) -
Just wanted you to know that I’m trying to read this blog through Bloglines, but the new stuff isn’t showing up there. Dunno why. Frustrating.
[...] Zach suggested it last week, but it’s only now that I’ve gotten around to setting up MySQL’s slow query log. [...]
[...] Zach suggested it last week, but it’s only now that I’ve gotten around to setting up MySQL’s slow query log. [...]