这是一个将nginx日志插入到数据的脚本,仅用于测试,效率很低。
nginx log_format: log_format access '$remote_addr | $limit_rate | $content_length | $request_time | $remote_user | $time_iso8601 | $host | $request | $status | $body_bytes_sent | $http_referer | $http_user_agent | $http_x_forwarded_for';
sql:
CREATE TABLE seo
(
id
int(10) unsigned NOT NULL AUTO_INCREMENT,
remote_addr
varchar(100) NOT NULL DEFAULT '',
limit_rate
int(10) unsigned NOT NULL DEFAULT '0',
content_length
int(10) unsigned NOT NULL DEFAULT '0',
request_time
float(10,2) NOT NULL DEFAULT '0.00',
remote_user
varchar(100) NOT NULL DEFAULT '',
time_iso8601
varchar(100) NOT NULL DEFAULT '',
host
varchar(100) NOT NULL DEFAULT '',
request
varchar(2000) NOT NULL DEFAULT '',
status
int(10) unsigned NOT NULL DEFAULT '0',
body_bytes_sent
int(10) unsigned NOT NULL DEFAULT '0',
http_referer
varchar(2000) NOT NULL DEFAULT '',
http_user_agent
varchar(2000) NOT NULL DEFAULT '',
http_x_forwarded_for
varchar(2000) NOT NULL DEFAULT '',
method
varchar(100) NOT NULL,
protocol
varchar(100) NOT NULL,
PRIMARY KEY (id
),
KEY request
(request
(333)) USING BTREE,
KEY host
(host
) USING BTREE,
KEY http_referer
(http_referer
(333)) USING BTREE,
KEY http_user_agent
(http_user_agent
(333)) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=11312659 DEFAULT CHARSET=utf8;