MySQL Innotop for Linux怎么安装

小编给大家分享一下MySQL Innotop for Linux怎么安装，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！
首先到网址https://code.google.com/archive/p/innotop/downloads里下载innotop-1.9.0.tar.gz，见下图,选择innotop-1.9.0.tar.gz下载

然后上传到Linux服务器进行解压
[root@idb4 ~]# tar zxvf innotop-1.9.0.tar.gz
innotop-1.9.0/
innotop-1.9.0/t/
innotop-1.9.0/t/InnoDBParser.t
innotop-1.9.0/t/innodb-status-001
innotop-1.9.0/t/innodb-status-002
innotop-1.9.0/t/innodb-status-003
innotop-1.9.0/t/innodb-status-004
innotop-1.9.0/t/innodb-status-005
innotop-1.9.0/t/innodb-status-006
innotop-1.9.0/t/innodb-status-007
innotop-1.9.0/innotop.spec
innotop-1.9.0/Makefile.PL
innotop-1.9.0/INSTALL
innotop-1.9.0/Changelog
innotop-1.9.0/innotop
innotop-1.9.0/COPYING
innotop-1.9.0/MANIFEST

[root@idb4 innotop-1.9.0]# perl Makefile.PL
Checking if your kit is complete…
Looks good
Warning: prerequisite Term::ReadKey 2.1 not found.
Writing Makefile for innotop

报以上错误，缺少ReadKey包，解决方法:
[root@idb4 innotop-1.9.0]# yum install perl-DBI perl-DBD-MySQL perl-TermReadKey

安装完再次运行后无报错：
[root@idb4 innotop-1.9.0]# perl Makefile.PL
Writing Makefile for innotop
[root@idb4 innotop-1.9.0]#
[root@idb4 innotop-1.9.0]#开发云主机域名
[root@idb4 innotop-1.9.0]# make install
cp innotop blib/script/innotop
/usr/bin/perl -MExtUtils::MY -e ‘MY->fixin(shift)’ — blib/script/innotop
Manifying blib/man1/innotop.1
Installing /usr/local/share/man/man1/innotop.1
Installing /usr/local/bin/innotop
Appending installation info to /usr/lib64/perl5/perllocal.pod
[root@idb4 innotop-1.9.0]#

运行innotop命令后发现报错:
[root@idb4 innotop-1.9.0]# innotop -u mdba -p123456
localhost, 0.00, 0 QPS, 0/0/0 con/run/cac thds, !localhost

Uptime MaxSQL ReplLag Cxns Lock QPS QPS Run Run Tbls Repl SQL

localhost: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)

查看一下帮助:
[root@idb4 innotop-1.9.0]# innotop –help
Usage: innotop

–[no]color -C Use terminal coloring (default)
–config -c Config file to read
–count Number of updates before exiting
–delay -d Delay between updates in seconds
–help Show this help message
–host -h Connect to host
–[no]inc -i Measure incremental differences
–mode -m Operating mode to start in
–nonint -n Non-interactive, output tab-separated fields
–password -p Password to use for connection
–port -P Port number to use for connection
–skipcentral -s Skip reading the central configuration file
–socket -S MySQL socket to use for connection
–spark Length of status sparkline (default 10)
–timestamp -t Print timestamp in -n mode (1: per iter; 2: per line)
–user -u User for login if not current user
–version Output version information and exit
–write -w Write running configuration into home directory if no config files were loaded

需要加-S后再运行:
[root@idb4 innotop-1.9.0]# innotop -u mdba -p123456-S /tmp/mysql.sock
localhost, 44d, 1.53k QPS, 119/6/29 con/run/cac thds, 5.6.27-log

按？号显示帮助
Switch to a different mode:
A Dashboard I InnoDB I/O Info Q Query List
B InnoDB Buffers K InnoDB Lock Waits R InnoDB Row Ops
C Command Summary L Locks S Variables & Status
D InnoDB Deadlocks M Replication Status T InnoDB Txns
F InnoDB FK Err O Open Tables U User Statistics

Actions:
d Change refresh interval p Pause innotop
k Kill a query’s connection q Quit innotop
n Switch to the next connection x Kill a query

Other:
TAB Switch to the next server group / Quickly filter what you see
! Show license and warranty = Toggle aggregation
# Select/create server groups @ Select/create server connections
$ Edit configuration settings Clear quick-filters

按Q，显示以下信息
When Load Cxns QPS Slow Se/In/Up/De% QCacheHit KCacheHit BpsIn BpsOut
Now 0.16 135 1.53k 0 26/ 1/ 0/ 0 0.00% 100.00% 174.93k 427.61k
Total 0.00 1000 1.53k 2.09k 29/ 3/ 0/ 0 0.00% 90.42% 156.93k 463.33k

Cmd ID State User Host DB Time Query
Query 3978017 init ixinnuo_ 172.16.16.10 ixinnuo_sjcj 00:01 commit
Query 4051691 init ixinnuo_ 172.16.16.10 ixinnuo_sjcj 00:01 commit
Query 4054981 init ixinnuo_ 172.16.16.10 ixinnuo_sjcj 00:01 commit
Query 4064304 init ixinnuo_ 172.16.16.10 ixinnuo_sjcj 00:01 commit
Query 4083366 init ixinnuo_ 172.16.16.10 ixinnuo_sjcj 00:01 commit
Query 4083368 Sending data ixinnuo_ 172.16.16.10 ixinnuo_sjcj 00:01 select id, SH, KPJH, ZFJH, TYPE, MONTH, STATUS, CREATE_TIME, UPDAT
Query 4083370 init ixinnuo_ 172.16.16.10 ixinnuo_sjcj 00:01 commit
Query 4083372 init ixinnuo_ 172.16.16.10 ixinnuo_sjcj 00:01 commit
Query 4083375 init ixinnuo_ 172.16.16.10 ixinnuo_sjcj 00:01 commit
Query 4139383 init ixinnuo_ 172.16.16.10 ixinnuo_sjcj 00:01 commit
Query 4146551 init ixinnuo_ 172.16.16.10 ixinnuo_sjcj 00:01 commit
Query 4155188 init ixinnuo_ 172.16.16.10 ixinnuo_sjcj 00:01 commit
Query 4157873 init ixinnuo_ 172.16.16.10 ixinnuo_sjcj 00:01 commit
Query 4223328 Sending data ixinnuo_ 172.16.16.10 ixinnuo_sjcj 00:01 select id, SH, KPJH, ZFJH, TYPE, MONTH, STATUS, CREATE_TIME, UPDAT

其中 Load 是负载
QPS (Query Per Second) 表示每秒的查询率
Slow 代表慢查询的个数
Se/In/Up/De%: 增，删，改，查的比率
QCacheHit:查询缓冲的命中率
KCacheHit:索引的命中率
BpsIn （bytes Per Second in）每秒钟输入的字节数
BpsOut（bytes Per Second Out）每秒钟输出的字节数
以上是“MySQL Innotop for Linux怎么安装”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注开发云行业资讯频道！

相关推荐: MariaDB 备份

10.2之后不在支持pt xtrabackup取而代之的是mariab开发云主机域名ackup，和pt一样，非常好用的工具相关推荐: MySQL 增量备份与还原说明：所谓增量备份，就是备份自上一次备份之后增加或改变的文件或内容。然而MySQL没有提供直接的增量…