RE: is there a utility like mysqlbinlog but instead processes the query log?

[Daniel Gaddis]

The program would also need to handle...

...queries that span multiple lines
...change databases when appropriate before queries

yes I could program such a beast but I thought someone else might have
already done it.

daniel

-----Original Message-----
From: Andy Davidson [mailto:[EMAIL PROTECTED] 
Sent: Sunday, January 02, 2005 3:58 AM
To: <mysql@lists.mysql.com> <mysql@lists.mysql.com>
Subject: Re: is there a utility like mysqlbinlog but instead processes
the query log?


On 30 Dec 2004, at 13:26, Daniel Gaddis wrote:

> is there a utility like mysqlbinlog but instead processes the query 
> log?
> I would like to reprocess the queries from the query log.

I don't see another reply to this on the list, so I hope it helps - the 
query log is already in plain-text, so you don't need something to fish 
the queries out of an unfriendly format.

This bit of perl should be a good starting point.




elephant:/var/log/mysql# cat pullqueries.pl
#!/usr/bin/perl -w

use strict;

while (my $line = <>) {
         if ($line =~ /Query/) {
                 my (undef, undef, undef, undef, $display) = split(/ /, 
$line, 5);
                 print $display;
         }
}





example :

elephant:/var/log/mysql# tail -n 20 mysql.log | perl pullqueries.pl
       SELECT fname from images where groupid='4' order by viewno desc 
limit 0,1
       SELECT fname from images where groupid='3' order by viewno desc 
limit 0,1
       SELECT fname from images where groupid='2' order by viewno desc 
limit 0,1
       SELECT title,story FROM groups where id='1114'
       SELECT id,dirname,fname FROM images where groupid='1114'
       SELECT id,dirname,fname,viewno,groupid FROM images where 
id='10035' limit 0,1
       UPDATE images set viewno='1',lastlook=NOW('') where id='10035'
       SELECT entry,whoby FROM ucaptions where picid='10035'
       SELECT dirname,fname,caption from images where id='10035' limit 
0,1
       SELECT title,story FROM groups where id='1114'
       SELECT id,dirname,fname FROM images where groupid='1114'





-- 
Regards, Andy Davidson
http://www.fotoserve.com/
Great quality prints from digital photos.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]