mysql2dlf1

Usage

Overview

mysql2dlf converts a MySQL query log file to DLF format. Information on MySQL can be found on http://www.mysql.org/. The query log file is defined by the --log[=file] option of mysqld, or the log=file setting in MySQL configuration file.

Such a log file looks like e.g.

 /usr/sbin/mysqld, Version: 3.23.43-debug-log, started with:
 Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
 Time                 Id Command    Argument
 011218 15:02:58       1 Connect     root@localhost on
                       1 Query       SHOW VARIABLES LIKE 'pid_file'
                       1 Shutdown
 011226 21:35:59       6 Connect     joe@localhost on
                       6 Init DB     nmrshiftdb
                       6 Query       SHOW VARIABLES

or

                  42401 Query       SELECT
                  bannerID,
                  banner,
                  format,
                  width,
                  height,
                  alt,
                  url
              FROM
                  banners
              WHERE
                  act = 'true'  AND (keyw = 'fullsize' OR keyw = 'global')

The generic database dlf format is described in database.xml.

Examples

To process a log as produced by MySQL:

 $ mysql2dlf < mysql-log

mysql2dlf will be rarely used on its own, but is more likely called by lr_log2report:

 $ lr_log2report mysql < /var/log/mysql-log

Notes

The parser has been tested for query log files for MySQL 3.23.46 only.

Version

$Id: mysql2dlf.in,v 1.12 2010/12/05 20:36:45 wraay Exp $