mysql 性能

https://blog.csdn.net/zengxuewen2045/article/category/6388631

#sda 磁盘信息
dstat -D sda 3 5

#找出系统瓶颈
dstat -cdlmnpsy 3 5

#找出写操作频繁的表
mysqlbinlog --no-defaults --base64-output=decode-rows -v -v mysql-bin.000023
|awk '/###/{if($0~/UPDAE|INSERT|DELETE/) count[$2 " "$NF]++} END{for(i in count) print i," ",count[i]'} | column -t |sort -k3nr |more