查看网卡实时速率

nload使用

1
2
yum install -y nload 
nload device eth0

iftop使用

1
2
3
4
5
6
7
8
9
10
11
yum install -y iftop
iftop

# =>代表发送数据,<= 代表接收数据
# 底部三行:
# 表示发送:TX
# 接收:RX
# 全部的流量:TOTAL
# 底部三行第二列:为你运行iftop到目前流量 (cum)
# 底部三行第三列:为高峰值 (peak)
# 底部三行第四列:为平均值 (rates)

s

查看磁盘io监控

1
2
3
4
yum install sysstat dstat

怀疑IO真的到达瓶颈时可以通过iostat来确认当前磁盘的IO状态。iostat -d -x -k -c 1 10
也可以通过dstat来查看各种负载状况来确认是否由其他负载导致。dstat -lmcdnr -fs --top-mem --top-io --top-cpu

mysql性能排查

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
# https://www.cnblogs.com/duhuo/p/5678286.html 参考文档

show variables like '%pool%';

set global innodb_buffer_pool_size=1073741824;

SELECT * FROM information_schema.INNODB_TRX;


show full processlist;


select id, db, user, host, command, time, state, info
from information_schema.processlist
where command != 'Sleep'
order by time desc

mysql二进制导出sql

1
mysqlbinlog binlog88-master.001010 -v --base64-output=decode-rows --result-file=/tmp/001010.sql

mysql清理binlog

1
2
3
4
5
# 查看binlog
show binary logs;

# 删除某个日志文件之前的所有日志文件(注意slave同步到哪个文件了)
purge binary logs to 'mysql-bin.000035';

连接数排查

1
netstat -an|awk '/tcp/ {print $6}'|sort|uniq -c

nginx 日志统计

1)总请求数

1
wc -l  access.log |awk '{print $1}'

2)独立IP数

1
awk '{print $1}' access.log|sort |uniq |wc -l

3)每秒客户端请求数 TOP5

1
awk '{print $6}' access.log|sort|uniq -c|sort -rn|head -5

4)访问最频繁IP Top5

1
awk '{print $1}' access.log|sort |uniq -c |sort -nr |head -5

5)访问最频繁的URL TOP5

1
awk '{print $7}' access.log|sort |uniq -c |sort -nr |head -5

6)响应大于5秒的URL TOP5

1
awk '{if ($7 > 5){print $6}}' access.log|sort|uniq -c|sort -rn |head -5

7)HTTP状态码(非200)统计 Top5

1
awk '{if ($11 != 200){print $11}}' access.log|sort|uniq -c|sort -rn|head -5

8)分析请求数大于50000的源IP

1
2
3
cat access.log|awk '{print $NF}'|sort |uniq -c |sort -nr|awk '{if ($1 >50000){print $2}}'

# 备注:access.log如果不是默认,可以替换为具体的路径,比如
  1. 查找访问最多的50个ip
1
awk '{print $1}' /data/mystack/sites/88.com/log/nginx/access.log|sort |uniq -c |sort -nr |head -50

vps性能测试脚本

1
wget -qO- bench.sh | bash

博客备案徽标

ICP备案徽标

1
https://img.shields.io/badge/%E8%90%8CICP%E5%A4%87-18008019-fe1384?style-flat&logo=data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAB4AAAAeCAYAAAA7MK6iAAABS2lUWHRYTUw6Y29tLmFkb2JlLnhtcAAAAAAAPD94cGFja2V0IGJlZ2luPSLvu78iIGlkPSJXNU0wTXBDZWhpSHpyZVN6TlRjemtjOWQiPz4KPHg6eG1wbWV0YSB4bWxuczp4PSJhZG9iZTpuczptZXRhLyIgeDp4bXB0az0iQWRvYmUgWE1QIENvcmUgNS42LWMxNDIgNzkuMTYwOTI0LCAyMDE3LzA3LzEzLTAxOjA2OjM5ICAgICAgICAiPgogPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4KICA8cmRmOkRlc2NyaXB0aW9uIHJkZjphYm91dD0iIi8+CiA8L3JkZjpSREY+CjwveDp4bXBtZXRhPgo8P3hwYWNrZXQgZW5kPSJyIj8+nhxg7wAAByxJREFUSInl1nlwVeUZx/HPuTckkD0kQFiCEEIUlNUCAqKoSBV1AIt1ikpVLFbLONjWGUXbmWrbweJMy7hUxbbTjsUq6KCiWEvr0kE2WVK2QCKBJCxJgEASsienfxwqMob+3Zm+f93z3vM+32f5vc9z+H9bwVcfOp/YQ+1prhhEZS1VDQzqQ1MjiQmIC5Liwm3lBWpqFimrulb/7A/067vM2IsOBZ2h8MhJQW6KMDNVsKeaizKEyUlsKueqgWJ39AMJF3QpDCNYr1SaEig/lWNX2Z1h6dH5/lVyGdVIZFf7MHo9bEfh9rCg/+8NyHlN77QTsnpQ0i2y08VK+BosfhbW0cHxqmSfFd9qW+l9Pi+5WltFdGTsOBbO5dJcdh3lN5+xff0Y2zuelXjRsyYUrjOu4BVJaavlpbWIJRBLOM+J81O95AAnTtM9vNHGknut3zdT48FutJE3koWTuG4oSXH+VsInX3B9IdcVUNfCuv08t4GjO6NspOa3BNcOXx1eOugVHQnrTMkTuyWrC/BjRZO9uPYTpw7HhTWkXcLd45l9GblpHD7NWzt5ZTMXZ/OdkTy+lvR07rmcmWffq6pn9W5e/oymfcT6kJbXHiydMyVYkL/x66n+ZMcctQfjhgxl6UIGZ3Ooltd2RIZqjqKRS0ew9cFIA1cO5urlLHuPZWsZPJiZw7gqn0VT2HCIR9+jvCQhfHPrLGyE2Hng2roBxHnmJoZnc9drbD3I6QaaWkjpSVoeu4+x5XB05qMDqCenHz37UHmcFRv54ZuMeoYrB/L0DPRgZ0WfrsXVKzPX3nYykrn3dUZl8+Q0Qox/gc/L6ZlKzxQefo+UROpa6Z4VCedkPd8YyJYHI3u5T/HAShZNQxsXZfR3pCtwRW066VEeOuIUVUf77+9jTw2pycTOJml7Je1t9EgiI5X2jkgyze1fCSSdtjhBiJCkpKyuI+5oTdAtkTCgVwrbKsl8ko6QjO40tZ67EpkpdIbRf20dkbPpPTjdwsSX6I5dJYy4hoQAaZQdDy4A1iEMI613T6LtBPXJpPakrjGqc1Y6CTFq62htJp5KRwPJKWSkU3WKiiPEEqO6xgM6oZmctJhDXYH7Z59xuCyKpK6R26ZE+ys3MWYoN1/Mc5uoqmbEQJ6fTc/ulJ3i/lUc+YIfzeKhKzjVHN31A3XRHddKSrf6/6DOV3VTcw1hVKfkxOhaPDAe1UwfwmNTqT1Drxw+nE9xNXetIjHG2vnoxoT+rNrN2Of58Rp6JZ+ldKes5kjX4G7dKuikpoERfaltYnQ/DOSS3hEAFk9lXQkLnmf7Ib65lPJT3HU1+46Tm8rYvgzKYVA2h+vQIMjvewHwdSN20MiOSmZczO4a1hSzYi77T7CiiPF5JMTZexjJ5OagkwNV9M+MnJ09nKU3smgyQ3PYWoEO4fUjii4QceJmevJuMeP6csUAln4atcbSGoqOUpjD30uZNwnpHNtN3lC+NZa1xeT34pGVTJ3PL9+Ohs6GQ8gVtHZs6VLVwZhBReGwoXvt3THM/hP0SWVnCR8f4PMjkffjB/DQS8waxpHFfFgaaeHZDRRtJn0yP5tF31ymFVJ2nN27GD66KBzca2/XEWdkUpD3Fmd4tYj0FMS54Q9UnuaDUv6yE/24ewWP/DU6N/d1fvousYEs28DyLVEvGDOAt/egmSkXv2VYn3NBfpXbua6J8hMFFvy2RHsL+57gmX+w/AN651PfEDWQzLRI+afqIqOxFDJT6Rbn9Bmad3PnTH5wIxOXkJTWGiz57hCDsyqDWVldRNzeyOh+paaPfpFKnvqQX88iZwDVx0lLJqUHbe3EkZ1Odm+yUqK2GHYKmhvIG8fyeTz9IY5x67jnFPapdPDkl6jzwEF9IDjZJlgwfbG+o2u8+g4rd7D/UYI41TXnevV5K4j2q6uESckUP8rvNrH6fUH/sRXB9AlPONMSDZ8uazwoi56JjEyvdftV88jinhf4uIzmJRQOoOYgja0RKAiIBZxpjvZH5tP0c97axcLlyBXOuWZemJTYFFbUCU+1dl3j8PGSyFhnJ7EkYcWh7/njqpep5xfzWTyZZ7dEg73xOJKiGqf3YenNLBjLTz7i539COg/OvSOYO2GFo/VRG0Zwe0YX4Ns3R7NXSCxBeM8IthXfZvGf3xCWc/kkXvg2vVP4YB/rDzC1gGlDo+50/xvs2khKPrNnzAzmTH5HbzR0fkkKro93Ab5vx9kfaGgT3lLA5EyWbRpoTdHbSreOppGJV/PwlRTksK+aZz5l6z+RLBgxaau5k2cJelTKzmRQMq0d51J8UxL+23d1TDTcj7WQllZu4YwxDo+eZc22X9mwd6gN65GIFmQzampxcMOoR1xeuMbpVoqromsXdG3+wmCiekNtfSSmiUNWu2zgap+WjlZW8X11TeNkpWwICvNfCm8u3Cmxg4PN0VdmEJw7/7+0/g32RaqCbhRecAAAAABJRU5ErkJggg==

豫公网安备

1
https://img.shields.io/badge/%E8%B1%AB%E5%85%AC%E5%AE%89%E5%A4%87-41010502004766%E5%8F%B7-aa9f6c?style-flat&logo=data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAMAAAC6V+0/AAACClBMVEX17tH9+Njx166ti3rTk3DKhFvYrn2caVn/+dDeqFjnvGzbrGLnwnP06Ln9v1T034vRrnbs3bLbuoffr2fluGLu23/69M3mwlvjxpDeq2Ddmkzv6KP//93Dfz6eXzCBWDqEaUqjfVK5lVs5FDiTYDbEazPlYCPscS3dtmmsonOwjFlONU+TeVvzfCjUBArVPCHaTSrNAQL7n0aptJFUOFM2Gk1eWWb8jizUIRnLKRXWRSjPFxHBDAv/vmBrc4RCJESTjXoAAIHwXh7WMR/WHRfRDBHrXym9un4BAW2NhncABHe1gD/iRh7ZAAbWHxnXxnh8enn3pDmjmYQAAHr2gjbHVifUlj3lwFPgjkfRFQrtcTTNwnGVkIP/0lrplzTFrnwACJFuYmL6xES7TSbGPh3WaTfXdTnVkEf/6Wh5ZGDFvYf6s0XXhzryy24cPpfpgj7MPifXXzPkbzYLBmcXMInu1nPilDvOeDpyhZS7ABH9KwrXYy/9LRRrfIz+xVLdm0T2zWTTvIcAG45MADmxDg7EGAppAjYAEHr71WjkslPblEbiqVeEj5kAAGVODk5gHlAMAF1zeIL/11rktV3kqUvYmFa0o2bNrFJcX3hWTm/qw2HooD3jrUvpu1Heo0rVdCj1x1f/2E3wr0jsyVvty2PqvFrrzGvqxF3muVrrwFfnxGb143Ppu0/psUt9B7RiAAAAHnRSTlMACWnRFF2s+UzGvPXpJMO6b4OY2+LnW/JG6fJ8CJwCr7S8AAABZUlEQVQY02NggABGJmZmJhYGZMDKxi4nr6DIzsaBJKikrKKqpq6hqawFF2Lh1NbR1dM3MDQyNuGCiXGbmplbWFhaWdvY2tnz8EIEHRy1nPScXVz1Dd3cPTzBgix8Dl7ePr5++vp+hvr+HgH8IFGBwKBgpRDD0LDwiMioaI+YWEGgoFBcfEJiUnJKalpqekZmcFa2EFBQOCc3zyM536qg0KootbiktEwYKMhdnl0RXFlVHZqWX1PpUVuXIwIUZKtvaGxqbmm1tDQoaGuP7+gEaefs6u7o8ert7euf0Bs8cdLkKZxAQf+pU8ty/XVqp02fMXPirNn1c0SBgmJz56XPX9CxsG5RbEZsTnrnYrDrxcTDc3KWLO1cuqShvmsZDyvYmxKSy2etWLl81pKl81aUrpKSAAtyrS6dPHlp5/K59VNWrFi2GhpOQtPXLJi7ds3alYvXLBGVhgWoDKssJ6ewCCeXEEQvAE9NZ1QwP2IIAAAAAElFTkSuQmCC

Server主机阿里云

1
https://img.shields.io/badge/Host&CDN-%E9%98%BF%E9%87%8C%E4%BA%91-ff5f00?style-flat&logo=Alibaba%20Cloud

查看LInux的线程数量

1
2
3
4
5
6
7
8
9
10
11
12
# ps查看带详细信息
$ ps -T -p <PID>
# ps查看只查看线程数量
$ ps -o nlwp <pid>

# top查看
$ top -H -p <PID>

# proc查看
$ cat /proc/<PID>/status | grep Threads
# 或者
$ grep Threads /proc/<PID>/status

SqLite3常用命令

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
# 打开指定数据库
$ sqlite3 videoDownload.db

# 查看帮助命令
sqlite>.help

# 查看数据库
sqlite>.databases

# 查看表
sqlite>.tables

# 格式化输出
sqlite>.header on
sqlite>.mode column
sqlite>.timer on

# 查看表中的数据
sqlite> select * from video_infos

sqlite> .exit

Macos命令行改网卡ip

查看网卡的名称

1
2
3
$ networksetup -listallnetworkservices
Ethernet
以太网

设置ip地址

1
$ networksetup -setmanual "Ethernet" 192.168.128.54 255.255.255.0 192.168.128.1