NAME

MySQL::SlowLog::Filter - MySQL Slow Query Log Filter

SYNOPSIS

    use MySQL::SlowLog::Filter qw/run parse_date_range parse_time/;
	
    run('slow.log', {
    	date => '13.11.2006-01.12.2008', # see parse_date_range below
    	'include-host' => \@include_hosts,
    	'exclude-host' => \@exclude_hosts,
    	'include-user' => \@include_users,
    	'exclude-user' => \@exclude_users,
    	min_query_time => 30,
    } );

DESCRIPTION

The code is heavily borrowed from http://code.google.com/p/mysql-log-filter/

It is not complete, use it at your own risk.

METHODS

run( $file_name, $params )

run $params on $file_name

PARAMS

date

date => '13.11.2006-01.12.2008'
date => '>13.11.2006'

check parse_date_range below

include-host

exclude-host

include-user

exclude-user

min_query_time

# Query_time: 221  Lock_time: 0  Rows_sent: 241  Rows_examined: 4385615

compare with "Query_time". default is -1. means all.

min_rows_examined

compare with "Rows_examined". default is -1. means all.

parse_date_range

# time epoch
my ( $start, $end ) = parse_date_range($Input);

Input                   Return
''                    ( 0, 9999999999 )
>13-11-2006           ( 1163347200, 9999999999 )
<13/11/2006           ( 0, 1163347200 )
-13.11.2006           ( 0, 1163347200 )
13.11.2006-1.12.2008  ( 1163347200, 1228060800 )
13.11.2006-01.12.2008 ( 1163347200, 1228060800 )
13/11/2006-01-12-2008 ( 1163347200, 1228060800 )

parse_time

Return a unix timestamp from the given date.

get_log_timestamp

Return a unix timestamp from the given date. (070119 12:29:58)

TODO

• incremental

• no-duplicates

• sorting

SEE ALSO

http://mysql-log-filter.googlecode.com/svn/trunk/mysql_filter_slow_log.py

COPYRIGHT & LICENSE

Copyright 2008 Fayland Lam, all rights reserved.

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.