Fi Mtop sori ẹrọ (MySQL Abojuto Abojuto data data) ni RHEL/CentOS 6/5/4, Fedora 17-12

mtop (MySQL oke) jẹ akoko ṣiṣi orisun gidi akoko eto ibojuwo Server MYSQL ti a kọ ni ede Perl ti o fihan awọn ibeere ti o gba akoko to gun lati ṣe ilana ati pa awọn ibeere to gun wọnyẹn lẹhin nọmba kan ti akoko pàtó kan. Eto Mtop jẹ ki a ṣe atẹle ati idanimọ iṣẹ ati awọn ọran ti o jọmọ ti MySQL Server lati inu wiwo laini aṣẹ ti o jọra Linux Top Command.

Mtop pẹlu ẹya sisun ti o ṣe afihan alaye ti o dara ju ibeere ti awọn ibeere ṣiṣe ati pipa awọn ibeere, o tun fihan awọn iṣiro ti olupin, alaye iṣeto ati diẹ ninu awọn imọran yiyi to wulo lati je ki ilọsiwaju iṣẹ MySQL wa daradara.

Jọwọ ṣayẹwo diẹ ninu awọn ẹya wọnyi ti a funni nipasẹ eto Mtop.

  1. Ṣafihan akoko gidi awọn ibeere olupin MySQL.
  2. Pese alaye iṣeto MySQL.
  3. Sisun ẹya lati ṣafihan ibeere ilana.
  4. Pese alaye Optimizer ibeere fun ibeere ati awọn ibeere ‘pipa’.
  5. Pese awọn imọran tuning MySQL.
  6. Agbara lati fipamọ ifipamọ ni faili iṣeto .mtoprc kan.
  7. Pese oju-iwe iṣeduro Sysadmin (‘T‘).
  8. Awọn ibeere ti a ṣafikun/keji si akọsori akọkọ.
    9. Fikun-un fun alaye keji si iboju awọn iṣiro.

Ninu nkan yii a yoo fihan bi a ṣe le fi sori ẹrọ eto Mtop (MySQL Top) labẹ RHEL 6.3/6.2/6.1/6/5.8/5.6/4.0, CentOS 6.3/6.2/6.1/6/5.8/5.6/4.0 ati Fedora 17,16,15,14,13,12 lilo ibi ipamọ RPMForge nipasẹ YUM Command.

Jeki Ibi ipamọ RPMForge ni RHEL/CentOS 6/5/4 ati Fedora 17-12

Ni akọkọ, o nilo lati mu ibi ipamọ RPMForge ṣiṣẹ labẹ ẹrọ Lainos rẹ lati ṣe igbasilẹ ati fi ẹya tuntun ti eto MTOP sori ẹrọ.

Yan awọn ọna asopọ wọnyi ti o da lori faaji Linux rẹ lati jẹ ki ibi ipamọ RPMforge wa labẹ apoti Linux rẹ. (Akiyesi: Olumulo Fedora ko nilo lati jẹki eyikeyi ibi ipamọ labẹ apoti Fedora).

# wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.i686.rpm
# rpm -Uvh rpmforge-release-0.5.2-2.el6.rf.i686.rpm
# wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
# rpm -Uvh rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
# wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.i386.rpm
# rpm -Uvh rpmforge-release-0.5.2-2.el5.rf.i386.rpm
# wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.x86_64.rpm
# rpm -Uvh rpmforge-release-0.5.2-2.el5.rf.x86_64.rpm
# wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el4.rf.i386.rpm
# rpm -Uvh rpmforge-release-0.5.2-2.el4.rf.i386.rpm
# wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el4.rf.x86_64.rpm
# rpm -Uvh rpmforge-release-0.5.2-2.el4.rf.x86_64.rpm

Gbe Kokoro Ibi ipamọ RPMorge wọle ni RHEL/CentOS 6/5/4

# wget http://dag.wieers.com/rpm/packages/RPM-GPG-KEY.dag.txt
# rpm --import RPM-GPG-KEY.dag.txt

Fi Mtop sori ẹrọ ni RHEL/CentOS 6/5/4 ati Fedora 17-12

Lọgan ti o ba ti fi sii ti o si mu ibi ipamọ RPMForge ṣiṣẹ, jẹ ki a fi MTOP sii nipa lilo atẹle aṣẹ YUM.

# yum install mtop
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
rpmforge                                                                          | 1.9 kB     00:00
rpmforge/primary_db                                                                 2.6 MB     00:19
Setting up Install Process
Dependencies Resolved

================================================================================================================
 Package                       Arch				Version					Repository				Size
================================================================================================================
Installing:
 mtop                          noarch           0.6.6-1.2.el6.rf        rpmforge                52 k
Installing for dependencies:
 perl-Curses                   i686             1.28-1.el6.rf           rpmforge                156 k

Transaction Summary
================================================================================================================
Install       2 Package(s)

Total download size: 208 k
Installed size: 674 k
Is this ok [y/N]: y
Downloading Packages:
(1/2): mtop-0.6.6-1.2.el6.rf.noarch.rpm                                           |  52 kB     00:00
(2/2): perl-Curses-1.28-1.el6.rf.i686.rpm                                         | 156 kB     00:01
-----------------------------------------------------------------------------------------------------------------
Total                                                                     46 kB/s | 208 kB     00:04
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
  Installing : perl-Curses-1.28-1.el6.rf.i686													1/2
  Installing : mtop-0.6.6-1.2.el6.rf.noarch                                                     2/2
  Verifying  : perl-Curses-1.28-1.el6.rf.i686                                                   1/2
  Verifying  : mtop-0.6.6-1.2.el6.rf.noarch                                                     2/2

Installed:
  mtop.noarch 0:0.6.6-1.2.el6.rf

Dependency Installed:
  perl-Curses.i686 0:1.28-1.el6.rf

Complete!

Bibẹrẹ Mtop ni RHEL/CentOS 6/5/4

Lati bẹrẹ eto Mtop, o nilo lati sopọ si olupin MySQL rẹ, ni lilo pipaṣẹ atẹle.

# mysql -u root -p

Lẹhinna o nilo lati ṣẹda olumulo ti o yatọ ti a npe ni mysqltop ati fifun awọn anfani si ọdọ rẹ labẹ olupin MySQL rẹ. Lati ṣe, eyi kan ṣiṣe awọn ofin wọnyi ni ikarahun mysql.

mysql> grant super, reload, process on *.* to mysqltop;
Query OK, 0 rows affected (0.00 sec)

mysql> grant super, reload, process on *.* to [email ;
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> quit;
Bye

Ṣiṣe Mtop ni RHEL/CentOS 6/5/4

Jẹ ki a bẹrẹ eto Mtop nipa ṣiṣe pipaṣẹ isalẹ. Iwọ yoo wo iṣapẹẹrẹ apẹẹrẹ iru si isalẹ.

# mtop
load average: 0.01, 0.00, 0.00 mysqld 5.1.61 up 5 day(s), 19:21 hrs
2 threads: 1 running, 0 cached. Queries/slow: 5/0 Cache Hit: 71.43%
Opened tables: 0  RRN: 277  TLW: 0  SFJ: 0  SMP: 0  QPS: 0

ID       USER     HOST         DB       TIME   COMMAND STATE        INFO
322081   mysqltop localhost						Query				show full processlist

Atẹle Latọna MySQL Server nipa lilo Mtop

Nìkan, tẹ aṣẹ atẹle lati ṣe atẹle eyikeyi olupin MySQL latọna jijin.

# mtop  –host=remotehost –dbuser=username –password=password –seconds=1

Lilo Mtop ati Awọn iṣẹ

Jọwọ lo awọn bọtini atẹle lakoko mtop n ṣiṣẹ.

  1. s - yi nọmba awọn aaya pada lati ṣe idaduro laarin awọn imudojuiwọn
  2. m - yiyi ipo itun pada ni titan/pipa
  3. d - ifihan àlẹmọ pẹlu ikosile deede (olumulo/agbalejo/db/pipaṣẹ/ipinle/alaye)
  4. F - agbo/ṣii awọn orukọ iwe ni yiyan ifihan alaye
  5. h - ilana ifihan fun alejo kan ṣoṣo
  6. u - ilana ifihan fun olumulo kan ṣoṣo
  7. i - yi gbogbo rẹ pada/ti kii ṣe ilana ilana sisun sisun
  8. o - yiyipada irufẹ iru
  9. q - olodun-
  10. ? - iranlọwọ

Fun awọn aṣayan diẹ sii ati lilo jọwọ wo awọn oju-iwe eniyan ti aṣẹ mtop nipasẹ ṣiṣe “man mtop” lori ebute.