Mytop - Irinṣẹ Wulo fun Ṣiṣe Abojuto MySQL/Iṣẹ MariaDB ni Lainos
Mytop jẹ orisun ṣiṣi ati eto ibojuwo ọfẹ fun MySQL ati awọn apoti isura data MariaDB ti a kọ nipasẹ Jeremy Zawodny nipa lilo ede Perl. O jọra pupọ ni wiwo ati rilara ti ọpa ibojuwo eto Linux olokiki julọ ti a pe ni oke.
Eto Mytop n pese wiwo ikarahun laini-aṣẹ lati ṣe atẹle akoko gidi awọn okun MySQL/MariaDB, awọn ibeere fun iṣẹju-aaya, atokọ ilana ati iṣẹ ti awọn apoti isura data ati fun imọran fun olutọju ibi ipamọ data lati mu olupin dara dara lati mu ẹru nla.
Nipa aiyipada ọpa Mytop wa ninu Fedora ati awọn ibi ipamọ Debian/Ubuntu, nitorinaa o kan ni lati fi sii nipa lilo oluṣakoso package aiyipada rẹ.
Ti o ba nlo awọn pinpin RHEL/CentOS, lẹhinna o nilo lati jẹki ibi ipamọ EPEL ẹnikẹta lati fi sii.
Fun awọn pinpin Lainos miiran o le gba package orisun mytop ki o ṣajọ lati orisun bi o ti han.
# 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
Ninu ẹkọ ikẹkọ ibojuwo MySQL yii, a yoo fihan ọ bi o ṣe le fi sori ẹrọ, tunto ati lo mytop lori ọpọlọpọ awọn pinpin kaakiri Linux.
Jọwọ ṣe akiyesi o gbọdọ ni ṣiṣe MariaDB Server lori ẹrọ lati fi sori ẹrọ ati lo Mytop.
Fi sori ẹrọ Mytop ni Awọn ọna Linux
Lati fi sori ẹrọ Mytop, ṣiṣe aṣẹ ti o yẹ ni isalẹ fun pinpin Linux rẹ lati fi sii.
$ 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
Bii o ṣe le lo Mytop lati ṣe atẹle MySQL/MariaDB
Mytop nilo awọn ẹri iwọle MySQL/MariaDB lati ṣe atẹle awọn apoti isura data ati sopọ si olupin pẹlu orukọ olumulo gbongbo nipasẹ aiyipada. O le ṣọkasi awọn aṣayan pataki fun sisopọ si olupin data lori laini aṣẹ bi o ti n ṣiṣẹ tabi ni faili ~/.mytop (fun irọrun bi a ti ṣalaye rẹ nigbamii).
Kan ṣiṣe aṣẹ atẹle lati bẹrẹ mytop ki o pese ọrọ igbaniwọle olumulo olumulo MySQL/MariaDB rẹ, nigbati o ba ṣetan. Eyi yoo sopọ si ibi ipamọ data idanwo nipasẹ aiyipada.
# mytop --prompt Password:
Lọgan ti o ba tẹ ọrọ igbaniwọle MySQL sii iwọ yoo wo ikarahun ibojuwo Mytop, iru si isalẹ.
Ti o ba fẹ lati ṣe atẹle ibi ipamọ data kan pato, lẹhinna lo aṣayan -d bi a ṣe han ni isalẹ. Fun apẹẹrẹ aṣẹ isalẹ yoo ṣe atẹle tecmint data.
# mytop --prompt -d tecmint Password:
Ti ọkọọkan awọn apoti isura infomesonu rẹ ni abojuto kan pato (fun apẹẹrẹ abojuto data data tecmint), lẹhinna sopọ nipa lilo orukọ olumulo data ati ọrọ igbaniwọle bii bẹ.
# mytop -u tecmint -p password_here -d tecmintdb
Sibẹsibẹ, eyi ni awọn ipa aabo kan lati igba ti ọrọ igbaniwọle olumulo ti tẹ lori laini aṣẹ ati pe o le wa ni fipamọ ni faili itan ikarahun aṣẹ. O le wo faili yii nigbamii nipasẹ eniyan laigba aṣẹ ti o le de lori orukọ olumulo ati ọrọ igbaniwọle.
Lati yago fun eewu iru oju iṣẹlẹ bẹ, lo faili atunto ~/.mytop lati ṣafihan awọn aṣayan fun sisopọ si ibi ipamọ data. Idaniloju miiran ti ọna yii ni pe o tun ṣe pẹlu titẹ ọpọlọpọ awọn ariyanjiyan laini aṣẹ ni igba kọọkan ti o fẹ ṣiṣe mytop.
# vi ~/.mytop
Lẹhinna ṣafikun awọn aṣayan pataki ni isalẹ ninu rẹ.
user=root pass=password_here host=localhost db=test delay=4 port=3306 socket=
Fipamọ ki o pa faili naa. Lẹhinna ṣiṣe mytop laisi eyikeyi awọn ariyanjiyan laini aṣẹ.
# mytop
O ni agbara lati fihan iye ti alaye nla loju iboju ati pe ọpọlọpọ awọn aṣayan ọna abuja ọna abuja paapaa, ṣayẹwo “mytop eniyan” fun alaye diẹ sii.
# man mytop
- Mtop (Abojuto Abojuto data data MySQL) ni RHEL/CentOS/Fedora
- Innotop lati ṣetọju Iṣẹ MySQL
Ninu nkan yii, a ti ṣalaye bii o ṣe le fi sori ẹrọ, tunto ati lo mytop ni Linux. Ti o ba ni ibeere eyikeyi, lo fọọmu esi ni isalẹ lati de ọdọ wa.