Chapter 5. Database Supported Log Formats

Table of Contents

MySQL's Log

Lire currently only supports the query log of MySQL™. This log file contains all the connectinons and queries sent to your database server.

MySQL™'s Log

The MySQL™'s log file will contain information about each start and shutdown of your database server, as well as all connections and queries processed by the database server during its session.

Example 5.1. Sample MySQL™ Log File


/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
011226 21:32:57       1 Connect     root@localhost on
011226 21:33:01       1 Query       show tables
011226 21:33:08       1 Query       show databases
011226 21:33:46       1 Quit
011226 21:34:32       2 Connect     Access denied for user: \
  'jdoe@localhost' (Using password: YES)
011226 21:34:42       3 Connect     Access denied for user: \
  'jdoe@localhost' (Using password: YES)
011226 21:35:59       6 Connect     jdoe@localhost on 
                    6 Init DB     nmrshiftdb
                    6 Query       SHOW VARIABLES
011226 21:36:00       6 Query       CREATE TABLE molecules \
  (molid INT, CMLcode TEXT)
                    6 Query       CREATE TABLE chemnames \
  (molid INT, autonom TEXT, name TEXT)