tomcat - 如何根据tomcat日志计算PV,ip,PU

Question

如何根据tomcat日志计算出PV,ip,PU？

我已经将 tomcat 日志导出到 db。

可以找到有关数据库结构的信息here .

对于我可以使用的ip:

select count(distinct ip)...

但是 pv 和 pu 呢？

我不知道，如果你知道请帮我一个忙。

Answer 1

有点像

SELECT 
    COUNT(SELECT DISTINCT ip from tblName) AS IPs, 
    COUNT(SELECT DISTINCT uri from tblName) AS UniquePages, 
    COUNT(SELECT DISTINCT username from tblName) as UniqueVisitors from tblName;

应该适合你

---

要限制应计算的页面类型，将其添加到子查询

SELECT 
    COUNT(SELECT DISTINCT ip from tblName) AS IPs, 
    COUNT(SELECT DISTINCT uri from tblName WHERE uri NOT LIKE '%.js' AND uri NOT LIKE '.css') AS UniquePages, 
    COUNT(SELECT DISTINCT username from tblName) as UniqueVisitors from tblName;