Shell scripts are used to filter the output information of the section content in showengineinnodbstatus. to view the insertbuffer information, a script is written: mysql-uroot-e & amp; 39; showengineinnodbstatusG & amp; 39; | grep-E-A8-shell script filtering section content in the study show engine innodb status output information, in order to see the insert buffer part of the information, I wrote a script # mysql-uroot-e 'show engine innodb status \ G' | grep-E-A8-B1 -- color 'Insert buffer' ----------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX values ------------------------------------- ibuf: size 37064, free list len 21130, seg size 58195,221 72798 mergesmerged 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
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service