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
LR_LOG2REPORT.IN(1) LogReport's Lire Documentation LR_LOG2REPORT.IN(1) NAME
lr_log2report - generates a report from a log file SYNOPSIS
lr_log2report [options] dlf_converter [ logfile ] [ output_file ] lr_log2report --version lr_log2report --help [dlf-converters|output-formats|report-templates] OPTIONS
--help [section] If no argument is given, prints usage information and exits. Argument can be one of the following: dlf-converters Prints the list of available DLF converters and exits. output-formats Prints the list of available output formats and exits. report-templates Prints the list of available report templates and exits. --version Prints Lire's version and exits. --output-format|-o output format Selects the ouput format in which to generate the report. --template|-t name Uses the report configuration named name to generate the report. DESCRIPTION
lr_log2report reads a log file from STDIN or the specified argument and will output a formatted Lire report on STDOUT or in the output_file argument. The format of the log file is specified using the dlf_converter argument. Use the --help dlf-converters option to get a list of all currently available DLF converters. In case the log is passed in a compressed format, it's uncompressed on the fly, using gzip(1). WARNING: This command outputs binary data on the terminal for all output formats except txt and xml. You should redirect stdout to a file when using those output formats. In the case where output format is html, the output_file argument will be interpreted as a directory name. This directory will get created if needed, and will hold the various html files. In case this argument is omitted, a tar(1) file should be output on STDOUT (but see the BUGS section). WARNING: Running this command on big logfiles generally means you'll need lots of free diskspace. See Lire::LrCommand(3pm) for details. EXAMPLES
To process a Postfix log and display the report as text, use $ lr_log2report postfix /var/log/mail.log To process a Postfix log and create an HTML report in a directory, use $ lr_log2report -o html postfix /var/log/mail.log postfix-report BUGS
If --output html is specified, both logfile and output_file need to be specified. Specifying "-" (or "/dev/stdin") as logfile is supported. So this $ tai64nfrac < /var/log/qmail-send/current | lr_log2report qmail --output html - /tmp/report will work. SEE ALSO
lr_log2mail(1), lr_xml2report(1), lr_xml2mail(1), lire(1), lire(7), Lire::LrCommand(3pm), documentation in the Lire User Manual AUTHORS
Joost van Baal <joostvb@logreport.org> Francis J. Lacoste <flacoste@logreport.org> VERSION
$Id: lr_log2report.in,v 1.100 2006/10/04 10:19:17 vanbaal Exp $ COPYRIGHT
Copyright (C) 2000-2004 Stichting LogReport Foundation LogReport@LogReport.org This program is part of Lire. Lire 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-10-04 LR_LOG2REPORT.IN(1)