MYSQL2DLF.IN(1)

💅 MYSQL2DLF.IN(1) — mysql2dlf, from LogReport's Lire Documentation

okay bestie, buckle up 🎀 this one's a lil converter tool from the Lire docs and honestly it's serving very specific-purpose realness.

✨ NAME ✨

mysql2dlf — converts mysql logfiles to dlf format. that's the whole job. she's focused. 💅

🌸 SYNOPSIS 🌸

mysql2dlf

no args, no flags, no drama. she just is. 🦋

💖 DESCRIPTION 💖

so mysql2dlf takes a MySQL query log file and converts it into DLF format. that's it, that's the arc. 🌈

if you wanna know more about MySQL itself, the info lives at http://www.mysql.org/ — go off, do your research, iykyk. 📚

the query log file you're feeding her is the one defined by the --log[=file] option of mysqld, or by the log=file setting in the MySQL configuration file. either way, that's where she's getting her snack from. 🍓

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, alternatively, like this:

                 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 over in database.xml. 📄

🔥 EXAMPLES 🔥

wanna process a log the way MySQL produces it? easy:

$ mysql2dlf < mysql-log

ngl though, mysql2dlf will be rarely used on her own — she's more likely to be called up by lr_log2report, like the main character's bestie who does all the actual work backstage 👑

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

⭐ NOTES ⭐

lowkey important: the parser has been tested for query log files for MySQL 3.23.46 only. that's it. one version. don't come for her about it 😭

💀 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.

so like… big log = big memory. no cap, plan accordingly 🫶

🦋 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>

---

and that's the whole page, bestie — mwah 💋 this lil beauty is from Lire 2.1.1, dated 2025-09-28, so go forth and convert those logs 🌸✨