log count

awk '/servers*/ {if($10 >1400 && $10<1600) {print $1,$12,$13,$14,$15,$16,$17,$18}}'  ./nginx_access_logs  |sort | uniq -c | sort -nr 

grep time[]

:%s/str/&/gn 查找 全字\<str

 grep -rn '"control":"gacha","action":"do","uid":125' ./* 文件夹匹配

ps aux --sort=-%cpu | awk 'NR==1{print $2,$3,$11}NR>1{if($3!=0.0) print $2,$3,$11}' > /tmp/file.log  查询cpu负载高的服务

 grep '"1":2,"2":1,"3":-\<.[1-10000]\>,"4":null' /data/log/20160507/*

mysql> status;
--------------
mysql  Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (x86_64) using readline 5.1

Connection id:          19878
Current database:
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.0.77 Source distribution
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1
UNIX socket:            /var/lib/mysql/mysql.sock
Uptime:                 312 days 31 min 37 sec

Threads: 1  Questions: 107979  Slow queries: 0  Opens: 17  Flush tables: 1  Open tables: 11 Queries per second avg: 0.004
--------------
在上面显示列表的最后一条，我们来查看Slow queries这一项的值，如果多次查看的值大于0的话,说明有些查询sql命令执行时间过长。

 

2)这时再通过show processlist命令来查看当前正在运行的SQL，从中找出运行慢的SQL语句，找到执行慢的语句后，再用explain命令查看这些语句的执行计划。

mysql> show processlist;
+-------+------+-----------+------+---------+------+-------+------------------+
| Id    | User | Host      | db   | Command | Time | State | Info             |
+-------+------+-----------+------+---------+------+-------+------------------+
| 19878 | root | localhost | NULL | Query   |    0 | NULL  | show processlist |
+-------+------+-----------+------+---------+------+-------+------------------+
1 row in set (0.00 sec)

set global wait_timeout=10;

mysql> show global variables like 'wait_timeout';