.\" -*- mode: troff; coding: utf-8 -*-
.\" Automatically generated by Pod::Man v6.0.2 (Pod::Simple 3.45)
.\"
.\" Standard preamble:
.\" ========================================================================
.de Sp \" Vertical space (when we can't use .PP)
.if t .sp .5v
.if n .sp
..
.de Vb \" Begin verbatim text
.ft CW
.nf
.ne \\$1
..
.de Ve \" End verbatim text
.ft R
.fi
..
.\" \*(C` and \*(C' are quotes in nroff, nothing in troff, for use with C<>.
.ie n \{\
.    ds C` ""
.    ds C' ""
'br\}
.el\{\
.    ds C`
.    ds C'
'br\}
.\"
.\" Escape single quotes in literal strings from groff's Unicode transform.
.ie \n(.g .ds Aq \(aq
.el       .ds Aq '
.\"
.\" If the F register is >0, we'll generate index entries on stderr for
.\" titles (.TH), headers (.SH), subsections (.SS), items (.Ip), and index
.\" entries marked with X<> in POD.  Of course, you'll have to process the
.\" output yourself in some meaningful fashion.
.\"
.\" Avoid warning from groff about undefined register 'F'.
.de IX
..
.nr rF 0
.if \n(.g .if rF .nr rF 1
.if (\n(rF:(\n(.g==0)) \{\
.    if \nF \{\
.        de IX
.        tm Index:\\$1\t\\n%\t"\\$2"
..
.        if !\nF==2 \{\
.            nr % 0
.            nr F 2
.        \}
.    \}
.\}
.rr rF
.\"
.\" Required to disable full justification in groff 1.23.0.
.if n .ds AD l
.\" ========================================================================
.\"
.IX Title "MYSQL2DLF.IN 1"
.TH MYSQL2DLF.IN 1 2025-09-28 "Lire 2.1.1" "LogReport's Lire Documentation"
.\" For nroff, turn off justification.  Always turn off hyphenation; it makes
.\" way too many mistakes in technical documents.
.if n .ad l
.nh
.SH NAME
mysql2dlf \- convert mysql logfiles to dlf format
.SH SYNOPSIS
.IX Header "SYNOPSIS"
\&\fBmysql2dlf\fR
.SH DESCRIPTION
.IX Header "DESCRIPTION"
\&\fBmysql2dlf\fR 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 \fBmysqld\fR, or the log=file setting in MySQL
configuration file.
.PP
Such a log file looks like e.g.
.PP
.Vb 9
\& /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 \*(Aqpid_file\*(Aq
\&                       1 Shutdown
\& 011226 21:35:59       6 Connect     joe@localhost on
\&                       6 Init DB     nmrshiftdb
\&                       6 Query       SHOW VARIABLES
.Ve
.PP
or
.PP
.Vb 11
\&                  42401 Query       SELECT
\&                  bannerID,
\&                  banner,
\&                  format,
\&                  width,
\&                  height,
\&                  alt,
\&                  url
\&              FROM
\&                  banners
\&              WHERE
\&
\&                  act = \*(Aqtrue\*(Aq  AND (keyw = \*(Aqfullsize\*(Aq OR keyw = \*(Aqglobal\*(Aq)
.Ve
.PP
The generic database dlf format is described in database.xml.
.SH EXAMPLES
.IX Header "EXAMPLES"
To process a log as produced by MySQL:
.PP
.Vb 1
\& $ mysql2dlf < mysql\-log
.Ve
.PP
mysql2dlf will be rarely used on its own, but is more likely
called by lr_log2report:
.PP
.Vb 1
\& $ lr_log2report mysql < /var/log/mysql\-log
.Ve
.SH NOTES
.IX Header "NOTES"
The parser has been tested for query log files for MySQL 3.23.46 only.
.SH BUGS
.IX Header "BUGS"
This converter stores all log files information in one big nested array in
memory, before writing.  Therefore, memory consumption is linear with the
size of the log.
.SH "SEE ALSO"
.IX Header "SEE ALSO"
\&\fBmysql\fR\|(1), \fBmysqld\fR\|(1)
.SH VERSION
.IX Header "VERSION"
\&\f(CW$Id:\fR mysql2dlf.in,v 1.12 2010/12/05 20:36:45 wraay Exp $
.SH COPYRIGHT
.IX Header "COPYRIGHT"
Copyright (C) 2001, 2002 Stichting LogReport Foundation LogReport@LogReport.org
.PP
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.
.PP
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.
.PP
You should have received a copy of the GNU General Public License
along with this program (see COPYING); if not, check with
http://www.gnu.org/copyleft/gpl.html.
.SH AUTHOR
.IX Header "AUTHOR"
Egon Willighagen <egonw@logreport.org>