{"id":4459,"date":"2014-09-25T05:40:04","date_gmt":"2014-09-24T20:40:04","guid":{"rendered":"http:\/\/www.vincentina.net\/?p=4459"},"modified":"2020-02-23T16:10:12","modified_gmt":"2020-02-23T07:10:12","slug":"innotop%e3%82%92%e5%85%a5%e3%82%8c%e3%81%a6%e3%81%bf%e3%82%8b","status":"publish","type":"post","link":"https:\/\/www.vincentina.net\/?p=4459","title":{"rendered":"Innotop\u3092\u5165\u308c\u3066\u307f\u308b"},"content":{"rendered":"

Innotop \u3063\u3066\u4f55\u306c\u306d\u306e<\/h2>\n

Linux\u306bTop\u3068\u3044\u3046\u30b3\u30de\u30f3\u30c9\u304c\u3042\u308b\u3002Windows\u3067\u3044\u3046\u3068\u3053\u308d\u306e\u30bf\u30b9\u30af\u30de\u30cd\u30fc\u30b8\u30e3\u306e\u3088\u3046\u306b\u3001\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u3067\u72b6\u6cc1\u78ba\u8a8d\u3059\u308b\u305f\u3081\u306e\u57fa\u672c\u30b3\u30de\u30f3\u30c9\u3060\u3002\u305d\u3057\u3066Mytop\u3068\u3044\u3046MySQL\u7248Top\u30b3\u30de\u30f3\u30c9\u306e\u3088\u3046\u306a\u3082\u306e\u304c\u3042\u308a\u3001\u305d\u3093\u306aMytop\u3092\u30a4\u30f3\u30b9\u30d1\u30a4\u30a2\u3057\u3066\u3067\u304d\u305f\u3068\u4f5c\u8005\u304c\u4ef0\u3063\u3066\u3044\u308b\u3002
\n\u305d\u308c\u304cInnotop\u306a\u306e\u306a\u3002<\/p>\n

\u3068\u308a\u3042\u3048\u305aMytop\u3092<\/h2>\n

\u3069\u3093\u306a\u3093\u304b\u306a\uff5e\uff1f\u5b9f\u884c\u3057\u3066\u307f\u3088\u3046\u3002<\/p>\n

MySQL on localhost (5.1.73-log)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 up 4+19:39:33 [05:07:50]\r\n\u00a0Queries: 2.4M\u00a0\u00a0 qps:\u00a0\u00a0\u00a0 6 Slow:\u00a0\u00a0 30.2k\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Se\/In\/Up\/De(%):\u00a0\u00a0\u00a0 44\/07\/27\/01\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 qps now:\u00a0\u00a0 16 Slow qps: 2.0\u00a0 Threads:\u00a0\u00a0 17 (\u00a0\u00a0 1\/\u00a0\u00a0 0) 69\/00\/06\/00\r\n\u00a0Key Efficiency: 99.8%\u00a0 Bps in\/out: 902.1\/ 3.3k\u00a0\u00a0 Now in\/out:\u00a0 1.6k\/25.0k\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 Id\u00a0\u00a0\u00a0\u00a0\u00a0 User\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Host\/IP\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DB\u00a0\u00a0\u00a0\u00a0\u00a0 Time\u00a0\u00a0\u00a0 Cmd Query or State\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 --\u00a0\u00a0\u00a0\u00a0\u00a0 ----\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 -------\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 --\u00a0\u00a0\u00a0\u00a0\u00a0 ----\u00a0\u00a0\u00a0 --- ----------\r\n\u00a0\u00a0 120839\u00a0\u00a0\u00a0 wp\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 localhost\u00a0\u00a0\u00a0\u00a0 wp\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0 Query show full processlist\r\n\u00a0\u00a0 120872\u00a0\u00a0\u00a0 wp\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 localhost\u00a0\u00a0\u00a0\u00a0 wp\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0 Sleep<\/pre>\n
\u30b5\u30f3\u30d7\u30eb\u304c\u3061\u3087\u3063\u3068\u60b2\u3057\u3044\u304b\u306a\u3001\u5168\u304f\u4f55\u3082\u6e9c\u307e\u3063\u3066\u306a\u3044\u306e\u3067\u5168\u304f\u53c2\u8003\u306b\u306a\u3089\u306a\u304f\u3066\u3059\u307e\u306a\u3044\u3002
\n\u4ee5\u4e0b\u306f\u5fd8\u5099\u9332\u7684\u306aMyTop\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30e1\u30e2\u3067\u3059\u3001MyTOP\u306f\u3082\u3068\u3082\u3068\u4f7f\u3063\u3066\u3044\u305f\u306e\u3067\u4eca\u56de\u6539\u3081\u3066\u30ed\u30fc\u30ab\u30eb\u306b\u5165\u308c\u3066\u307f\u305f\u306e\u306d\u3002<\/p>\n
$ cd \/tmp\r\n\r\n$ wget http:\/\/jeremy.zawodny.com\/mysql\/mytop\/mytop-1.6.tar.gz\r\n\r\n$ tar zxvf mytop-1.6.tar.gz\r\n\r\n$ cd mytop-1.6\r\n\r\n$ perl Makefile.PL\r\nCan't locate ExtUtils\/MakeMaker.pm in @INC (@INC contains: \/usr\/local\/lib64\/perl5 \/usr\/local\/share\/perl5 \/usr\/lib64\/perl5\/vendor_perl \/usr\/share\/perl5\/vendor_perl \/usr\/lib64\/perl5 \/usr\/share\/perl5 .) at Makefile.PL line 1.\r\nBEGIN failed--compilation aborted at Makefile.PL line 1.\r\n\r\n$ sudo yum install perl-ExtUtils-MakeMaker.x86_64\r\n\r\n$ perl Makefile.PL\r\nChecking if your kit is complete...\r\nLooks good\r\nWarning: prerequisite Term::ReadKey 2.1 not found.\r\nWriting Makefile for mytop\r\n\r\n$ sudo yum install -y perl-TermReadKey.x86_64\r\n\r\n$ make\r\ncp mytop blib\/script\/mytop\r\n\/usr\/bin\/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib\/script\/mytop\r\nManifying blib\/man1\/mytop.1\r\n\r\n$ make test\r\nPERL_DL_NONLAZY=1 \/usr\/bin\/perl \"-Iblib\/lib\" \"-Iblib\/arch\" test.pl\r\n1..1\r\nok 1\r\n\r\n$ sudo make install\r\nInstalling \/usr\/local\/share\/man\/man1\/mytop.1\r\nInstalling \/usr\/local\/bin\/mytop\r\nAppending installation info to \/usr\/lib64\/perl5\/perllocal.pod\r\n\r\n\u203b\u3064\u304b\u3044\u304b\u305f\r\nmytop -u\u30e6\u30fc\u30b6\u30fc\u540d -p\u30d1\u30b9\u30ef\u30fc\u30c9 -d\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d -s\u8868\u793a\u66f4\u65b0\u79d2\u6570<\/pre>\n
\u8d85\u8d85\u8d85\u8d85\u3000\u8d85\u9069\u5f53\u3060\u304c\u3001RH\uff16\u7cfb\u306a\u3089\u3053\u308c\u3067OK\u3067\u3057\u3087\u3046\u3002\u611b\u306e\u9769\u547d\u3067\u3042\u308b\u3002<\/p>\n
\u3067\u306f\u3000Innotop \u3092<\/h2>\n
$ wget https:\/\/innotop.googlecode.com\/files\/innotop-1.9.1-1.el6.noarch.rpm\r\n\r\n$ rpm -ivh innotop-1.9.1-1.el6.noarch.rpm\r\n\u30a8\u30e9\u30fc: \u4f9d\u5b58\u6027\u306e\u6b20\u5982:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 perl(Term::ReadKey) \u306f innotop-1.9.1-1.el6.noarch \u306b\u5fc5\u8981\u3068\u3055\u308c\u3066\u3044\u307e\u3059\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 perl(Time::HiRes) \u306f innotop-1.9.1-1.el6.noarch \u306b\u5fc5\u8981\u3068\u3055\u308c\u3066\u3044\u307e\u3059\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 perl-TermReadKey \u306f innotop-1.9.1-1.el6.noarch \u306b\u5fc5\u8981\u3068\u3055\u308c\u3066\u3044\u307e\u3059\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 perl-Time-HiRes \u306f innotop-1.9.1-1.el6.noarch \u306b\u5fc5\u8981\u3068\u3055\u308c\u3066\u3044\u307e\u3059\r\n\r\n$ sudo yum install perl-Time-HiRes.x86_64\u3000ReadKey\r\n\r\n$ sudo rpm -ivh innotop-1.9.1-1.el6.noarch.rpm\r\n\u6e96\u5099\u4e2d...\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ########################################### [100%]\r\n\u00a0\u00a0 1:innotop\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ########################################### [100%]\r\n\r\ninnotop -u <username> -p <password> -h <hostname><\/pre>\n
\u3073\u3063\u304f\u308a\u3057\u305f\uff1f\u3055\u3089\u306b\u77ed\u3044\u306e\u3067\u3042\u3063\u305f\u3002<\/p>\n
\u6d41\u77f3\u306b\u3053\u308c\u3067\u306f\u7d42\u308f\u3089\u306a\u3044\u3088\u3068\u3002
\n\u307e\u3060\u4f7f\u3044\u65b9\u3082\u77e5\u3089\u306a\u3044\u306e\u306b\u4f7f\u3044\u65b9\u3092\u3068\u306f\u4f55\u305f\u308b\u3053\u3068\u304b\u3068\u601d\u3044\u307e\u3059\u304c\u3001\u307b\u304b\u306b\u8a00\u3044\u3088\u3046\u3082\u306a\u3044\u306e\u3067\u3002<\/p>\n
\u4ee5\u4e0b\u3001\u3056\u3063\u304f\u308a\u3068\u4f7f\u3044\u304b\u305f<\/h2>\n
$ innotop -u root<\/pre>\n
\u307e\u305a\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\u3068\u3044\u3046\u306e\u304c\u8868\u793a\u3055\u308c\uff20\u30ad\u30fc\u3067\u30bb\u30c3\u30c6\u30a3\u30f3\u30b0\u304c\u3067\u304d\u308b\u3002-write \u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u3064\u3051\u3066\u8d77\u52d5\u3059\u308b\u3053\u3068\u3067\u30b3\u30f3\u30d5\u30a3\u30b0\u30d5\u30a1\u30a4\u30eb\u304c\u4f5c\u6210\u3055\u308c\u308b\u3002<\/p>\n
You can enter the name of a new connection to create it.\r\n\r\n_____________________ Choose from _____________________\r\nlocalhost\u00a0\u00a0 DBI:mysql:;;mysql_read_default_group=client\r\n\r\nChoose connections for this mode:<\/pre>\n
$ ls -la \/home\/takeken\/.innotop\r\n\u5408\u8a08 16\r\ndrwxrwxr-x.\u00a0 3 takeken takeken 4096\u00a0 9\u6708 25 03:21 2014 .\r\ndrwx-----x. 15 takeken takeken 4096\u00a0 9\u6708 25 03:21 2014 ..\r\n-rw-------.\u00a0 1 takeken takeken 2758\u00a0 9\u6708 25 03:21 2014 innotop.conf\r\ndrwxrwxr-x.\u00a0 2 takeken takeken 4096\u00a0 9\u6708 25 03:19 2014 plugins<\/pre>\n
\u53c2\u8003\u30b5\u30a4\u30c8\u306e\u3088\u3046\u306b\u8907\u6570\u306e\u30db\u30b9\u30c8\u306b\u63a5\u7d9a\u3057\u3066\u30c1\u30a7\u30c3\u30af\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u306a\u3088\u3046\u3060\u3002
\n\u304b\u306a\u308a\u7d20\u6575\u306a\u3082\u306e\u306e\u3088\u3046\u3060\u3002<\/p>\n
\u53c2\u8003\u30b5\u30a4\u30c8<\/p>\n
YaKst
\nInnotop – MySQL\u306e\u305f\u3081\u306e\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u3067\u9ad8\u6a5f\u80fd\u306a\u8abf\u67fb\u30c4\u30fc\u30eb<\/a><\/p>\n
\u3076\u3063\u3061\u3083\u3051\u53c2\u8003\u30b5\u30a4\u30c8\u3092\u898b\u305f\u65b9\u304c\u53c2\u8003\u306b\u306a\u308b\u3068\u3044\u3046\u3053\u3068\u306f\u65e9\u3081\u306b\u3053\u3053\u3067\u8a00\u3063\u3066\u304a\u304f\u3088\u3002<\/p>\n
\u3067\u306f\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u30ad\u30fc\u306a\u3069\u306a\u3069<\/h2>\n
\u8d77\u52d5\u6642\u306e\u753b\u9762\u3001A\u30ad\u30fc\uff08\u77e2\u5370\u30ad\u30fc\u306e\u4e0a\uff09\u3067\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9<\/h3>\n
Dashboard (? for help)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 localhost, 14d, 2.03k QPS, 47\/2\/0 con\/run\/cac thds, 5.1.73-log\r\n\r\nUptime\u00a0 MaxSQL\u00a0 ReplLag\u00a0 QPS\u00a0\u00a0\u00a0 Cxns\u00a0 Run\u00a0 Miss\u00a0 Lock\u00a0 Tbls\u00a0 Repl\u00a0 SQL\r\n\u00a0\u00a0 14d\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2.03k\u00a0\u00a0\u00a0 47\u00a0\u00a0\u00a0 1\u00a0 9.34\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0 233\u00a0 Off<\/pre>\n
Q\u30ad\u30fc\u3067\u30af\u30a8\u30ea\u30fc\u30e2\u30fc\u30c9<\/h3>\n
When\u00a0\u00a0 Load\u00a0 Cxns\u00a0 QPS\u00a0\u00a0\u00a0\u00a0 Slow\u00a0\u00a0 Se\/In\/Up\/De%\u00a0 QCacheHit\u00a0 KCacheHit\u00a0 BpsIn\u00a0\u00a0 BpsOut\r\nNow\u00a0\u00a0\u00a0 0.18\u00a0\u00a0\u00a0 47\u00a0\u00a0 1.06k\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0 99\/ 0\/ 0\/ 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.00%\u00a0\u00a0\u00a0 100.00%\u00a0 98.44k\u00a0 312.83k\r\nTotal\u00a0 0.00\u00a0\u00a0 200\u00a0 95.99\u00a0\u00a0 8.46k\u00a0 39\/ 2\/ 2\/15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3.85%\u00a0\u00a0\u00a0 100.00%\u00a0 22.65k\u00a0 163.85k\r\n\r\nCmd\u00a0\u00a0\u00a0 ID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 State\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 User\u00a0\u00a0\u00a0 Host\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DB\u00a0\u00a0\u00a0\u00a0\u00a0 Time\u00a0\u00a0 Query\r\nQuery\u00a0\u00a0\u00a0\u00a0\u00a0 1084\u00a0 Copying to tmp tab\u00a0 zabbix\u00a0 localhost\u00a0\u00a0\u00a0\u00a0\u00a0 zabbix\u00a0 00:03\u00a0 select distinct t.triggerid,t.description,t.expression,t.error,t.priority,t.type,t.value,t.state,t.lastchange,t.status from hosts h,items i,functions f,triggers t\r\nQuery\u00a0 21073924\u00a0 statistics\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 zabbix\u00a0 localhost\u00a0\u00a0\u00a0\u00a0\u00a0 zabbix\u00a0 00:00\u00a0 SELECT DISTINCT i.itemid,i.hostid,i.name,i.key_,i.value_type FROM items i,functions f WHERE f.itemid=i.itemid AND f.triggerid='25764'<\/pre>\n
R\u30ad\u30fc\u3067\u30ed\u30fcOPS\u30e2\u30fc\u30c9<\/h3>\n
[RO] InnoDB Row Ops (? for help)\u00a0\u00a0\u00a0 localhost, 18m, InnoDB 37s :-), 2.43 QPS, 46\/0\/0 con\/run\/cac thds, 5.1.73-log\r\n\r\n____________________ InnoDB Row Operations ____________________\r\nIns\u00a0\u00a0\u00a0\u00a0 Upd\u00a0\u00a0 Read\u00a0\u00a0\u00a0\u00a0 Del\u00a0 Ins\/Sec\u00a0 Upd\/Sec\u00a0 Read\/Sec\u00a0 Del\/Sec\r\n447978\u00a0 6164\u00a0 8613385\u00a0\u00a0\u00a0 0\u00a0\u00a0 365.18\u00a0\u00a0\u00a0\u00a0 3.54\u00a0\u00a0 1466.47\u00a0\u00a0\u00a0\u00a0 0.00\r\n\r\n___________________ Row Operation Misc ____________________\r\nQueries Queued\u00a0 Queries Inside\u00a0 Rd Views\u00a0 Main Thread State\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0 sleeping\r\n\r\n_____________________________ InnoDB Semaphores _____________________________\r\nWaits\u00a0 Spins\u00a0 Rounds\u00a0 RW Waits\u00a0 RW Spins\u00a0 Sh Waits\u00a0 Sh Spins\u00a0 Signals\u00a0 ResCnt\r\n\u00a02704\u00a0 88722\u00a0 171928\u00a0\u00a0\u00a0\u00a0\u00a0 1370\u00a0\u00a0\u00a0\u00a0\u00a0 7992\u00a0\u00a0\u00a0\u00a0\u00a0 1612\u00a0\u00a0\u00a0\u00a0\u00a0 2423\u00a0\u00a0\u00a0\u00a0 7872\u00a0\u00a0\u00a0 5929\r\n\r\n____________________________ InnoDB Wait Array _____________________________\r\nThread\u00a0 Time\u00a0 File\u00a0 Line\u00a0 Type\u00a0 Readers\u00a0 Lck Var\u00a0 Waiters\u00a0 Waiting?\u00a0 Ending?<\/pre>\n
I\u30ad\u30fc\u3067InnoDB IO\u30b9\u30ec\u30c3\u30c9\u30e2\u30fc\u30c9<\/h3>\n
[RO] InnoDB I\/O Info (? for help)\u00a0 localhost, 11m, InnoDB 24s :-), 94.06 QPS, 45\/0\/0 con\/run\/cac thds, 5.1.73-log\r\n\r\n____________________ I\/O Threads ____________________\r\nThread\u00a0 Purpose\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Thread Status\r\n\u00a0\u00a0\u00a0\u00a0 0\u00a0 insert buffer thread\u00a0 waiting for i\/o request\r\n\u00a0\u00a0\u00a0\u00a0 1\u00a0 log thread\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 waiting for i\/o request\r\n\u00a0\u00a0\u00a0\u00a0 2\u00a0 read thread\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 waiting for i\/o request\r\n\u00a0\u00a0\u00a0\u00a0 3\u00a0 read thread\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 waiting for i\/o request\r\n\u00a0\u00a0\u00a0\u00a0 4\u00a0 read thread\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 waiting for i\/o request\r\n\u00a0\u00a0\u00a0\u00a0 5\u00a0 read thread\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 waiting for i\/o request\r\n\u00a0\u00a0\u00a0\u00a0 6\u00a0 write thread\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 waiting for i\/o request\r\n\u00a0\u00a0\u00a0\u00a0 7\u00a0 write thread\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 waiting for i\/o request\r\n\u00a0\u00a0\u00a0\u00a0 8\u00a0 write thread\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 waiting for i\/o request\r\n\u00a0\u00a0\u00a0\u00a0 9\u00a0 write thread\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 waiting for i\/o request\r\n\r\n____________________________ Pending I\/O _____________________________\r\nAsync Rds\u00a0 Async Wrt\u00a0 IBuf Async Rds\u00a0 Sync I\/Os\u00a0 Log Flushes\u00a0 Log I\/Os\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\r\n\r\n________________________ File I\/O Misc _________________________\r\nOS Reads\u00a0 OS Writes\u00a0 OS fsyncs\u00a0 Reads\/Sec\u00a0 Writes\/Sec\u00a0 Bytes\/Sec\r\n\u00a0\u00a0 25807\u00a0\u00a0\u00a0\u00a0\u00a0 20496\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4738\u00a0\u00a0\u00a0\u00a0\u00a0 12.62\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 15.54\u00a0\u00a0\u00a0\u00a0\u00a0 20655\r\n\r\n______________________ Log Statistics ______________________\r\nSequence No.\u00a0 Flushed To\u00a0\u00a0\u00a0 Last Checkpoint\u00a0 IO Done\u00a0 IO\/Sec\r\n488391487586\u00a0 488391485562\u00a0 488372267940\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2329\u00a0\u00a0\u00a0 3.54<\/pre>\n
D\u30ad\u30fc\uff08\u77e2\u5370\u30ad\u30fc\u306e\u5de6\uff09\u3067\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u30e2\u30fc\u30c9<\/h3>\n
InnoDB Deadlocks (? for help)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 localhost, 14d, InnoDB 0s :-), 59.33 QPS, 46\/0\/0 con\/run\/cac thds, 5.1.73-log\r\n\r\n______________________ Deadlock Transactions ______________________\r\nID\u00a0 Timestring\u00a0 User\u00a0 Host\u00a0 Victim\u00a0 Time\u00a0 Undo\u00a0 LStrcts\u00a0 Query Text\r\n\r\n____________________ Deadlock Locks ____________________\r\nID\u00a0 Waiting\u00a0 Mode\u00a0 DB\u00a0 Table\u00a0 Index\u00a0 Special\u00a0 Ins Intent<\/pre>\n
M\u30ad\u30fc\u3067\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30e2\u30fc\u30c9\u3002<\/h3>\n
\u53c2\u8003\u30b5\u30a4\u30c8\u306e\u3088\u3046\u306b\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u4f5c\u3063\u3066\u3044\u305f\u3089\u4e00\u62ec\u3067\u898b\u308c\u308b\u3002\u7d20\u6575\u3002
\n\u3053\u3053\u3067\u306f\u4f5c\u3063\u3066\u306a\u3044\u304b\u3089\u7a7a\u3060\u3051\u3069\u306d\u3002<\/p>\n
[RO] Replication Status (? for help)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 localhost, 11m, 100.31 QPS, 45\/1\/0 con\/run\/cac thds, 5.1.73-log\r\n\r\n____________________ Slave SQL Status ____________________\r\nMaster\u00a0 On?\u00a0 TimeLag\u00a0 Catchup\u00a0 Temp\u00a0 Relay Pos\u00a0 Last Error\r\n\r\n___________ Slave I\/O Status ____________\r\nMaster\u00a0 On?\u00a0 File\u00a0 Relay Size\u00a0 Pos\u00a0 State\r\n\r\n______ Master Status _______\r\nFile\u00a0 Position\u00a0 Binlog Cache<\/pre>\n
B\u30ad\u30fc\uff08\u77e2\u5370\u30ad\u30fc\u306e\u4e0b\uff09\u3067\u30d0\u30c3\u30d5\u30a1\u30e2\u30fc\u30c9\u3002<\/h3>\n
InnoDB Buffers (? for help)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 localhost, 14d, InnoDB 0s :-), 2.01k QPS, 47\/0\/0 con\/run\/cac thds, 5.1.73-log\r\n\r\n____________________________ Buffer Pool _____________________________\r\nSize\u00a0\u00a0\u00a0 Free Bufs\u00a0 Pages\u00a0 Dirty Pages\u00a0 Hit Rate\u00a0\u00a0\u00a0\u00a0 Memory\u00a0 Add'l Pool\r\n64.00k\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0 57259\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 38287\u00a0 1000 \/ 1000\u00a0\u00a0 1.02G\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\r\n\r\n_______________________ Page Statistics ________________________\r\nReads\u00a0\u00a0\u00a0\u00a0 Writes\u00a0\u00a0\u00a0\u00a0 Created\u00a0 Reads\/Sec\u00a0 Writes\/Sec\u00a0 Creates\/Sec\r\n82398572\u00a0 184370653\u00a0 2902397\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.00\r\n\r\n_______________________ Insert Buffers ________________________\r\nInserts\u00a0\u00a0 Merged Recs\u00a0 Merges\u00a0\u00a0\u00a0 Size\u00a0 Free List Len\u00a0 Seg. Size\r\n32045780\u00a0\u00a0\u00a0\u00a0 32045439\u00a0 22191372\u00a0\u00a0\u00a0 47\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2890\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2938\r\n\r\n___________________ Adaptive Hash Index ___________________\r\nSize\u00a0\u00a0 Cells Used\u00a0 Node Heap Bufs\u00a0 Hash\/Sec\u00a0\u00a0\u00a0 Non-Hash\/Sec\r\n2.11M\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8277\u00a0 4905000.00\u00a0\u00a0\u00a0 6115000.00<\/pre>\n
C\u30ad\u30fc\uff08\u30ab\u30fc\u30bd\u30eb\u4e0b\u30ad\u30fc\uff09\u3067\u3053\u307e\u3093\u3069\u3055\u3042\u307e\u308a\u30fc\u30e2\u30fc\u30c9\u3002<\/h3>\n
[RO] Command Summary (? for help)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 localhost, 6m, 60.61 QPS, 45\/1\/0 con\/run\/cac thds, 5.1.73-log\r\n\r\n___________________ Command Summary ____________________\r\nName\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Value\u00a0 Pct\u00a0\u00a0\u00a0\u00a0 Last Incr\u00a0 Pct\r\nCom_select\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12779\u00a0 55.13%\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 247\u00a0 53.12%\r\nCom_show_status\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3410\u00a0 14.71%\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 117\u00a0 25.16%\r\nCom_update\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2081\u00a0\u00a0 8.98%\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 32\u00a0\u00a0 6.88%\r\nCom_begin\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1502\u00a0\u00a0 6.48%\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 21\u00a0\u00a0 4.52%\r\nCom_commit\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1502\u00a0\u00a0 6.48%\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 21\u00a0\u00a0 4.52%\r\nCom_insert\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 919\u00a0\u00a0 3.96%\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 24\u00a0\u00a0 5.16%\r\nCom_admin_commands\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 622\u00a0\u00a0 2.68%\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0 0.22%\r\nCom_set_option\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 136\u00a0\u00a0 0.59%\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0 0.22%\r\nCom_show_tables\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 62\u00a0\u00a0 0.27%\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0 0.22%\r\nCom_change_db\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 50\u00a0\u00a0 0.22%\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0 0.00%\r\nCom_show_engine_status\u00a0\u00a0\u00a0\u00a0 39\u00a0\u00a0 0.17%\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0 0.00%<\/pre>\n
\u3053\u306e\u3088\u3046\u306b\u8272\u3005\u3068\u4f7f\u3044\u9053\u304c\u3042\u308a\u305d\u3046\u3067\u3001\u3056\u3063\u3068\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u30ad\u30fc\u3067\u898b\u305f\u611f\u3058\u3067\u3082\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u306e\u6642\u306b\u3082\u91cd\u5b9d\u3059\u308b\u306e\u3067\u306f\u306a\u3044\u304b\u3068\u307f\u3089\u308c\u308b\u3002
\n\u65e5\u3005\u306e\u904b\u7528\u7ba1\u7406\u306b\u3082\u4f7f\u3048\u308b\u3067\u3042\u308d\u3046\u3002
\n\u3067\u306f\u672c\u756a\u30b5\u30fc\u30d0\u30fc\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3088\u3046\u3068\u601d\u3044\u307e\u3059\uff01<\/p>\n
\u4eca\u65e5\u306f\u3053\u3053\u307e\u3067\u3063\u3059\u3002<\/p>\n
 <\/p>\n
        
Tweet<\/a><\/div><\/div>\n
\n","protected":false},"excerpt":{"rendered":"
Innotop \u3063\u3066\u4f55\u306c\u306d\u306e Linux\u306bTop\u3068\u3044\u3046\u30b3\u30de\u30f3\u30c9\u304c\u3042\u308b\u3002Windows\u3067\u3044\u3046\u3068\u3053\u308d\u306e\u30bf\u30b9\u30af\u30de\u30cd\u30fc\u30b8\u30e3\u306e\u3088\u3046\u306b\u3001\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u3067\u72b6\u6cc1\u78ba\u8a8d\u3059\u308b\u305f\u3081\u306e\u57fa\u672c\u30b3\u30de\u30f3\u30c9\u3060\u3002\u305d\u3057\u3066Mytop\u3068\u3044\u3046MySQL\u7248Top\u30b3\u30de\u30f3\u30c9 … “Innotop\u3092\u5165\u308c\u3066\u307f\u308b” \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-4459","post","type-post","status-publish","format-standard","hentry","category-server"],"_links":{"self":[{"href":"https:\/\/www.vincentina.net\/index.php?rest_route=\/wp\/v2\/posts\/4459","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vincentina.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.vincentina.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.vincentina.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vincentina.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4459"}],"version-history":[{"count":0,"href":"https:\/\/www.vincentina.net\/index.php?rest_route=\/wp\/v2\/posts\/4459\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.vincentina.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4459"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vincentina.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4459"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vincentina.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4459"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}