Zach suggested it last week, but it’s only now that I’ve gotten around to setting up MySQL’s slow query log.
It’s easy enough, you’ve just got to put a couple lines like this in your my.cnf (which is in /etc on my server):
log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 10
This should get most people running, but this story in [...]
Posted February 13, 2006 by Casey Bisson
Categories: Technology. Tags: high performance mysql, mysql, mysql optimization, performance optimization, query optimization, slow queries, slow query log. One Comment.
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 [...]
Posted February 7, 2006 by Casey Bisson
Categories: Technology. Tags: hyperthreading, lamp, mysql, mysql optimization, performance optimization, php, server optimization, server performance. 3 Comments.
