List:General Discussion« Previous MessageNext Message »
From:Yang Wang Date:December 11 2009 10:43am
Subject:different 5.0 and 5.1 about long_query_time
View as plain text  
Hi,All

   The version of 5.1 include microtime slow query patch?



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

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



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

root@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: ywang@stripped
Thread
different 5.0 and 5.1 about long_query_timeYang Wang11 Dec
  • Re: different 5.0 and 5.1 about long_query_timeJaime Crespo Rinc√≥n11 Dec
  • Re: different 5.0 and 5.1 about long query timecarsten11 Dec