Mytop - Kayan aiki Mai Amfani don Kula da Ayyukan MySQL/MariaDB a cikin Linux


Mytop buɗaɗɗen tushe ne kuma shirin sa ido na kyauta don MySQL da bayanan bayanan MariaDB Jeremy Zawodny ne ya rubuta ta ta amfani da harshen Perl. Ya yi kama da kamanni da jin daɗin sanannen kayan aikin sa ido na tsarin Linux da ake kira saman.

Shirin Mytop yana ba da ƙirar ƙirar harsashi na umarni don saka idanu ainihin zaren MySQL/MariaDB, tambayoyin daƙiƙa ɗaya, jerin tsari da aikin bayanan bayanai kuma yana ba da ra'ayi ga mai sarrafa bayanai don inganta sabar don ɗaukar nauyi mai nauyi.

Ta hanyar tsoho kayan aikin Mytop an haɗa su a cikin ma'ajiyar Fedora da Debian/Ubuntu, don haka kawai dole ne ka shigar da shi ta amfani da tsoho mai sarrafa fakitin ku.

Idan kuna amfani da rarrabawar RHEL/CentOS, to kuna buƙatar kunna maajiyar EPEL ta ɓangare na uku don shigar da shi.

Don sauran rarrabawar Linux zaku iya samun fakitin tushen mytop kuma ku tattara shi daga tushe kamar yadda aka nuna.

# wget http://jeremy.zawodny.com/mysql/mytop/mytop-1.6.tar.gz
# tar -xvf mytop-1.6.tar.gz
# cd mytop-1.6
# perl Makefile.PL
# make
# make test
# make install

A cikin wannan koyawa na saka idanu na MySQL, za mu nuna muku yadda ake shigarwa, daidaitawa da amfani da mytop akan rarrabawar Linux daban-daban.

Lura cewa dole ne ku sami uwar garken MariaDB akan tsarin don shigarwa da amfani da Mytop.

Sanya Mytop a cikin Linux Systems

Don shigar da Mytop, gudanar da umarnin da ya dace a ƙasa don rarraba Linux ɗin ku don shigar da shi.

$ sudo apt install mytop	#Debian/Ubuntu
# yum install mytop	        #RHEL/CentOS
# dnf install mytop	        #Fedora 22+
# pacman -S mytop	        #Arch Linux 
# zypper in mytop	        #openSUSE
Loaded plugins: changelog, fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.linode.com
 * epel: mirror.freethought-internet.co.uk
 * extras: mirrors.linode.com
 * updates: mirrors.linode.com
Resolving Dependencies
--> Running transaction check
---> Package mytop.noarch 0:1.7-10.b737f60.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==============================================================================================================================================================================
 Package                               Arch                                   Version                                              Repository                            Size
==============================================================================================================================================================================
Installing:
 mytop                                 noarch                                 1.7-10.b737f60.el7                                   epel                                  33 k

Transaction Summary
==============================================================================================================================================================================
Install  1 Package

Total download size: 33 k
Installed size: 68 k
Is this ok [y/d/N]: y

Yadda ake amfani da Mytop don saka idanu MySQL/MariaDB

Mytop yana buƙatar takaddun shaidar shiga MySQL/MariaDB don saka idanu bayanan bayanai kuma ya haɗa zuwa uwar garken tare da tushen sunan mai amfani ta tsohuwa. Kuna iya ƙayyade zaɓuɓɓukan da suka dace don haɗawa zuwa uwar garken bayanai akan layin umarni yayin da kuke gudanar da shi ko a cikin fayil ~/.mytop (don dacewa kamar yadda aka bayyana daga baya).

Kawai gudanar da umarni mai zuwa don fara mytop kuma samar da tushen kalmar sirrin mai amfani na MySQL/MariaDB, lokacin da aka sa. Wannan zai haɗa zuwa bayanan gwajin ta tsohuwa.

# mytop --prompt
Password:

Da zarar kun shigar da kalmar sirri ta MySQL za ku ga harsashi na saka idanu na Mytop, kama da ƙasa.

Idan kuna son saka idanu takamaiman bayanan bayanai, to yi amfani da zaɓin -d kamar yadda aka nuna a ƙasa. Misali umarnin da ke ƙasa zai saka idanu tecmint database.

# mytop --prompt -d tecmint
Password:

Idan kowane ma'adanin bayananku yana da takamaiman admin (misali tecmint database admin), to sai ku haɗa ta amfani da sunan mai amfani da bayanai da kalmar sirri kamar haka.

# mytop -u tecmint -p password_here -d tecmintdb

Koyaya, wannan yana da wasu abubuwan tsaro tunda ana buga kalmar sirrin mai amfani akan layin umarni kuma ana iya adana shi a cikin fayil ɗin tarihin umarnin harsashi. Mutum mara izini na iya duba wannan fayil daga baya wanda zai iya sauka akan sunan mai amfani da kalmar wucewa.

Don guje wa haɗarin irin wannan yanayin, yi amfani da fayil ɗin daidaitawa ~/.mytop don tantance zaɓuɓɓukan haɗi zuwa bayanan bayanai. Wani fa'idar wannan hanyar ita ce ku ma kawar da buga muhawarar layin umarni da yawa duk lokacin da kuke son gudanar da mytop.

# vi ~/.mytop

Sa'an nan kuma ƙara zaɓuɓɓukan da suka dace a ƙasa a ciki.

user=root
pass=password_here
host=localhost
db=test
delay=4
port=3306
socket=

Ajiye kuma rufe fayil ɗin. Sannan gudanar da mytop ba tare da gardamar layin umarni ba.

# mytop

Yana da ikon nuna babban adadin bayanai akan allon kuma yana da zaɓuɓɓukan gajeriyar hanyar keyboard da yawa kuma, duba man mytop don ƙarin bayani.

# man mytop

  1. Mtop (MySQL Database Monitoring) a cikin RHEL/CentOS/Fedora
  2. Innotop don Saka idanu Ayyukan MySQL

A cikin wannan labarin, mun bayyana yadda ake shigarwa, daidaitawa da amfani da mytop a cikin Linux. Idan kuna da wasu tambayoyi, yi amfani da fom ɗin amsa da ke ƙasa don isa gare mu.