{"id":3093,"date":"2017-07-03T09:10:45","date_gmt":"2017-07-03T04:40:45","guid":{"rendered":"https:\/\/www.host97.net\/?p=3093"},"modified":"2023-01-12T09:56:06","modified_gmt":"2023-01-12T06:26:06","slug":"%d9%85%d8%a7%d9%86%db%8c%d8%aa%d9%88%d8%b1-%d8%af%db%8c%d8%aa%d8%a7%d8%a8%db%8c%d8%b3-mysql-%d8%a8%d8%a7-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-%d8%a7%d8%a8%d8%b2%d8%a7%d8%b1-mytop","status":"publish","type":"post","link":"https:\/\/host97.net\/wiki\/%d9%85%d8%a7%d9%86%db%8c%d8%aa%d9%88%d8%b1-%d8%af%db%8c%d8%aa%d8%a7%d8%a8%db%8c%d8%b3-mysql-%d8%a8%d8%a7-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-%d8%a7%d8%a8%d8%b2%d8%a7%d8%b1-mytop\/","title":{"rendered":"\u0645\u0627\u0646\u06cc\u062a\u0648\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 MySQL \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u0628\u0632\u0627\u0631 Mytop"},"content":{"rendered":"

Mytop<\/strong> \u06cc\u06a9 \u0627\u0628\u0632\u0627\u0631 \u0631\u0627\u06cc\u06af\u0627\u0646 \u0645\u062a\u0646 \u0628\u0627\u0632 \u0628\u0631\u0627\u06cc \u0645\u0627\u0646\u06cc\u062a\u0648\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 MySQL<\/strong><\/a> \u0645\u06cc\u0628\u0627\u0634\u062f \u06a9\u0647 \u062a\u0648\u0633\u0637 Jeremy Zawodny \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0632\u0628\u0627\u0646 Perl \u0646\u0648\u0634\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a. \u0627\u06cc\u0646 \u0627\u0628\u0632\u0627\u0631 \u0645\u0634\u0627\u0628\u0647 \u0627\u0628\u0632\u0627\u0631 \u0645\u0627\u0646\u06cc\u062a\u0648\u0631\u06cc\u0646\u06af \u0644\u06cc\u0646\u0648\u06a9\u0633\u06cc \u0627\u0633\u062a \u06a9\u0647 top \u0646\u0627\u0645\u06cc\u062f\u0647 \u0645\u06cc\u0634\u0648\u062f. Mytop \u06cc\u06a9 \u0645\u062d\u06cc\u0637\u00a0Command-line \u0628\u0631\u0627\u06cc \u0645\u0627\u0646\u06cc\u062a\u0648\u0631 \u0644\u062d\u0638\u0647 \u0627\u06cc \u0648\u0636\u0639\u06cc\u062a \u0645\u0648\u0627\u0631\u062f\u06cc \u0645\u0627\u0646\u0646\u062f: MySQL threade, Queries per second \u0648 Performance \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0641\u0631\u0627\u0647\u0645 \u06a9\u0631\u062f\u0647 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u06a9\u0645\u06a9 \u0627\u0646 \u0627\u062f\u0645\u06cc\u0646 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0645\u06cc\u062a\u0648\u0627\u0646\u062f \u0633\u0631\u0648\u0631 \u0631\u0627 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0641\u0634\u0627\u0631 \u06a9\u0627\u0631\u06cc \u0628\u0647\u06cc\u0646\u0647 \u0633\u0627\u0632\u06cc \u0646\u0645\u0627\u06cc\u062f.<\/p>\n

\"\"<\/p>\n

\u0628\u0635\u0648\u0631\u062a \u067e\u06cc\u0634\u0641\u0631\u0636 Mytop \u062f\u0631 \u0645\u062e\u0632\u0646 \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631\u06cc Fedora \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f\u060c \u067e\u0633 \u062a\u0646\u0647\u0627 \u0628\u0631\u0627\u06cc \u0646\u0635\u0628 \u06a9\u0627\u0641\u06cc\u0633\u062a \u062f\u0633\u062a\u0648\u0631 yum install mytop \u0631\u0627 \u062f\u0631 \u062e\u0637 \u0641\u0631\u0645\u0627\u0646 \u0648\u0627\u0631\u062f \u0646\u0645\u0627\u06cc\u06cc\u062f. \u062f\u0631 \u0635\u0648\u0631\u062a\u06cc \u06a9\u0647 \u0627\u0632 RHEL \u06cc\u0627 CentOS \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u06a9\u0646\u06cc\u062f \u0628\u0627\u06cc\u062f \u0627\u0628\u062a\u062f\u0627 \u0645\u062e\u0632\u0646 \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631\u06cc \u0645\u0627\u0646\u0646\u062f EPEL \u06cc\u0627 RPMForge \u0631\u0627 \u0646\u0635\u0628 \u0648 \u0641\u0639\u0627\u0644 \u0646\u0645\u0627\u06cc\u06cc\u062f \u062a\u0627 \u0628\u062a\u0648\u0627\u0646\u06cc\u062f Mytop \u0631\u0627 \u0628\u0647 \u0631\u0627\u062d\u062a\u06cc \u0646\u0635\u0628 \u0646\u0645\u0627\u06cc\u06cc\u062f. \u0628\u0647 \u0637\u0648\u0631 \u0645\u062b\u0627\u0644 \u0628\u0627 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0645\u062e\u0632\u0646 \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631\u06cc EPEL \u062f\u0631 CentOS \u0646\u0635\u0628 \u0648 \u0641\u0639\u0627\u0644 \u062e\u0648\u0627\u0647\u062f \u0634\u062f:<\/p>\n

yum install epel-release<\/pre>\n
\u062f\u0631 \u062a\u0648\u0636\u06cc\u0639 \u0647\u0627\u06cc Debian,Ubuntu \u0648 Fedora \u0646\u06cc\u0627\u0632\u0647 \u0628\u0647 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u0645\u062e\u0631\u0646 \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631\u06cc \u0646\u0645\u06cc\u0628\u0627\u0634\u062f. \u062a\u0648\u062c\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u0642\u0628\u0644 \u0627\u0632 \u0646\u0635\u0628 \u0627\u06cc\u0646 \u0627\u0628\u0632\u0627\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 MySQL \u0628\u0627\u06cc\u062f \u0631\u0648\u06cc \u0633\u0631\u0648\u0631 \u0646\u0635\u0628 \u0648 \u0641\u0639\u0627\u0644 \u0634\u062f\u0647 \u0628\u0627\u0634\u062f.<\/p>\n
\u0646\u0635\u0628 Mytop \u0628\u0631 \u0631\u0648\u06cc \u062a\u0648\u0636\u06cc\u0639 \u0647\u0627\u06cc CentOS, RHEL, Debian Ubuntu \u0648 Fedora<\/h3>\n
\u0628\u0631\u0627\u06cc \u0646\u0635\u0628 Mytop \u062f\u0631 \u0644\u06cc\u0646\u0648\u06a9\u0633 \u06a9\u0627\u0641\u06cc\u0633\u062a \u0628\u0627 \u062a\u0648\u062c\u0647 \u0628\u0647 \u062a\u0648\u0636\u06cc\u0639 \u0633\u06cc\u0633\u062a\u0645 \u0639\u0627\u0645\u0644 \u062e\u0648\u062f \u062f\u0633\u062a\u0648\u0631\u06cc \u06a9\u0647 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645 \u0639\u0627\u0645\u0644 \u0634\u0645\u0627\u0633\u062a \u0631\u0627 \u062f\u0631 \u0645\u062d\u06cc\u0637 Command-line \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0647 \u0648 Enter \u0631\u0627 \u0628\u0632\u0646\u06cc\u062f.<\/p>\n
$ yum install mytop    [On RHEL\/CentOS\/Fedora]\r\n$ dnf install mytop      [On Fedora]\r\n$ apt-get install mytop  [On Debian\/Ubuntu\/Mint]<\/pre>\n
\u067e\u0633 \u0627\u0632 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 \u062f\u0633\u062a\u0648\u0631 \u0646\u0635\u0628 \u062e\u0631\u0648\u062c\u06cc \u0628\u0635\u0648\u0631\u062a \u0632\u06cc\u0631 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f:<\/p>\n
Loaded plugins: fastestmirror, refresh-packagekit\r\nLoading mirror speeds from cached hostfile\r\nSetting up Install Process\r\nResolving Dependencies\r\nDependencies Resolved\r\n=======================================================================================\r\nPackage\t\t\tArch\t\tVersion\t\t\t\t\tRepository\t\t\tSize\r\n=======================================================================================\r\nInstalling:\r\nmytop              noarch       1.7-3.b737f60.el6      epel                32 k\r\nTransaction Summary\r\n=======================================================================================\r\nInstall       1 Package(s)\r\nTotal download size: 32 k\r\nInstalled size: 68 k\r\nIs this ok [y\/N]: y\r\nDownloading Packages:\r\nmytop-1.7-3.b737f60.el6.noarch.rpm\t\t                        |  \u06f3\u06f2 kB     00:00\r\nRunning rpm_check_debug\r\nRunning Transaction Test\r\nTransaction Test Succeeded\r\nRunning Transaction\r\nInstalling : mytop-1.7-3.b737f60.el6.noarch\t\t\t\t\t\t\t\t\t\u06f1\/\u06f1\r\nVerifying  : mytop-1.7-3.b737f60.el6.noarch\t\t\t\t\t\t\t\t\t\u06f1\/\u06f1\r\nInstalled:\r\nmytop.noarch 0:1.7-3.b737f60.el6\r\nComplete!<\/pre>\n
\u0646\u062d\u0648\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Mytop \u0628\u0631\u0627\u06cc \u0645\u0627\u0646\u06cc\u062a\u0648\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 MySQL<\/h3>\n
\u0628\u0631\u0627\u06cc \u0634\u0631\u0648\u0639 \u0628\u0647 \u06a9\u0627\u0631 \u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u0627\u0628\u0632\u0627\u0631 \u0628\u0627\u06cc\u062f \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0648\u0631\u0648\u062f \u0628\u0647 mysql \u0631\u0627 \u062f\u0631 \u0627\u062e\u062a\u06cc\u0627\u0631 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f. \u0628\u0631\u0627\u06cc \u0634\u0631\u0648\u0639 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0631 \u0645\u062d\u06cc\u0637 Command-line \u0648\u0627\u0631\u062f \u0646\u0645\u0627\u06cc\u06cc\u062f:<\/p>\n
mytop --prompt<\/pre>\n
\u067e\u0633 \u0627\u0632 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646\u00a0\u062f\u0633\u062a\u0648\u0631 \u0628\u0627\u0644\u0627\u060c \u067e\u0633\u0648\u0648\u0631\u062f \u0627\u0632 \u0634\u0645\u0627 \u062e\u0648\u0627\u0633\u062a\u0647 \u0645\u06cc \u0634\u0648\u062f \u06a9\u0647 \u0628\u0627\u06cc\u062f \u067e\u0633\u0648\u0648\u0631\u062f root \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 MySQL \u0631\u0627 \u0648\u0627\u0631\u062f \u0646\u0645\u0627\u06cc\u06cc\u062f. \u062f\u0631 \u063a\u06cc\u0631 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a Mytop \u0642\u0627\u0628\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0646\u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f.<\/p>\n
# mytop --prompt\r\nPassword:<\/pre>\n
\u067e\u0633 \u0627\u0632 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 \u067e\u0633\u0648\u0648\u0631\u062f \u0633\u06cc\u0633\u062a\u0645 \u0645\u0627\u0646\u06cc\u062a\u0648\u0631\u06cc\u06af Mytop \u0631\u0627 \u0645\u0634\u0627\u0647\u062f\u0647 \u062e\u0648\u0627\u0647\u06cc\u062f \u06a9\u0631\u062f. \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0635\u0641\u062d\u0647 \u0645\u0634\u0627\u0647\u062f\u0647 \u0634\u062f\u0647 \u0645\u0627\u0646\u0646\u062f \u062a\u0635\u0648\u06cc\u0631 \u0632\u06cc\u0631 \u0628\u0627\u0634\u062f:<\/p>\n
\"\u0645\u0627\u0646\u06cc\u062a\u0648\u0631
\u0645\u0627\u0646\u06cc\u062a\u0648\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633<\/figcaption><\/figure>\n
\u0628\u0631\u0627\u06cc \u0645\u0627\u0646\u06cc\u062a\u0648\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0645\u0634\u062e\u0635 \u0645\u06cc\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0641\u0644\u06af d- \u0648 \u0645\u0634\u062e\u0635 \u06a9\u0631\u062f\u0646 \u0646\u0627\u0645\u00a0 \u0627\u0646\u060c \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u062e\u0648\u062f \u0631\u0627 \u0645\u0627\u0646\u06cc\u062a\u0648\u0631 \u0646\u0645\u0627\u06cc\u06cc\u062f. \u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 wikidb \u0631\u0627 \u0645\u0627\u0646\u06cc\u062a\u0648\u0631 \u0645\u06cc\u06a9\u0646\u062f:<\/p>\n
# mytop --prompt -d\u00a0name\r\nPassword:<\/pre>\n
\u0627\u06cc\u0646 \u0627\u0628\u0632\u0627\u0631 \u0645\u0627\u0646\u06cc\u062a\u0648\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062f\u0627\u0631\u0627\u06cc shortcut \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u06cc \u0628\u0648\u062f\u0647 \u0648 \u0645\u06cc\u062a\u0648\u0627\u0646\u062f \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0628\u0633\u06cc\u0627\u0631 \u0632\u06cc\u0627\u062f\u06cc \u0631\u0627 \u062f\u0631 \u0627\u062e\u062a\u06cc\u0627\u0631 \u0627\u062f\u0645\u06cc\u0646 \u0642\u0631\u0627\u0631 \u062f\u0647\u062f. \u0628\u0631\u0627\u06cc \u0627\u0637\u0644\u0627\u0639 \u0627\u0632 \u062a\u0645\u0627\u0645\u06cc \u0627\u0645\u06a9\u0627\u0646\u0627\u062a Mytop \u067e\u06cc\u0634\u0646\u0647\u0627\u062f \u0645\u06cc\u0634\u0648\u062f \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 man mytop \u062f\u0631 command-line \u0631\u0627\u0647\u0646\u0645\u0627\u06cc<\/a> \u0627\u06cc\u0646 \u0627\u0628\u0632\u0627\u0631 \u0631\u0627 \u0645\u0637\u0627\u0644\u0639\u0647 \u0646\u0645\u0627\u06cc\u06cc\u062f.<\/p>\n","protected":false},"excerpt":{"rendered":"
Mytop \u06cc\u06a9 \u0627\u0628\u0632\u0627\u0631 \u0631\u0627\u06cc\u06af\u0627\u0646 \u0645\u062a\u0646 \u0628\u0627\u0632 \u0628\u0631\u0627\u06cc \u0645\u0627\u0646\u06cc\u062a\u0648\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 MySQL \u0645\u06cc\u0628\u0627\u0634\u062f \u06a9\u0647 \u062a\u0648\u0633\u0637 Jeremy Zawodny \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0632\u0628\u0627\u0646 Perl \u0646\u0648\u0634\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a. \u0627\u06cc\u0646 \u0627\u0628\u0632\u0627\u0631 \u0645\u0634\u0627\u0628\u0647 \u0627\u0628\u0632\u0627\u0631 \u0645\u0627\u0646\u06cc\u062a\u0648\u0631\u06cc\u0646\u06af \u0644\u06cc\u0646\u0648\u06a9\u0633\u06cc \u0627\u0633\u062a \u06a9\u0647 top \u0646\u0627\u0645\u06cc\u062f\u0647 \u0645\u06cc\u0634\u0648\u062f. Mytop \u06cc\u06a9 \u0645\u062d\u06cc\u0637\u00a0Command-line \u0628\u0631\u0627\u06cc \u0645\u0627\u0646\u06cc\u062a\u0648\u0631 \u0644\u062d\u0638\u0647 \u0627\u06cc \u0648\u0636\u0639\u06cc\u062a \u0645\u0648\u0627\u0631\u062f\u06cc \u0645\u0627\u0646\u0646\u062f: MySQL threade, Queries per second \u0648 Performance \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0641\u0631\u0627\u0647\u0645 \u06a9\u0631\u062f\u0647 \u0627\u0633\u062a […]<\/p>\n","protected":false},"author":2,"featured_media":4632,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[89],"tags":[153,532,151,533],"class_list":["post-3093","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-mysql","tag-mytop","tag-151","tag-533"],"_links":{"self":[{"href":"https:\/\/host97.net\/wiki\/wp-json\/wp\/v2\/posts\/3093","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/host97.net\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/host97.net\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/host97.net\/wiki\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/host97.net\/wiki\/wp-json\/wp\/v2\/comments?post=3093"}],"version-history":[{"count":2,"href":"https:\/\/host97.net\/wiki\/wp-json\/wp\/v2\/posts\/3093\/revisions"}],"predecessor-version":[{"id":4623,"href":"https:\/\/host97.net\/wiki\/wp-json\/wp\/v2\/posts\/3093\/revisions\/4623"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/host97.net\/wiki\/wp-json\/wp\/v2\/media\/4632"}],"wp:attachment":[{"href":"https:\/\/host97.net\/wiki\/wp-json\/wp\/v2\/media?parent=3093"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/host97.net\/wiki\/wp-json\/wp\/v2\/categories?post=3093"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/host97.net\/wiki\/wp-json\/wp\/v2\/tags?post=3093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}