dev.mysql.com is down. <EOM>

------=_NextPart_000_0A2A_01CA0ACB.2C090D30
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit



------=_NextPart_000_0A2A_01CA0ACB.2C090D30--

MYSQL slow query log in table.

Hello All. I would like to implement MYSQL slow query log in table. Can =
someone kindly assist me with the table definition and implementation.=20

Thanks so much in advance



********************************************
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.

If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.

If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.

Thank you.
********************************************

--
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: MYSQL slow query log in table.

2009/10/7 Brown, Charles :
> Hello All. I would like to implement  MYSQL slow query log in table.=
Can someone kindly assist me with the table definition and implementation.

SHOW CREATE TABLE mysql.slow_log;



--=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: MYSQL slow query log in table.

SGVsbG8uIFRoYW5rcyBmb3IgcXVpY2sgcmVzcG9uc2UuIEknbSBydW5uaW5n IE15c3FsIDUuMC4g
V2UgaGF2ZSBubyBwbGFucyB0byB1cGdyYWRlIHRvIDUuMSB0aGF0IHN1cHBv cnRzIHNsb3ctbG9n
IHRhYmxlLiBEbyB5b3Uga25vdyBvZiBhbnkgd29yayBhcm91bmQgdG8gZ2V0 IG15IHNsb3cgcXVl
cnkgaW50byBhIHRhYmxlIC0tIGp1c3Qgd29uZGVyaW5nLiBEZXNwZXJhdGUg Zm9yIGEgcmVzb2x1
dGlvbiBvciBjaXJjdW12ZW50aW9uLiANCg0KDQoNCi0tLS0tT3JpZ2luYWwg TWVzc2FnZS0tLS0t
DQpGcm9tOiBKYWltZSBDcmVzcG8gUmluY8OzbiBbbWFpbHRvOmpjcmVzcG9A d2FycC5lc10gDQpT
ZW50OiBUaHVyc2RheSwgT2N0b2JlciAwOCwgMjAwOSAxMDoxNyBBTQ0KVG86 IEJyb3duLCBDaGFy
bGVzDQpDYzogRGFldmlkIFZpbmNlbnQ7IG15c3FsQGxpc3RzLm15c3FsLmNv bQ0KU3ViamVjdDog
UmU6IE1ZU1FMIHNsb3cgcXVlcnkgbG9nIGluIHRhYmxlLg0KDQoyMDA5LzEw LzcgQnJvd24sIENo
YXJsZXMgPENCcm93bkBibWkuY29tPjoNCj4gSGVsbG8gQWxsLiBJIHdvdWxk IGxpa2UgdG8gaW1w
bGVtZW50IMKgTVlTUUwgc2xvdyBxdWVyeSBsb2cgaW4gdGFibGUuIENhbiBz b21lb25lIGtpbmRs
eSBhc3Npc3QgbWUgd2l0aCB0aGUgdGFibGUgZGVmaW5pdGlvbiBhbmQgaW1w bGVtZW50YXRpb24u
DQoNClNIT1cgQ1JFQVRFIFRBQkxFIG15c3FsLnNsb3dfbG9nOw0KDQo8aHR0 cDovL2Rldi5teXNx
bC5jb20vZG9jL3JlZm1hbi81LjEvZW4vbG9nLXRhYmxlcy5odG1sPg0KDQot LSANCkphaW1lIENy
ZXNwbw0KTXlTUUwgJiBKYXZhIEluc3RydWN0b3INCldhcnAgTmV0d29ya3MN CjxodHRwOi8vd2Fy
cC5lcz4NCg0KKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioNClRo
aXMgbWVzc2FnZSBpcyBpbnRlbmRlZCBvbmx5IGZvciB0aGUgdXNlIG9mIHRo ZSBBZGRyZXNzZWUg
YW5kDQptYXkgY29udGFpbiBpbmZvcm1hdGlvbiB0aGF0IGlzIFBSSVZJTEVH RUQgYW5kIENPTkZJ
REVOVElBTC4NCg0KSWYgeW91IGFyZSBub3QgdGhlIGludGVuZGVkIHJlY2lw aWVudCwgeW91IGFy
ZSBoZXJlYnkgbm90aWZpZWQNCnRoYXQgYW55IGRpc3NlbWluYXRpb24gb2Yg dGhpcyBjb21tdW5p
Y2F0aW9uIGlzIHN0cmljdGx5IHByb2hpYml0ZWQuDQoNCklmIHlvdSBoYXZl IHJlY2VpdmVkIHRo
aXMgY29tbXVuaWNhdGlvbiBpbiBlcnJvciwgcGxlYXNlIGVyYXNlDQphbGwg Y29waWVzIG9mIHRo
ZSBtZXNzYWdlIGFuZCBpdHMgYXR0YWNobWVudHMgYW5kIG5vdGlmeSB1cw0K aW1tZWRpYXRlbHku
DQoNClRoYW5rIHlvdS4NCioqKioqKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioq
KioqDQo=

RE: MYSQL slow query log in table.

Use an etl tool like Talend to load the slow query log into a table. We do =
something similar with the general query log very successfully with mysql 5=
=20

Even with 5.1 i would use this approach over the built in log tables as the=
built in log tables impact performance quite significantly.

Regards

John Daisley
Mobile +44(0)7812 451238
Email john@butterflysystems.co.uk

Certified MySQL 5 Database Administrator (CMDBA)
Certified MySQL 5 Developer
Cognos BI Developer

-----------------------
Sent from HP IPAQ mobile device.



-----Original Message-----
From: Brown, Charles
Sent: Thursday, October 08, 2009 4:37 PM
To: Jaime Crespo Rincón ; mysql@lists.mysql.com l@lists.mysql.com>
Subject: RE: MYSQL slow query log in table.

Hello. Thanks for quick response. I'm running Mysql 5.0. We have no plans t=
o upgrade to 5.1 that supports slow-log table. Do you know of any work arou=
nd to get my slow query into a table -- just wondering. Desperate for a res=
olution or circumvention.=20



-----Original Message-----
From: Jaime Crespo Rincón [mailto:jcrespo@warp.es]=20
Sent: Thursday, October 08, 2009 10:17 AM
To: Brown, Charles
Cc: Daevid Vincent; mysql@lists.mysql.com
Subject: Re: MYSQL slow query log in table.

2009/10/7 Brown, Charles :
> Hello All. I would like to implement  MYSQL slow query log in table.=
Can someone kindly assist me with the table definition and implementation.

SHOW CREATE TABLE mysql.slow_log;



--=20
Jaime Crespo
MySQL & Java Instructor
Warp Networks


********************************************
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.

If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.

If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.

Thank you.
********************************************
=0A=
=0A=
[The entire original message is not included]=


--
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