Shigar da Mtop (MySQL Database Server Monitoring) a cikin RHEL/CentOS 6/5/4, Fedora 17-12

mtop (MySQL top) buɗaɗɗen tushe ne na ainihin lokacin sa ido na MYSQL Server wanda aka rubuta cikin yaren Perl wanda ke nuna tambayoyin da suke ɗaukar lokaci mai tsawo don aiwatarwa da kuma kashe waɗancan tambayoyin masu tsayi bayan takamaiman adadin lokaci. Shirin Mtop yana bamu damar saka idanu da gano ayyukan da kuma abubuwan da suka shafi MySQL Server daga layin layin umarni kama da Linux Top Command.

Mtop ya haɗa da fasalin zuƙowa wanda ke ba da bayanin ingantaccen bayani game da tambayoyi masu gudana da kashe tambayoyi, hakanan yana nuna ƙididdigar sabar, bayanan daidaitawa da kuma wasu shawarwari masu amfani don daidaita ayyukan MySQL da inganta su.

Da fatan za a bincika wasu siffofin masu zuwa waɗanda shirin Mtop ya bayar.

  1. Nuna ainihin lokacin tambayoyin uwar garken MySQL.
  2. Yana bayar da bayanan daidaitawa na MySQL.
  3. fasalin zuƙowa don nuna tambayar aikin.
  4. Yana bayar da bayanin Ingantaccen bayani don tambaya da tambayoyin ‘kashewa.
  5. Yana bayar da dubaru na daidaitawa na MySQL.
  6. Ikon adana fitarwa a cikin fayil ɗin sanyi .mtoprc.
  7. Yana bayar da Shawarwarin Sysadmin ('T').
  8. Karin tambayoyi/na biyu zuwa babban kanun labarai.
  9. An ƙara kowane bayani na biyu zuwa allon stats.

A cikin wannan labarin zamu nuna yadda ake girka Mtop (MySQL Top) shirin a ƙarƙashin 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 da Fedora 17,16,15,14,13,12 ta amfani da wurin ajiyar RPMForge ta hanyar YUM Command.

Enable RPMForge Ajiye a RHEL/CentOS 6/5/4 da Fedora 17-12

Da farko, kuna buƙatar kunna wurin ajiyar RPMForge a ƙarƙashin mashin ɗinku na Linux don saukewa da shigar da sabon fasalin shirin MTOP.

Zaɓi waɗannan haɗin haɗin da ke kan tsarin gine-ginen Linux don kunna wurin ajiyar RPMforge ƙarƙashin akwatin Linux ɗinku. (Lura: Mai amfani da Fedora baya buƙatar kunna wata ma'ajiya a ƙarƙashin akwatin 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

Shigo da Maɓallin Ma'aji na RPMorge a cikin RHEL/CentOS 6/5/4

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

Sanya Mtop a cikin RHEL/CentOS 6/5/4 da Fedora 17-12

Da zarar ka girka kuma ka kunna wurin ajiyar RPMForge, bari mu girka MTOP ta amfani da bin umarnin 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!

Fara Mtop a cikin RHEL/CentOS 6/5/4

Don fara shirin Mtop, kuna buƙatar haɗi zuwa sabar MySQL ɗinku, ta amfani da umarni masu zuwa.

# mysql -u root -p

Don haka kuna buƙatar ƙirƙirar mai amfani daban mai suna mysqltop kuma ku ba shi gata a ƙarƙashin sabar MySQL ɗinku. Don yin, wannan kawai gudanar da waɗannan umarnin a cikin mysql shell.

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

Gudun Mtop a cikin RHEL/CentOS 6/5/4

Bari mu fara shirin Mtop ta aiwatar da umarnin ƙasa. Za ku ga samfurin fitarwa kwatankwacin ƙasa.

# 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

Saka idanu Nesa MySQL Server ta amfani da Mtop

A sauƙaƙe, rubuta irin umarnin don saka idanu duk wani sabar MySQL Server.

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

Mtop Amfani da Ayyuka

Da fatan za a yi amfani da maɓallan masu zuwa yayin da mtop ke gudana.

  1. s - canza adadin dakika don jinkirtawa tsakanin ɗaukakawa
  2. m - kunna/kashe yanayin wartsakewar hannu
  3. d - nuna nuni tare da bayyana ta yau da kullun (mai amfani/mai watsa shiri/db/umarni/jiha/bayani)
  4. F - ninki/buɗe sunayen shafi a zaɓin bayanin sanarwa
  5. h - tsarin nunawa don mai gida ɗaya kacal
  6. u - tsarin nunawa don mai amfani ɗaya kawai
  7. i - kunna duk/ba aikin aikin bacci ba
  8. o - juya tsarin tsari
  9. q - sallama
  10. ? - taimako

Don ƙarin zaɓuɓɓuka da amfani don Allah a duba shafukan mutum na umarnin mtop ta hanyar gudanar da “man mtop” a tashar.