Re: monitoring SQL query response times

2007-04-28 Thread Thomas van Gulick
Is there a way to monitor SQL query response times? Mysqlperformanceblog has patches for higher granularity query log: http://www.mysqlperformanceblog.com/2006/09/06/slow-query-log-analyzes-tools/ You could always just wrap the query calls in between some time registration of your own. --

monitoring SQL query response times

2007-04-28 Thread Masao Kitamura
Is there a way to monitor SQL query response times? Here's my current my.cnf relating to logs, but I only see response times in the slow query log, and even then, the response time is rounded to the nearest second. log=/logs/mysql.log log-error=/logs/mysql-error.log log-slow-queries=/logs/mysql-