RE: MYSQL slow query log in table.

, October 08, 2009 4:37 PM To: Jaime Crespo Rincón ; mysql@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 to upgrade to 5.1 that supports slow-log table. Do you know of any work around to get my slow query

RE: MYSQL slow query log in table.

Jaime Crespo Rincón [mailto:jcre...@warp.es] 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 &

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; <http://dev.mysql.com/doc/refman/5.1/en/log-tables.html> -- Jaime

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. Thanks so much in advance This message is intended only for the use of the Addressee and may contain

MySQL slow query log

Hi, Could anyone explain what might be the possible reasons that in the slow query log(running read-only queries) the most very slow queries(taking 200-300sec) were the queries: 1. create table ... type = MyISAM 2. show slave status Thanks, Jenny

Re: Perl Script: MySQL Slow Query Log Parser

; Sent: Friday, July 20, 2001 12:05 AM Subject: Re: Perl Script: MySQL Slow Query Log Parser > On Wed, Jun 27, 2001 at 01:45:27PM +0100, Tim Bunce wrote: > > > > You'll find mysqldumpslow (in the mysql distribution) does all that and > > much much more > > &

Re: Perl Script: MySQL Slow Query Log Parser

On Wed, Jun 27, 2001 at 01:45:27PM +0100, Tim Bunce wrote: > > You'll find mysqldumpslow (in the mysql distribution) does all that and > much much more > > It's a pity that it's not mentioned in the online documentation > since it's a _very_ useful tool. I've submitted a patch against the manual

Re[2]: Perl Script: MySQL Slow Query Log Parser

> You'll find mysqldumpslow (in the mysql distribution) does all that and > much much more Sorry, not on my server (MySQL 3.22.32). > It's a pity that it's not mentioned in the online documentation > since it's a _very_ useful tool. http://www.mysql.com/udmsearch/search.php?q=mysqldumpslow sho

RE: Perl Script: MySQL Slow Query Log Parser

any idea where any sort of documentation/tutorial can be found? -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 1:45 PM To: Nathanial Hendler Cc: Mysql; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Perl Script: MySQL Slow Query Log Parser

Re: Perl Script: MySQL Slow Query Log Parser

You'll find mysqldumpslow (in the mysql distribution) does all that and much much more It's a pity that it's not mentioned in the online documentation since it's a _very_ useful tool. Tim. On Mon, Jun 25, 2001 at 11:59:59PM -0700, Nathanial Hendler wrote: > I wrote a perl script that will parse

Perl Script: MySQL Slow Query Log Parser

I wrote a perl script that will parse slow_queries logs, and output some useful information. It's kind of hard to explain, but I'll try. I wanted to see what queries were taking a lot of time, and how often they were happening. I wrote a perl script that parses the log files, ignores queries