SELECT
DB as database_name,
USER as login_user,
LEFT(HOST,POSITION(\':\' IN HOST)-1) AS login_ip,
count(1) as login_count
FROM `information_schema`.`PROCESSLIST` P
WHERE P.USER NOT IN(\'root\',\'repl\',\'system user\')
GROUP BY DB,USER,LEFT(HOST,POSITION(\':\' IN HOST)-1)
ORDER BY COUNT(1) DESC;

-- 查看当前所有事务
select * from information_schema.innodb_trx;
-- 查看正在锁的事务
select * from information_schema.innodb_locks;
-- 查看等待锁的事务
select * from information_schema.innodb_lock_waits;

# 安装epel
 
yum install epel-release
 
# 或者 centos 7，其他版本修改 7 为 对应centos版本即可
 
rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
 
yum install -y iftop

yum install -y flex byacc libpcap libpcap-devel ncurses ncurses-devel make gcc autoconf wget
 
wget http://www.ex-parrot.com/pdw/iftop/download/iftop-0.17.tar.gz
 
tar -zxvf iftop-0.17.tar.gz
 
cd iftop-0.17
 
./configure
 
make && make install

19.1Mb  流量范围
=> / <= 流量方向
TX 发送流量
RX 接收流量
TOTAL 总流量
cumm 运行iftop到目前时间的总流量
peak 流量峰值
rates 过去 2s 10s 40s 的平均流量

-h 帮助
-i 指定监测网卡，iftop -i eth1
-B 以bytes为单位显示流量(默认是bits)
-n 只显示IP
-N 显示端口号
-P 显示host及端口信息
-b 不显示上方流量范围图
-F 显示特定网段的流量, iftop -F 14.18.207.0/255
-m 设置上方的流量范围最大值，分五段显示，iftop -m 100M

h 是否显示帮助
n 是否显示本机IP或主机名
s 是否显示本机host信息
d 是否显示远端目标主机host信息
t 切换流量显示风格
N 是否显示端口号或端口服务名称
S 是否显示本机端口信息
D 是否显示远端目标主机端口信息
p 是否显示端口信息
P 暂停/继续显示
b 是否显示平均流量图形条
B 计算2秒或10秒或40秒内的平均流量
T 是否显示每个连接的总流量
l 输入要过滤的字符，如ip,只显示这个ip相关的流量信息
L 切换显示平均流量图形条
j/k 向上或向下滚动屏幕显示的连接记录
1/2/3 根据右侧显示的三列流量数据进行排序
< 根据左边的本机名或IP排序
> 根据远端目标主机的主机名或ip排序
o 是否固定只显示当前的连接

echo 3 > /proc/sys/vm/drop_caches   # 清除OS Cache
swapoff -a && swapon -a         # 清除OS swap缓存

vm.swappiness=5

curl myip.ipip.net

# 查看占用
for i in $( cd /proc;ls |grep "^[0-9]"|awk \' $0 >100\') ;do awk \'/Swap:/{a=a+$2}END{print \'"$i"\',a/1024"M"}\' /proc/$i/smaps 2>/dev/null ; done | sort -k2nr | head -10

[root@centos7-spider ~]# ethtool eth0
Settings for eth0:
Supported ports: [ TP ]
Supported link modes: 1000baseT/Full 
10000baseT/Full 
Supported pause frame use: No
Supports auto-negotiation: No
Advertised link modes: Not reported
Advertised pause frame use: No
Advertised auto-negotiation: No
Speed: 10000Mb/s
Duplex: Full
Port: Twisted Pair
PHYAD: 0
Transceiver: internal
Auto-negotiation: off
MDI-X: Unknown
Supports Wake-on: uag
Wake-on: d
Link detected: yes

Device eth0 [10.16.169.14] (1/2):
====================================================================
Incoming:
Curr: 27.99 kBit/s
Avg: 33.14 kBit/s
Min: 19.02 kBit/s
Max: 116.44 kBit/s
Ttl: 74.46 GByte
Outgoing:
Curr: 20.26 kBit/s
Avg: 83.46 kBit/s
Min: 17.72 kBit/s
Max: 3.19 MBit/s
Ttl: 145.30 GByte

nload eth1

nload -m

Device eth0 [10.16.169.14] (1/2):
========================================================================================
Incoming: Outgoing:
Curr: 30.23 kBit/s Curr: 28.14 kBit/s
Avg: 32.80 kBit/s Avg: 69.48 kBit/s
Min: 23.65 kBit/s Min: 18.23 kBit/s
Max: 133.16 kBit/s Max: 3.17 MBit/s
Ttl: 74.46 GByte Ttl: 145.30 GByte
Device lo [127.0.0.1] (2/2):
========================================================================================
Incoming: Outgoing:
Curr: 0.00 Bit/s Curr: 0.00 Bit/s
Avg: 150.82 kBit/s Avg: 150.82 kBit/s
Min: 0.00 Bit/s Min: 0.00 Bit/s
Max: 7.51 MBit/s Max: 7.51 MBit/s
Ttl: 276.67 GByte Ttl: 276.67 GByte