Izicelo zeTheminali zokuhlola ukusebenza kwe-MySQL

Esikhathini esedlule ngikhombisa ezinye imiyalo abangaphatha ngayo iseva ye-MySQL, dala abasebenzisi, sebenza ngemininingwane, njll. Kule ndatshana ngizokukhombisa ezinye izinhlelo ongazisebenzisa ku-terminal ukubona ukuthi imibuzo ikanjani kuseva ye-MySQL, okungukuthi, hlola ukusebenza kwe-MySQL, bona imibuzo iqhubeka, njll.

I-MyTop

Uyakhumbula top noma okunye htop Yini okusebenza njenge-terminal system monitor? Kuhle, mytop bekulokhu kunjalo kodwa nge-MySQL

Kufanele uqale ukuyifaka, yalokhu kusesha endaweni yakho yokugcina bese ufaka iphakheji ebizwa mytop:

Ku-Debian, Ubuntu noma okuphuma kuzoba njalo

sudo apt-get install mytop

Lapho sekufakiwe bayayikhipha kepha-ke, kufanele bacacise igama lomsebenzisi, iphasiwedi ne-IP yeseva ye-MySQL, ngokwesibonelo, becabanga ukuthi basebenzisa i-mytop kuseva efanayo besebenzisa i-SSH noma into efanayo, becabanga ukuthi umsebenzisi uyimpande nephasiwedi ngu-t00r ... kuzoba-ke:

mytop -u root -p t00r

Njengoba ukwazi ukubona esithombeni i-mytop isinikeza imininingwane ehlukahlukene:

• Izibalo zemicu esetshenziswayo
• Imibuzo ye-SQL
• Isevisi isikhathi esingakanani isebenza
• Ukulayisha noma ukusetshenziswa
• Cela i-IP
• Umsebenzisi owenza isicelo
• Isikhathi ... njll

I-MyTop wuhlelo olubhalwe ku-Perl, kuyindlela enhle kakhulu yokubheka ukuthi iseva ye-MySQL isebenza kanjani.

I-Innotop

Lokhu kufakwa ngokuzenzakalela lapho sifaka iseva ye-MySQL, ngakho-ke kufanele sikwenze kuphela, sikudlulise njengokusebenzisa igama lomsebenzisi nephasiwedi:

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

Uma ucabanga ukuthi umsebenzisi uyimpande, iphasiwedi ngu-t00r nokuthi senza umyalo yi-SSH kuseva efanayo:

innotop -u root -p t00r

Njengoba ukwazi ukubona, lena isinikeza imininingwane ethokozisayo, idatha engenayo nephumayo, umthwalo, ububanzi noma ukusetshenziswa kwesilondolozi, njll.

mysqladmin

Kulokhu Ngivele ngikhulume nawe kokunye okuthunyelweKodwa-ke, khumbula ukuthi ngomyalo olandelayo singabona imininingwane mayelana neseva ye-MySQL:

mysqladmin -u usuario -p password version

Uma ucabanga futhi, ukuthi umsebenzisi uyimpande futhi ne-password ngu-t00r, kungaba:

mysqladmin -u root -p version

Futhi izosicela iphasiwedi ... bese sithola into enjengale:

Lapha sibona inguqulo ye-MySQL, inani lezintambo ezisebenzayo, uhlobo lokuxhuma, isikhathi sokuphila kwensizakalo, njll.

ekupheleni

Uma ufuna ithuluzi elihle lokuqapha ukusebenza nokusebenza kweseva yakho ye-MySQL, ngincoma mytop e innotop.

Eyodwa ikhombisa imininingwane enye engayenzi, zombili empeleni ziyizinketho ezinhle kakhulu, kuya ngokuthi yini okudingeka siyibuyekeze, lokhu kuzoba ngaphezu kokwanele.

Kulapho okuthunyelwe khona.