Aikace-aikacen Terminal don bincika aikin MySQL

Lokaci kaɗan na nuna muku wasu umarni wanda zasu iya sarrafa sabar MySQL, ƙirƙirar masu amfani, aiki tare da rumbunan adana bayanai, da sauransu. Da kyau, a cikin wannan labarin zan nuna muku wasu aikace-aikacen da zaku iya amfani dasu a cikin tashar don ganin yadda tambayoyin suke akan sabar MySQL, ma'ana, bincika aikin MySQL, duba tambayoyin da akeyi, da dai sauransu.

Babban Nawa

Ka tuna top ko htop wanda ke aiki a matsayin mai saka idanu akan tsarin a tashar? Yayi kyau, mytop ya kasance iri daya amma na MySQL

Dole ne ku fara girka shi, don wannan binciken a cikin ma'ajiyar ku kuma shigar da kunshin da ake kira mytop:

A cikin Debian, Ubuntu ko abubuwan banbanci zai zama

sudo apt-get install mytop

Da zarar sun girka sai su aiwatar da shi amma tabbas, dole ne su tantance sunan mai amfani, kalmar wucewa da IP na uwar garken MySQL, misali, suna zaton suna gudanar da mytop akan wannan sabar ta amfani da SSH ko wani abu makamancin haka, a zaton cewa mai amfani yana da tushe kuma kalmar sirri t00r ... to zai zama:

mytop -u root -p t00r

Kamar yadda kake gani a cikin hoto mytop yana bamu bayanai iri-iri:

• Ididdigar zaren da ake amfani da shi
• Binciken SQL
• Yaya tsawon lokacin da sabis ke gudana
• Load ko amfani
• Nemi IP
• Mai amfani da neman
• Lokaci ... da dai sauransu

MyTop shiri ne wanda aka rubuta a cikin Perl, kyakkyawan zaɓi ne don bincika yadda uwar garken MySQL ke gudana.

Innotop

An shigar da wannan ta tsohuwa lokacin da muka sanya sabar MySQL, don haka dole ne kawai mu aiwatar da shi ta hanyar wuce shi kamar yadda yake tare da sunan mai amfani da kalmar wucewa:

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

Muna zaton cewa mai amfani yana da tushe, kalmar sirri t00r ce kuma muna aiwatar da umarnin ne ta hanyar SSH akan wannan sabar:

innotop -u root -p t00r

Kamar yadda kake gani, yana ba mu bayanai masu ban sha'awa, bayanai masu shigowa da masu fita, loda, girma ko amfani da ma'aji, da dai sauransu.

mysqladmin

Na wannan Na riga na yi magana da ku a wani rubutuKoyaya, tuna cewa tare da umarni mai zuwa zamu iya ganin bayanai game da sabar MySQL:

mysqladmin -u usuario -p password version

Idan aka sake yin la'akari, cewa mai amfani yana da tushe kuma kalmar sirri t00r ce, zai zama:

mysqladmin -u root -p version

Kuma zai tambaye mu kalmar sirri ... to mun sami wani abu kamar haka:

Anan zamu ga sigar MySQL, yawan zaren da ke aiki, nau'in haɗi, lokacin rayuwar sabis, da sauransu.

karshen

Idan kuna neman kayan aiki masu kyau don saka idanu kan aikin da aikin sabar MySQL ɗinku, Ina bada shawara mytop e innotop.

Showsaya yana nuna bayanin da ɗayan baya yi, duka biyu ainihin zaɓuɓɓuka ne masu kyau, dangane da abin da muke buƙatar dubawa, waɗannan zasu isa sosai.

To anan ne post din yake.