Chapter 5. Database Supported Log Formats
Prev | Part II. Log Formats | Next

## Chapter 5. Database Supported Log Formats

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)

Prev | Up | Next
Part II. Log Formats | Home | Chapter 6. Dialup Supported Log Format