different 5.0 and 5.1 about long_query_time

2009-12-11 Thread Yang Wang
Hi,All The version of 5.1 include microtime slow query patch? slow query log in version 5.1 __ # u...@host: root[root] @ localhost [] # Query_time: 0.94 Lock_time: 0.24 Rows_sent: 0 Rows_examined: 0

Re: different 5.0 and 5.1 about long_query_time

2009-12-11 Thread Jaime Crespo Rincón
2009/12/11 Yang Wang yw...@lfm-agile.com.hk: Hi,All   The version of 5.1 include microtime slow query patch? As of MySQL 5.1.21, the minimum value is 0, and a resolution of microseconds is supported when logging to a file. http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html Regards, --

Re: different 5.0 and 5.1 about long_query_time

2009-12-11 Thread carsten
On Fri, 11 Dec 2009 18:43:06 +0800, Yang Wang yw...@lfm-agile.com.hk wrote: Hi,All The version of 5.1 include microtime slow query patch? It would have taken you less time to google mysql long_query_time and getting your answer, than it did to write your mail... / Carsten --