MySQL Innotop for Linux怎么安装
发布时间：2022-01-10 15:54:57 所属栏目：MySql教程 来源：互联网
导读：小编给大家分享一下MySQL Innotop for Linux怎么安装，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！ MySQL Innotop for Linux怎么安装 然后上传到Linux服务器进行解压 [ro
|
小编给大家分享一下MySQL Innotop for Linux怎么安装，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！ MySQL Innotop for Linux怎么安装 然后上传到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怎么安装”这篇文章的所有内容，感谢各位的阅读！ （编辑：92站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
站长推荐