# myselect

**Repository Path**: we91/myselect

## Basic Information

- **Project Name**: myselect
- **Description**: myselect用sql语法对日志文件进行统计分析，把要分析的日志文件当成一个数据库，里面的日志行当作数据库记录，比awk等工具使用更方便 $ myselect -h  usage
- **Primary Language**: PHP
- **License**: GPL-2.0
- **Default Branch**: master
- **Homepage**: https://www.oschina.net/p/myselect
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 1
- **Created**: 2023-06-14
- **Last Updated**: 2023-06-14

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

myselect
========

SQL based log statistics and analysis tool



you can use sql syntax to  analyze your log file which is a general textfile with myselect.myselect assume  log line the 
record in the database,and assume item split by space the field in the database. you can use myselect as follow


log line:

    198.52.103.14 - - [29/Jun/2014:00:17:11 +0800] "GET /q/1403060495509100 HTTP/1.1" 200 26788   
    "http://wenda.so.com/q/1403060495509100" "Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1;
    Trident/4.0; .NET CLR 2.0.50727)" 221 0.532             
                 
                 

find the most client ip:

    $ myselect  'select count($1),$1 from accesstest.log  group by $1 order by count($1) desc limit 10'
    14	111.13.65.251
    13	10.141.88.248
    12	10.141.88.239
    10	10.141.88.250
    9	121.226.135.115
    8	10.141.88.241
    8	10.141.88.249
    8	222.74.246.190
    7	211.149.165.150
    6	61.174.51.174



more introduction here : http://blog.csdn.net/micweaver/article/details/37579153



发个招聘：

高级算法工程师
职位描述：
1. 参与搜索算法、LBS技术、反作弊的研发工作，处理业界最前沿的海量司机乘客匹配效率和反作弊业务；
2. 有搜索、learning to rank、广告机器学习，反作弊，LBS路线匹配算法经验任意以上者优先；
3. 使用大规模数据处理平台对海量数据分析建模；

有意请发简历至zhonghuali241@163.com