PGSQL2DLF.IN(1) LogReport's Lire Documentation PGSQL2DLF.IN(1)NAME
pgsql2dlf - convert pgsql logfiles to dlf format
SYNOPSIS
pgsql2dlf
DESCRIPTION
pgsql2dlf converts a PostgreSQL query log file to DLF format. Information on PostgreSQL can be found on http://www.postgresql.org/.
Logging can be enabled in the postgresql.conf file.
The following options should be present at least for this converter to work well:
debug_level = 1
debug_print_parse = on
debug_print_query = on
The generic database dlf format is described in database.xml.
EXAMPLES
To process a log as produced by PostgreSQL:
$ pgsql2dlf < /var/log/postgresql.log
pgsql2dlf will be rarely used on its own, but is more likely called by lr_log2report:
$ lr_log2report pgsql < /var/log/postgresql.log
NOTES
The parser has been tested for log files from PostgreSQL 7.2.1.
SEE ALSO psql(1), postmaster(1), postgresql.conf(5)VERSION
$Id: pgsql2dlf.in,v 1.12 2006/07/23 13:16:33 vanbaal Exp $
COPYRIGHT
Copyright (C) 2002 Stichting LogReport Foundation LogReport@LogReport.org
This file 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.
AUTHOR
Wessel Dankers <wsl@logreport.org>
Lire 2.1.1 2006-07-23 PGSQL2DLF.IN(1)
Check Out this Related 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)