Here's a MySQL table definition that can
hold the log data:
CREATE TABLE weblog (
when DATETIME NOT NULL,
duration INT(4),
uri VARCHAR(255) NOT NULL,
query_string VARCHAR(255),
status CHAR(3) NOT NULL,
method CHAR(3) NOT NULL,
mime_type VARCHAR(32) NOT NULL,
bytes INT(8),
vhost VARCHAR(64),
referer VARCHAR(255),
browser VARCHAR(64),
remote_addr VARCHAR(15),
cookie VARCHAR(255),
authuser VARCHAR(255)
);
Splitting the fast parsable log format fields into arguments for insert
statements into this table is easy.