mysql数据在时间平均分布_统计时间分布脚本（mysql）详解

mysql

-- 查询超时记录

select * from visit_record t where t.accesstime>to_date('2013-09-1','yyyy-MM-dd') and t.username is not null and t.result='成功' and t.totaltimecost>5000 and t.clientip <> '192.168.112.53' and t.clientip <> '192.168.112.200' and t.clientip <> '192.168.112.245' order by t.totaltimecost desc ;

-- 导出日期范围内的日志信息(已xml格式导出为stat.xml，使用navicat工具导入进stat表)

select t.username,t.accesstime,t.totaltimecost,t.accessurl from visit_record t where t.accesstime>to_date('2013-09-1','yyyy-MM-dd') and t.username is not null and t.result='成功' and t.clientip <> '192.168.112.53' and t.clientip <> '192.168.112.200' and t.clientip <> '192.168.112.245'

and (t.accessurl='/newOA/m_flow/navPage.do' or

t.accessurl='/newOA/m_commWorkflow/submitN