Izicelo zesiphelo sokujonga ukusebenza kwe-MySQL

Kwixesha elidlulileyo ndikubonise ezinye imiyalelo abanokulawula ngayo iseva ye-MySQL, Yenza abasebenzisi, sebenza ngedatha, njl. Ewe, kweli nqaku ndiza kukubonisa ezinye izicelo onokuzisebenzisa kwisiphelo sendlela ukubona ukuba imibuzo ikwiseva ye-MySQL, oko kukuthi, jonga ukusebenza kwe-MySQL, jonga imibuzo iqhubeka, njl.

Phezulu wam

Uyakhumbula umphezulu okanye enye phezulu Yintoni esebenza njengesixhobo esilawula inkqubo? Kulungile, mytop bekunjalo kodwa kwi-MySQL

Kuya kufuneka uyifakele kuqala, kolu phando kwindawo yakho yokugcina kwaye ufake iphakheji ebizwa mytop:

Kwi-Debian, Ubuntu okanye kwimveliso eya kuba njalo

sudo apt-get install mytop

Nje ukuba bafakelwe bayayiphumeza kodwa kunjalo, kufuneka bachaze igama lomsebenzisi, ipassword kunye ne-IP yeseva ye-MySQL, umzekelo, becinga ukuba baqhuba i-mytop kwiseva efanayo nge-SSH okanye into efanayo, becinga ukuba umsebenzisi yingcambu kunye negama eligqithisiweyo t00r ... ke iya kuba:

mytop -u root -p t00r

Njengoko ubona kumfanekiso mytop usinika ulwazi olwahlukeneyo:

• Izibalo zemisonto esetyenziswayo
• Imibuzo yeSQL
• Isebenze ixesha elingakanani inkonzo
• Ukulayisha okanye ukusetyenziswa
• Cela i-IP
• Umsebenzisi owenza isicelo
• Ixesha ... njl

I-MyTop yinkqubo ebhalwe ePerl, lukhetho oluhle kakhulu lokujonga ukuba iseva ye-MySQL iqhuba njani

Innotop

Oku kufakwe ngokungagqibekanga xa sifaka iseva ye-MySQL, ke kuya kufuneka siyenze ngokuyidlulisa njengakwigama lomsebenzisi kunye negama lokugqitha:

innotop -u usuario -p password -h ip-del-servidor

Ukuthatha ukuba umsebenzisi yingcambu, igama eligqithisiweyo liyi-t00r kwaye senza umthetho yi-SSH kwiseva efanayo:

innotop -u root -p t00r

Njengoko ubona, isinika ulwazi olunomdla, idatha engenayo nephumayo, umthwalo, ubungakanani okanye ukusetyenziswa kwecache, njl.

mysqladmin

Kule nto Sele ndithethile nawe kwenye ipostiNangona kunjalo, khumbula ukuba ngalo myalelo ulandelayo sinokubona ulwazi malunga neseva ye-MySQL:

mysqladmin -u usuario -p password version

Ukuthatha kwakhona, ukuba umsebenzisi yingcambu kunye negama lokugqitha t00r, iya kuba:

mysqladmin -u root -p version

Kwaye iya kusicela ngegama eligqithisiweyo ... emva koko sifumana into enje:

Apha sibona ingxelo ye-MySQL, inani lemisonto esebenzayo, uhlobo lonxibelelwano, ixesha lokuphila kwenkonzo, njl.

Ekupheleni

Ukuba ujonga isixhobo esifanelekileyo sokujonga ukusebenza kunye nokusebenza kweseva ye-MySQL, ndincoma mytop e innotop.

Omnye ubonakalisa ulwazi olungenalo olunye, zombini ezi zikhetho zibalaseleyo, kuxhomekeke kwinto ekufuneka siyiphonononge, ziya kuba ngaphezulu.

Kulungile apho kulapho iposti iya khona.