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" 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 -- MySQL General M

Re: different 5.0 and 5.1 about long_query_time

2009-12-11 Thread Jaime Crespo Rincón
2009/12/11 Yang Wang : > 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, -- Jaime Crespo MyS

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 SET