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.000094 Lock_time: 0.000024 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:01>show variables like '%long%'; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | long_query_time | 10 | +-----------------+-------+ 1 row in set (0.01 sec) r...@localhost:(none) 18:35:41>select version(); +-----------+ | version() | +-----------+ | 5.0.45 | +-----------+ 1 row in set (0.00 sec) _________________________________________________________________ version 5.1.29 _______________________________________________________________ r...@localhost:(none) 18:36:56>show variables like '%long%'; +-----------------+----------+ | Variable_name | Value | +-----------------+----------+ | long_query_time | 2.000000 | +-----------------+----------+ 1 row in set (0.01 sec) r...@localhost:(none) 18:36:58>select version(); +---------------+ | version() | +---------------+ | 5.1.29-rc-log | +---------------+ 1 row in set (0.00 sec) ______________________________________________________________ Best Regards! Yang Wang Email: yw...@lfm-agile.com.hk
