转载自:http://blog.chinaunix.net/uid-9370128-id-393082.html 1. mysql 5.0.x 统计每秒增,删,改,查,替换数 mysql 的show global status可以查出自启动以前,累计数量,每秒抓取一次 #!/bin/bashwhile truedoecho -ne "`date`\t"mysql -S /tmp/mysql.sock -e "show global status;"| grep
#!bin/bash#作者:liusingbon#功能:统计 Linux 进程相关数量信息,running(运行的进程),sleeping(睡眠中的进程),stoped(停止的进程),zombie(僵尸进程)running=0sleeping=0stoped=0zombie=0#在 proc 目录下所有以数字开始的都是当前计算机正在运行的进程的进程 PID#每个PID编号的目录下记录有该进程相关的信息for pid in /proc/[1-9]*doprocs=$[procs+1]stat=$(
1.统计每分钟内 url 的访问数量 SELECT SUBSTRING(CONVERT(varchar(100), date, 20), 0,17) as dateTime,COUNT(url) as count,url,referer FROM demo GROUP BY url,(SUBSTRING(CONVERT(varchar(100), date, 20), 0,17) ),referer;
1.可以使用count SELECT count(name='A' OR NULL) FROM table 2.用sum SELECT sum(if( = 'A', 1, 0)) FROM table 以上只是简单的方式,如遇到复杂的多表查询,可以结合GROUP BY,count() or sum()函数得出对应数据
Given a sequence of n numbers a1, a2, ..., an and a number of d-queries. A d-query is a pair (i, j) (1 ≤ i ≤ j ≤ n). For each d-query (i, j), you have to return the number of distinct elements in the subsequence ai, ai+1, ..., aj. Input Line 1: n (1
#!/usr/bin/python #-*- coding: utf- -*- import os import re rawfile = '/var/log/auth.log' def rawparse(rawfile): ipdict = {} fhandle = open(rawfile,'r') regexp = re.compile('\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}') for line in fhandle: result = regexp.fi
A - D-query Given a sequence of n numbers a1, a2, ..., an and a number of d-queries. A d-query is a pair (i, j) (1 ≤ i ≤ j ≤ n). For each d-query (i, j), you have to return the number of distinct elements in the subsequence ai, ai+1, ..., aj. Input L
<script type="text/javascript"> var tags = document.getElementsByTagName('*'); var tagsArr = []; function countTag(){ for (var i = 0; i < tags.length; i++) { tagsArr.push((tags[i].tagName).toLowerCase()); } var temp = []; //该数组用于存放相同的元素