-
有问题的sql ,慢查询如:Sending data ,怎么一次kill掉:mysql -uroot -h 127.0.0.1 -P3307 -e "show full processlist"|grep "Sending data"|awk '{printf "mysql -uroot -h 127.0.0.1 -P3307 -e " "\047" "kill " $1"\047;" }'|sh
-
awk '{print "\x22"}' 打印双引号awk '{print "\x27"}' 打印单引号
-
以前写过一篇文章,是处理2个文件某一域相同或不相同,这次要复杂一点,是匹配关系。cat 1.txt /p1/18/27/70891221.jpg/p1/23/11/70624037.jpgcat 2.txt222.210.X.X - - [07/Oct/2013:09:15:22 +0800] "GET /leImage?&url=http://service-img//p1/26/21/
-
awk 处理反算日志流量每小时的平均流量:[root@st01 nginx]# awk '{a[substr($4,9,7)]=a[substr($4,9,7)]+$10}END{for(i in a)print i,a[i]*8/3600000000"M/s"}' fm.kxting.log |sort -k1n2011:00 62.5697M/s2011:01 34.2174M/s2011:0
-
例如:[2012-12-01 00:17:55] alipay,billno:135,tradeNo:632063,TRADE_SUCCESS,total fee:10.00[2012-12-01 00:17:55] duomi diamonds num:110,id:8272[2012-12-01 0
-
日志格式:211.136.115.45|-|[14/Dec/2012:00:00:02 +0800]|GET 3701.aac?type=0&uid=3450371&pos=6&key=%E5%8D%93%E4%BE%9D%E5%A9%B7&ps=34.2.300&version=DM1.2.0.95_S60V3_320X240&channel=TG
-
##Log#<SONG_PLAY>version:v3.0.0.00_A1|channel:TG75222|device_type:LenovoLenovo A300|play_type:online|uid:XXX|sid:XXXX|road_ids:3:1|startup_time:6|play_time:22|song_time:264|block_times:0|connect
-
测试:[root@apply1 67]# wc -l duomi-delay-2012-11-0137818115 duomi-delay-2012-11-01/usr/local/bin/awk --versionGNU Awk 4.0.1Copyright (C) 1989, 1991-2012 Free Software Foundation.[root@
-
awk 同一字段 做减法。[root@gw2 ~]# more 1.txtzbj 90 192.168.0.12cwm 100 192.168.0.1cwm 120 192.168.0.1csh 90 192.168.0.200cs