There is an apache module for this. We tried it a while back
using MySQL 3.20 and didn't have very good luck. All those
extra sockets on each of the webservers and the pounding
the database server took was incredible. That was about a
year and 1/2 ago, so it may work better now with the faster
hardware available.
-Troy Cobb
Circle Net, Inc.
http://www.circle.net
> -----Original Message-----
> From: Ben Kirkpatrick [mailto:ben@stripped]
> Sent: Wednesday, June 09, 1999 4:47 PM
> To: David Sklar
> Cc: Blake Binkley; mysql@stripped
> Subject: Re: easiest way to import web logs into mysql
>
>
> I haven't done this... but it seems possible. Why not
> get the apache
> source and rewrite such that apache _logs_ to the database
> instead of to
> a file.
> --Ben
>
> On Wed, 9 Jun 1999, David Sklar wrote:
> > > lets take for granted that the logs are in the following format:
> > >
> > > %h \"%{User-agent}i\" %u %t \"%r\" %s %b
> > >
> > > I have a database set up that coresponds as such:
> > >
> > > | Host | User_Agent | User | Time | Request | Status | Bytes |
> > >
> > > I'm adding sql querying of our customers logs into our
> tracking system
> > > and manually entering them is not a nice solution for me...
> >
> > To do this, we parse the access logs and write them out
> into a file that looks
> > something like this: (by your format above)
> >
> > client.example.com|Mozilla/9.0|blake|1999-06-08
> 14:34:23|/foo/bar/index.html|20
> > 0|1000
> >
> > and then use 'LOAD DATA INFILE' to load it into a table
> of requests. Works
> > great!
> >
> > -dave
> >
> >
> >
> >
> ------------------------------------------------------------
> ---------
> > Please check
"http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread4932@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>
>
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread4937@stripped
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail mysql-unsubscribe@stripped instead.
