Hi: how to caculate the PV,ip,PU according to the tomcat log?
I have export the tomcat log to db. This is the db structure: +-------+-----------+----------+----------+--------+-----+----------+----------+--------+---------------------+---------+----------+-------+ | Id | hostip | username | datasend | method | uri | queryStr | protocol | status | time | browser | platform | refer | +-------+-----------+----------+----------+--------+-----+----------+----------+--------+---------------------+---------+----------+-------+ | 44359 | 127.0.0.1 | - | 0 | GET | / | | HTTP/1.1 | 404 | 2011-02-17 08:08:25 | Unknown | Unknown | - | +-------+-----------+----------+----------+--------+-----+----------+----------+--------+---------------------+---------+----------+-------+ For the ip I can use : select count(distinct ip)... But how about the pv and pu? I have no idea,please do me a favor if you know.