Login or Register to Ask a Question and Join Our Community

Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

mysql2dlf(1) [debian man page]

MYSQL2DLF.IN(1) 					  LogReport's Lire Documentation					   MYSQL2DLF.IN(1)

NAME

       mysql2dlf - convert mysql logfiles to dlf format

SYNOPSIS

       mysql2dlf

DESCRIPTION

       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.

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.

SEE ALSO

       mysql(1), mysqld(1)

VERSION

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

COPYRIGHT

       Copyright (C) 2001, 2002 Stichting LogReport Foundation LogReport@LogReport.org

       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.

       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.

AUTHOR

       Egon Willighagen <egonw@logreport.org>

Lire 2.1.1							    2011-12-31							   MYSQL2DLF.IN(1)

Check Out this Related Man Page

REFERER2DLF.IN(1)					  LogReport's Lire Documentation					 REFERER2DLF.IN(1)

NAME

       referer2dlf - convert referer web server log file to www DLF

SYNOPSIS

       referer2dlf file

DESCRIPTION

       referer2dlf converts Referer web server log files to the www DLF. Referer log format was first implemented in the NSCA httpd server.
       Apache can be configured to log in that format.

       Note that if you want to log referer information, the combined log format is a better format.

REFERER LOG FORMAT

       The Referer log format logs the referer information in the following format :

	I<uri> -> I<document>

       where the fields have the following meaning:

       uri The referring URI. This is the content of the Referer request's header which usually reflects the page where the user was before that
	   request.

       document
	   The local document that was referenced by that URI. This is the requested file without any query string.

EXAMPLES

       To process a log as produced in the referer logformat:

	$ referer2dlf < referer.log

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

	$ lr_log2report referer < /var/log/httpd/referer.log

SEE ALSO

       common2dlf(1), combined(2), modgzip2dlf(1)

AUTHORS

       Joost van Baal <joostvb@logreport.org>, Francis J. Lacoste <flacoste@logreport.org> and Egon Willighagen <egonw@logreport.org>, based on an
       idea by Edwin Groothuis

VERSION

       $Id: referer2dlf.in,v 1.10 2006/07/23 13:16:37 vanbaal Exp $

COPYRIGHT

       Copyright (C) 2000, 2001 Stichting LogReport Foundation LogReport@LogReport.org

       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.

       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.

Lire 2.1.1							    2006-07-23							 REFERER2DLF.IN(1)
Man Page