OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
different 5.0 and 5.1 about long_query_time

From: Yang Wang (ywanglfm-agile.com.hk)
Date: Fri Dec 11 2009 - 04:43:06 CST

Hi,All

   The version of 5.1 include microtime slow query patch?



slow query log in version 5.1
__________________________________________________________________________________
# UserHost: 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
_______________________________________________________________
rootlocalhost:(none) 18:34:01>show variables like '%long%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| long_query_time | 10 |
+-----------------+-------+
1 row in set (0.01 sec)

rootlocalhost:(none) 18:35:41>select version();
+-----------+
| version() |
+-----------+
| 5.0.45 |
+-----------+
1 row in set (0.00 sec)
_________________________________________________________________



version 5.1.29
_______________________________________________________________
rootlocalhost:(none) 18:36:56>show variables like '%long%';
+-----------------+----------+
| Variable_name | Value |
+-----------------+----------+
| long_query_time | 2.000000 |
+-----------------+----------+
1 row in set (0.01 sec)

rootlocalhost:(none) 18:36:58>select version();
+---------------+
| version() |
+---------------+
| 5.1.29-rc-log |
+---------------+
1 row in set (0.00 sec)
______________________________________________________________






Best Regards!
Yang Wang

Email: ywanglfm-agile.com.hk