List:General Discussion« Previous MessageNext Message »
From:Charles Brown Date:October 8 2009 3:37pm
Subject:RE: MYSQL slow query log in table.
View as plain text  
Hello. Thanks for quick response. I'm running Mysql 5.0. We have no plans to upgrade to 5.1 that supports slow-log table. Do you know of any work around to get my slow query into a table -- just wondering. Desperate for a resolution or circumvention. 



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

2009/10/7 Brown, Charles <CBrown@stripped>:
> 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;

<http://dev.mysql.com/doc/refman/5.1/en/log-tables.html>

-- 
Jaime Crespo
MySQL & Java Instructor
Warp Networks
<http://warp.es>

********************************************
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.
********************************************
Thread
dev.mysql.com is down. <EOM>Daevid Vincent23 Jul
  • MYSQL slow query log in table. Charles Brown7 Oct
    • Re: MYSQL slow query log in table.Jaime Crespo Rinc√≥n8 Oct
      • RE: MYSQL slow query log in table.Charles Brown8 Oct
RE: MYSQL slow query log in table.John Daisley9 Oct