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 timestamp=1260514025;
UPDATE gamesession  SET session_expires = '1260515825', session_data = 
'ljuser|s:13:chenqingji008;task|s:2:52;' WHERE session_id = 
'79bfdd9840bdf4cdb19d19ff90dc0643';



version 5.0.45
___
r...@localhost:(none) 18:34:01show variables like '%long%';
+-+---+
| Variable_name   | Value |
+-+---+
| long_query_time | 10|
+-+---+
1 row in set (0.01 sec)

r...@localhost:(none) 18:35:41select version();
+---+
| version() |
+---+
| 5.0.45|
+---+
1 row in set (0.00 sec)
_



version 5.1.29
___
r...@localhost:(none) 18:36:56show variables like '%long%';
+-+--+
| Variable_name   | Value|
+-+--+
| long_query_time | 2.00 |
+-+--+
1 row in set (0.01 sec)

r...@localhost:(none) 18:36:58select version();
+---+
| version() |
+---+
| 5.1.29-rc-log |
+---+
1 row in set (0.00 sec)
__






Best Regards!
Yang Wang

Email: yw...@lfm-agile.com.hk

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,
-- 
Jaime Crespo
MySQL  Java Instructor
Warp Networks
http://warp.es

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

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



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org