Ngwa 4 bara uru iji nyochaa arụmọrụ MySQL na Linux
Enwere ọtụtụ ngwaọrụ iji nyochaa arụmọrụ MySQL na nsogbu nke ihe nkesa, mana ha anaghị adị mma mgbe niile maka onye nrụpụta MySQL ma ọ bụ onye nchịkwa maka mkpa ha niile, ma ọ bụ nwere ike ọ gaghị arụ ọrụ n'ọnọdụ ụfọdụ, dị ka n'ime ime ma ọ bụ n'elu nlekota weebụ.
Ọ dabara nke ọma, enwere ngwa ọrụ mepere emepe nke obodo MySQL mepụtara iji mejupụta oghere ndị ahụ. N'aka nke ọzọ, ọ na-esiri ike ịchọta ngwaọrụ ndị a site na nyocha weebụ, ọ bụ ya mere anyị ji chịkọta 4 ngwaọrụ ahịrị iwu iji nyochaa MySQL nchekwa data oge, ibu na arụmọrụ na Linux.
Uptime pụtara ogologo oge nchekwa data na-arụ ọrụ na elu kemgbe mmechi ikpeazụ ya ma ọ bụ malitegharịa. Inweta ozi gbasara oge ọrụ dị oke mkpa n'ọtụtụ ọnọdụ, ebe ọ na-enyere ndị na-ahụ maka sistemu aka ịlele ọnọdụ nchekwa data MySQL gbasara, ajụjụ ole kwa sekọnd nke MySQL nchekwa data na-eje ozi, eri, ajụjụ nwayọ na ọtụtụ ọnụ ọgụgụ na-atọ ụtọ.
1. Mytop
Mytop bụ otu n'ime isi mmalite m mepere emepe yana ngwaọrụ nleba anya dabere na njikwa (na-abụghị gui) maka nchekwa data MySQL nke Jereme Zawodny dere site na iji asụsụ Perl. Mytop na-agba ọsọ n'ọnụ ọnụ wee gosipụta ọnụ ọgụgụ gbasara eri, ajụjụ, ajụjụ ngwa ngwa, oge ọrụ, ibu, wdg n'ụdị tabular, yiri mmemme kacha elu Linux. Nke na-enyere ndị nchịkwa aka na-ebuli na melite arụmọrụ MySQl n'ụzọ na-edoghị anya iji jikwaa arịrịọ buru ibu na ibelata ibu nkesa.
Enwere ngwugwu mytop dị maka nkesa Linux dị iche iche, dị ka Ubuntu, Fedora na CentOS. Maka nkọwa ndị ọzọ gbasara ntuziaka nwụnye, gụọ: Otu esi etinye Mytop (MySQL Monitoring) na Linux
2. Mtop
mtop (MySQL n'elu) bụ ihe ọzọ yiri oghere mepere emepe, akara ahịrị dabere ozugbo MYSQL Server nlekota ngwá ọrụ, e dere na Perl asụsụ na-egosipụta arụpụta na tabular format dị ka mytop. mtop na-enyocha ajụjụ MySQL nke na-ewe oge kacha mma iji mechaa wee gbuo ajụjụ ndị ahụ na-agba ọsọ mgbe oge ụfọdụ akọwapụtara.
Na mgbakwunye, ọ na-enyekwara anyị aka ịchọpụta nsogbu metụtara arụmọrụ, ozi nhazi, ọnụ ọgụgụ arụmọrụ na nlegharị anya ndụmọdụ metụtara ya site na interface akara iwu. Ngwa abụọ a yitere, mana anaghị echekwa mtop nke ọma yana ọ nwere ike ọ gaghị arụ ọrụ na ụdị MySQL arụnyere ọhụrụ.
Maka nkọwa ndị ọzọ gbasara ntuziaka nwụnye, gụọ: Otu esi etinye Mtop (MySQL Monitoring) na Linux
3. Innotop
Innotop bụ usoro nyocha usoro iwu dị elu dị elu nke oge iji nyochaa sava MySQL mpaghara na nke dịpụrụ adịpụ na-agba n'okpuru injin InnoDB. Innotop na-agụnye ọtụtụ atụmatụ ma na-abịa na ụdịdị/nhọrọ dị iche iche, nke na-enyere anyị aka nyochaa akụkụ dị iche iche nke MySQL arụmọrụ iji chọpụta ihe na-ezighị ezi na-aga na MySQL server.
Maka nkọwa ndị ọzọ gbasara ntuziaka nwụnye, gụọ: Otu esi etinye Innotop (MySQL Monitoring) na Linux
4. mysqladmin
mysqladmin bụ ahịrị iwu MySQL onye ahịa nke na-abịarubere ya na ngwugwu MySQL maka ịrụ ọrụ nchịkwa dị ka usoro nleba anya, ịlele nhazi nkesa, ikike ibugharị, ọnọdụ dị ugbu a, ịtọ paswọọdụ mgbọrọgwụ, ịgbanwe paswọọdụ mgbọrọgwụ, mepụta/dobe ọdụ data, na ọtụtụ ihe. Ọzọ.
Iji lelee ọnọdụ mysql yana oge oge na-agba ọsọ iwu na-esonụ site na njedebe, ma jide n'aka na ị ga-enwerịrị ikike mgbọrọgwụ iji mezuo iwu ahụ site na shei.
mysqladmin -u root -p version Enter password:
mysqladmin Ver 8.42 Distrib 5.1.61, for redhat-linux-gnu on i386 Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Server version 5.1.61-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 20 days 54 min 30 sec Threads: 1 Questions: 149941143 Slow queries: 21 Opens: 752 Flush tables: 1 Open tables: 745 Queries per second avg: 86.607
Maka ihe ndị ọzọ gbasara iwu mysqladmin na ọmụmaatụ, gụọ: Iwu mysqladmin 20 maka nchịkwa MySQL na Linux
Mmechi
Ọ bụrụ na ị na-achọ ezigbo ihe nleba anya maka ọrụ nke gị, ana m akwado mytop na innotop. M na-adabere na mytop maka ebumnuche nleba anya kwa ụbọchị, ma ugbu a, agbanyere m na innotop, n'ihi na ọ na-egosiputa ọnụ ọgụgụ na ozi ndị ọzọ, gụnyere azụmahịa dị mkpa.