different 5.0 and 5.1 about long_query_time

------=_NextPart_000_010C_01CA7A91.C72C5B60
Content-Type: text/plain;
charset="gb2312"
Content-Transfer-Encoding: base64

SGksQWxsDQoNCiAgIFRoZSB2ZXJzaW9uIG9mIDUuMSBpbmNsdWRlIG1pY3Jv dGltZSBzbG93IHF1
ZXJ5IHBhdGNoPw0KDQoNCg0Kc2xvdyBxdWVyeSBsb2cgaW4gdmVyc2lvbiA1 LjENCl9fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19f
X19fX19fX19fX19fX19fX18NCiMgVXNlckBIb3N0OiByb290W3Jvb3RdIEAg bG9jYWxob3N0IFtd
DQojIFF1ZXJ5X3RpbWU6IDAuMDAwMDk0ICBMb2NrX3RpbWU6IDAuMDAwMDI0 IFJvd3Nfc2VudDog
MCAgUm93c19leGFtaW5lZDogMA0KU0VUIHRpbWVzdGFtcD0xMjYwNTE0MDI1 Ow0KVVBEQVRFIGdh
bWVzZXNzaW9uICBTRVQgc2Vzc2lvbl9leHBpcmVzID0gJzEyNjA1MTU4MjUn LCBzZXNzaW9uX2Rh
dGEgPSAnbGp1c2VyfHM6MTM6ImNoZW5xaW5namkwMDgiO3Rhc2t8czoyOiI1 MiI7JyBXSEVSRSBz
ZXNzaW9uX2lkID0gJzc5YmZkZDk4NDBiZGY0Y2RiMTlkMTlmZjkwZGMwNjQz JzsNCl9fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19f
X19fX19fX19fX18NCg0KDQp2ZXJzaW9uIDUuMC40NQ0KX19fX19fX19fX19f X19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fDQpyb290 QGxvY2FsaG9zdDoo
bm9uZSkgMTg6MzQ6MDE+c2hvdyB2YXJpYWJsZXMgbGlrZSAnJWxvbmclJzsN CistLS0tLS0tLS0t
LS0tLS0tLSstLS0tLS0tKw0KfCBWYXJpYWJsZV9uYW1lICAgfCBWYWx1ZSB8 DQorLS0tLS0tLS0t
LS0tLS0tLS0rLS0tLS0tLSsNCnwgbG9uZ19xdWVyeV90aW1lIHwgMTAgICAg fA0KKy0tLS0tLS0t
LS0tLS0tLS0tKy0tLS0tLS0rDQoxIHJvdyBpbiBzZXQgKDAuMDEgc2VjKQ0K DQpyb290QGxvY2Fs
aG9zdDoobm9uZSkgMTg6MzU6NDE+c2VsZWN0IHZlcnNpb24oKTsNCistLS0t LS0tLS0tLSsNCnwg
dmVyc2lvbigpIHwNCistLS0tLS0tLS0tLSsNCnwgNS4wLjQ1ICAgIHwNCist LS0tLS0tLS0tLSsN
CjEgcm93IGluIHNldCAoMC4wMCBzZWMpDQpfX19fX19fX19fX19fX19fX19f X19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXw0KDQoNCg0KdmVy c2lvbiA1LjEuMjkN
Cl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19f
X19fX19fXw0Kcm9vdEBsb2NhbGhvc3Q6KG5vbmUpIDE4OjM2OjU2PnNob3cg dmFyaWFibGVzIGxp
a2UgJyVsb25nJSc7DQorLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSsN CnwgVmFyaWFibGVf
bmFtZSAgIHwgVmFsdWUgICAgfA0KKy0tLS0tLS0tLS0tLS0tLS0tKy0tLS0t LS0tLS0rDQp8IGxv
bmdfcXVlcnlfdGltZSB8IDIuMDAwMDAwIHwNCistLS0tLS0tLS0tLS0tLS0t LSstLS0tLS0tLS0t
Kw0KMSByb3cgaW4gc2V0ICgwLjAxIHNlYykNCg0Kcm9vdEBsb2NhbGhvc3Q6 KG5vbmUpIDE4OjM2
OjU4PnNlbGVjdCB2ZXJzaW9uKCk7DQorLS0tLS0tLS0tLS0tLS0tKw0KfCB2 ZXJzaW9uKCkgICAg
IHwNCistLS0tLS0tLS0tLS0tLS0rDQp8IDUuMS4yOS1yYy1sb2cgfA0KKy0t LS0tLS0tLS0tLS0t
LSsNCjEgcm93IGluIHNldCAoMC4wMCBzZWMpDQpfX19fX19fX19fX19fX19f X19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXw0KDQoNCg0KDQoN Cg0KQmVzdCBSZWdh
cmRzIQ0KWWFuZyBXYW5nDQoNCkVtYWlsOiB5d2FuZ0BsZm0tYWdpbGUuY29t Lmhr

------=_NextPart_000_010C_01CA7A91.C72C5B60--

Re: different 5.0 and 5.1 about long_query_time

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,
--=20
Jaime Crespo
MySQL & Java Instructor
Warp Networks


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: different 5.0 and 5.1 about long_query_time

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 Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org