Terminal kunyorera kutarisa MySQL mashandiro

Nguva pfupi yapfuura ndakakuratidza zvimwe mirairo yavaigona kubata server yeMySQL, gadzira vashandisi, shanda nedhatabhesi, nezvimwe. Zvakanaka, muchinyorwa chino ini ndinokuratidza mamwe mafomu aunogona kushandisa mune terminal kuti uone kuti mibvunzo iri sei paMySQL server, ndiko kuti, tarisa mashandiro eMySQL, ona mibvunzo iri kuenderera mberi, nezvimwe.

My Top

Unoyeuka here pamusoro kana zvimwe htop iyo inoshanda seyekutarisa yeiyo system mune terminal? Kugona, mytop zvave zvakafanana asi zveMySQL

Unofanirwa kutanga waiisa, yekutsvaga iyi mune yako repository uye isa pasuru inonzi mytop:

MuDebian, Ubuntu kana zvigadzirwa zvinogona kunge zviri

sudo apt-get install mytop

Kana vachinge vaisa vanozviita asi zvechokwadi, vanofanirwa kudoma zita rekushandisa, password uye IP yeiyo MySQL server, semuenzaniso, vachifunga kuti vanomhanya mytop pane imwechete server vachishandisa SSH kana chimwe chinhu chakafanana, vachifunga kuti mushandisi mudzi uye password ndeye t00r ... ipapo zvingave:

mytop -u root -p t00r

Sezvauri kuona mumufananidzo mytop inotipa akasiyana ruzivo.

• Statistics ye tambo dziri kushandiswa
• SQL mibvunzo
• Inguva yakareba sei sevhisi yanga ichimhanya
• Mutoro kana kudyiwa
• Kumbira IP
• Mushandisi ari kuita chikumbiro
• Nguva ... nezvimwe

MyTop chirongwa chakanyorwa muPerl, iri sarudzo yakanakisa yekutarisa kuti server yangu yeMySQL irikuita sei.

Innotop

Izvi zvakaiswa nekumisikidza patinoisa iyo MySQL server, saka isu tinongofanirwa kuzviita nekuipfuudza senge ine mytop iro zita rekushandisa uye password:

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

Kufunga kuti mushandisi mudzi, password ndeye t00r uye kuti tinoita rairo neSSH pane imwechete server:

innotop -u root -p t00r

Sezvauri kuona, inotipa inonakidza ruzivo, inouya uye inobuda data, mutoro, chiyero kana kushandiswa kwe cache, nezvimwe.

mysqladmin

Zveizvi Ndatotaura newe mune imwe posvoZvisinei, yeuka kuti nemurairo unotevera tinogona kuona ruzivo pamusoro peSySQL server:

mysqladmin -u usuario -p password version

Kufunga zvakare, kuti mushandisi mudzi uye password iri t00r, zvingave zviri:

mysqladmin -u root -p version

Uye ichatibvunza isu password ... ipapo tinowana chimwe chinhu chakadai.

Pano tinoona iyo vhezheni yeMySQL, huwandu hweshinda hunoshanda, mhando yekubatanidza, sevhisi yehupenyu nguva, nezvimwe.

Fin

Kana iwe uchitsvaga yakanaka turu yekutarisa mashandiro uye mashandiro eiyo MySQL server, ini ndinokurudzira mytop e innotop.

Imwe inoratidza ruzivo iyo imwe isingaite, ese ari maviri akanakisa sarudzo, zvinoenderana nezvatinoda kuongorora, izvi zvichave zvinokwana.

Zvakanaka apa ndipo panotumirwa posvo.