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
- Mtop (MySQL Database Monitoring) a cikin RHEL/CentOS/Fedora
- 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.