当前位置:编程学习 > 网站相关 >>

shell 脚本过滤段落内容

在研究show  engine innodb status 输出信息,为了看其中的insert buffer部分信息,写了个脚本
 
#  mysql -uroot -e 'show engine innodb status \G' |grep -E -A8 -B1 --color 'INSERT BUFFER'
 
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 37064, free list len 21130, seg size 58195, 22172798 merges
merged operations:
 insert 88714186, delete mark 32775614, delete 18942413
discarded operations:
 insert 9204, delete mark 8597, delete 12
Hash table size 42499631, node heap has 151066 buffer(s)
3275.24 hash searches/s, 647.12 non-hash searches/s
 
补充:综合编程 , 其他综合 ,
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,