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 Database Journal offers a few more details. Potentially more useful is this guide to query and index optimization (though it’s probably a little out of date).
mysql, mysql optimization, performance optimization, query optimization, slow query log, slow queries, high performance mysql
Related:
Posted February 13, 2006 by Casey
Categories: Technology. Tags: high performance mysql, mysql, mysql optimization, performance optimization, query optimization, slow queries, slow query log.
1 Comment(s)
Comments RSS
TrackBack Identifier URI
Leave a comment
User contributed tags for this post:
my cnf log slow queries (255) - log slow queries my cnf (164) - MySQL Log (157) - mysql log slow queries my cnf (147) - mysql log slow queries (132) - mysql slow query log my cnf (118) - log slow queries (94) - mysql log queries (73) - mysql query log (68) - my cnf slow query (67) - slow query log (62) - slow mysql (62) - mysql slow (61) - mysql slow query log (60) - mysql log query (57) - mysql slow query (54) - mysql slow log (54) - mysql slow queries (54) - my cnf log (47) - my cnf slow queries (46) - log slow query (45) - slow query log my cnf (44) - mysql log slow (39) - mysql slow queries log (36) - my cnf slow (36) - log slow queries mysql (34) - mysql is slow (33) - mysql log slow query (31) - mysql query log my cnf (31) - my cnf slow log (28) - my cnf query log (26) - mysql logging (26) - slow query my cnf (25) - mysql 5 slow (24) - mysql my cnf log (24) - mysql my cnf log slow queries (21) - mysql log my cnf (21) - slow query log mysql (20) - PLESK mysql log (20) - log slow queries mysql my cnf (20) - slow queries my cnf (19) - mysql 3 my cnf (19) - mysql 3 logs (19) - mysql slow query my cnf (17) - my cnf slow query log (17) - mysql log my cnf queries (17) - mysql 5 slow performance (17) - mysql log cnf (16) - mysql logging queries (16) - mysql 4 time query log (16) - mysql 4 log query (15) - mysql 4 log slow queries (15) - mysql slow query log my.cnf (15) - mysql slow query kill (15) - mysql query slow (15) - mysql log slow query my cnf (14) - mysql 5 log query (14) - my cnf log query (14) - log mysql (14) - mysql kill slow queries (14) - mysql query logging (14) - slow query (14) - my cnf log queries (13) - mysql log logging (13) - slow mysql query (13) - mysql how to log slow queries (12) - Mysql Running Slow PHP (12) - mysql 5 query log (12) - log slow query my cnf (12) - mysql query logs (12) - mysql slow logging (12) - mysql kill query (11) - my cnf long query time (11) - mysql 5 query slow (11) - slow query log mysql my cnf (11) - my cnf optimization (11) - mysql 4 slow queries (11) - my cnf log slow query (11) - mysql my cnf querylog (11) - mysql 5 my cnf log slow queries (10) - mysql my cnf log slow query (10) - my cnf high performance mysql server (10) - mysql 5 query (10) - mysql s (10) - mysql log all (10) - indiansex com (10) - mysql log query my cnf (10) - mysql 3 running slow (10) - mysql 5 query logging (10) - mysql log slow query index (10) - my cnf log slow (10) - mysql s in query (10) - mysql slow queries my cnf (10) - F (10) - mysql kill slow query (9) - mysql index log (9) - mysql optimization (9) - long query time my cnf (9) - slow queries mysql (9) - logging in mysql (8) - query log mysql (8) - mysql optimization query log (8) - slow query log cnf (8) - mysql 3 slow query log (8) - slow log (8) - my cnf logging (8) - mysql login slow queries (8) - kill mysql query (8) - my cnf log all mysql queries (8) - mysql log my (8) - log slow query mysql my cnf (8) - log slow queries var log mysql mysql slow log (8) - mysql log most slow query (8) - mysql enabling log log bin (8) - log queries mysql (7) - mysql 4 log (7) - log slow query mysql (7) - var log mysql mysql slow log (7) - How to log slow queries (7) - slow query logging (7) - mysql slow query logging my cnf (7) - log mysql queries (7) - slow mysql queries (7) - slow queries log my cnf (7) - mysql 4 optimization (7) - slow query mysql (7) - mysql long|slow commands|querys|queries (7) - slow log my cnf (6) - slow queries mysql my cnf (6) - mysql my cnf logging queries (6) - mysql slow query time out (6) - mysql my cnf log entry where (6) - slow query mysql index (6) - mysql query log 4 (6) - mysql my cnf logging (6) - mysql my cnf slow queries log (6) - enabling mysql logging (6) - slow log optimization (6) - log slow queries in mysql (6) - mysql get slow query log (6) - mysql server wont log slow queries (6) - mysql slow log my cnf (6) - mysql my cnf enable query log (6) - mysql log slow query time (6) - mysql 4 query log my cnf (6) - mysql log var (6) - time passing quote (5) - mysql slow query log tool (5) - slow log mysql (5) - mysql log slow my cnf (5) -
FYI I could only get this to work for me if I put those lines specifically in the [mysqld] section of the /etc/my.cnf file and also created the directory and touched the file making sure owner and group of the slow log file were mysql/mysql