apache访问日志写入mysql的经验分享

  1. 数据库
     1 CREATE DATABASE `afb_logs`
 2 
 3 CREATE TABLE `apache_access_2013` (
 4   `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
 5   `host` CHAR(30) DEFAULT NULL,
 6   `ip` CHAR(15) DEFAULT NULL,
 7   `user` VARCHAR(20) DEFAULT NULL,
 8   `datetime` DATETIME DEFAULT NULL,
 9   `method` CHAR(10) DEFAULT NULL,
10   `path` VARCHAR(100) DEFAULT NULL,
11   `request` VARCHAR(200) DEFAULT NULL,
12   `protocol` VARCHAR(20) DEFAULT NULL,
13   `status` CHAR(3) DEFAULT NULL,
14   `size` MEDIUMINT(9) DEFAULT NULL,
15   `referer` VARCHAR(600) DEFAULT NULL,
16   `useragent` VARCHAR(200) DEFAULT NULL,
17   PRIMARY KEY (`id`)
18 ) ENGINE=MYISAM AUTO_INCREMENT=639 DEFAULT CHARSET=utf8

     

  2. Apache配置

     

    LogFormat "INSERT INTO `apache_access_2013`(`id`, `host`, `ip`, `user`, `datetime`, `method`, `path`,`request`, `protocol`, `status`, `size`, `referer`, `useragent`) VALUES ( DEFAULT , \"%v\",\"%a\",\"%u\",\"%{%Y-%m-%d %H:%M:%S}t\",\"%m\", \"%U\",\"%q\",\"%H\",\"%>s\", \"%B\",\"%{Referer}i\", \"%{User-Agent}i\");" afbsql
 
CustomLog "| \"D:/Program Files/sam/xampp/mysql/bin/mysql.exe\" --host=127.0.0.1 --user=root --password=123456 --port=9166 --database=afb_logs " afbsql

     

posted @ 2013-02-01 13:04  sam139  阅读(241)  评论(0)    收藏  举报