Skip to content

Latest commit

 

History

History
 
 

mysqlsla

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
mysqlsla version 2.03
=====================
mysqlsla parses, filters, analyzes and sorts MySQL slow, general, binary
and microslow patched slow logs in order to create a customizable report
of the queries and their meta-property values.

Since these reports are customizable, they can be used for human consumption
or be fed into other scripts to further analyze the queries.

For example, to profile with mk-query-profiler (a script from Baron Schwartz's
Maatkit) every unique SELECT statement using database foo from a slow log:

   mysqlsla -lt slow slow.log -R print-unique -mf "db=foo" -sf "+SELECT" | \
   mk-query-profiler -separate -database foo

In brief, mysqlsla is a liaison allowing other scripts easy access to queries
from a MySQL log.


Installation
============
See included INSTALL file.


Dependencies
============
The following core Perl modules are used which should already be installed
on your system:

   Time::HiRes
   File::Temp
   Data::Dumper
   DBI
   Getopt::Long
   Storable

If available, Term::ReadKey will also be used.

mysqlsla v2 uses an "internalized" version of MySQL::Log::ParseFilter.
You do _not_ need to install this module separately.

Web sites
=========
mysqlsla: http://hackmysql.com/mysqlsla

MySQL::Log::ParseFilter: http://hackmysql.com/mlp

Maatkit: http://www.maatkit.org/


Copyright and Licence
=====================
Copyright 2007-2008 Daniel Nichter

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

The GNU General Public License is available at:
http://www.gnu.org/copyleft/gpl.html