Table of Contents
Lire currently only supports the query log of MySQL™. This log file contains all the connectinons and queries sent to your database server.
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)