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
User contributed tags for this post:
optimize leopard (590) - optimizing leopard (267) - leopard performance tweaks (211) - leopard optimization (144) - lamp optimization (99) - wifi optimization (98) - optimize wifi (95) - MySql Performance Tweaks (93) - leopard optimize (85) - mysql hyperthreading (82) - mysql performance tweak (76) - MySQL performance optimization (72) - leopard speed tweaks (71) - php performance optimization (70) - leopard performance tips (68) - optimize wow (63) - php5 optimization (58) - wow performance tweaks (54) - Mysql performance tweaking (51) - tweak mysql (47) - wifi optimize (44) - Hyperthreading tweaks (43) - mysql optimization (42) - optimize lamp (41) - leopard performance tweak (38) - optimize leopard for audio (37) - optimizing WoW performance (37) - optimizing wifi (36) - optimize leopard performance (35) - hyperthreading optimization (35) - optimize hyperthreading (34) - tweak mysql performance (32) - optimize wow performance (32) - leopard speed tips (32) - hyperthreading tweak (31) - tweak leopard performance (31) - how to optimize leopard (30) - optimizing leopard performance (25) - php mysql performance (25) - optimizing lamp (25) - leopard performance optimization (25) - php mysql optimization (24) - tweak leopard (24) - optimizing wow (24) - optimizing leopard for audio (23) - hyperthreading mysql (22) - mysql kill slow queries (22) - leopard optimizing (22) - leopard tweaks (22) - wow optimize (22) - tweak hyperthreading (21) - wow performance tweak (21) - tweaking mysql 5 (20) - Leopard Tweeks (20) - mysql tweak (19) - optimizing leopard tips (18) - mysql hyper threading (18) - lamp server optimization (17) - hyper threading tweak (17) - performance optimization (16) - tweak php performance (16) - wow performance optimization (16) - php performance tweak (15) - leopard slow (15) - leopard optimizations (15) - php mysql slow (14) - optimize google maps (14) - mysql 5 performance tweaks (14) - tweaking leopard (14) - leopard tweak (14) - WIFI Tweaks (13) - mysql 5 slow performance (13) - php performance tweaks (13) - tweak mysql 5 (13) - mysql5 performance (13) - tweaking leopard performance (13) - optimize leopard speed (13) - mysql slow performance (12) - php performance (12) - leopard performance (12) - tweaking mysql performance (11) - Mysql 5 tweaks (11) - mySQL 5 performance (11) - LAMP Performance Optimization (11) - HyperThreading optimize (11) - performance leopard (11) - optimizing mac leopard (11) - tweak WoW performance (10) - mysql query last week (10) - mysql 3 optimize (10) - mysql 5 performance optimization (10) - mysql 5 tweak (10) - hyper threading optimization (10) - lamp optimize (10) - performance tweak leopard (10) - optimization leopard (10) - mysql leopard performance (10) - leopard mysql performance (10) - optimize leopard mac (10) - mac performance tweaks (10) - leopard speed tweak (10) - wordpress mysql optimization (9) - php optimizations (9) - optimize hyper threading (9) - mysql5 slow (9) - hyper threading tweaks (9) - slow leopard (9) - mac leopard performance tweaks (9) - optimize mac leopard (9) - performance tweaks for leopard (9) - optimize leopard 2008 (8) - php hyperthreading (8) - mysql tweak performance (8) - mysql kill optimize (8) - optimize lamp server (8) - F (8) - performance tweaks leopard (8) - mysql performance leopard (8) - mac leopard optimization (8) - hyper threading for leopard (8) - leopard performance hacks (7) - 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) - leopard tweak performance (7) - 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) - php performance optimize (6) - wordpress mysql performance (6) - mysql performance tips (6) - speed tweaks for leopard (6) - leopard tweaks performance (6) - wow performance tips (6) -
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. [...]