4 Amfanin Kayan Aikin Layin Umurni don Kula da Ayyukan MySQL a cikin Linux
Akwai kayan aikin da yawa don saka idanu akan aikin MySQL da warware matsalar uwar garke, amma koyaushe ba sa dace daidai ga mai haɓaka MySQL ko mai gudanarwa don buƙatun su na gama-gari, ko ƙila ba sa aiki a wasu yanayi, kamar nesa ko kan sa ido kan yanar gizo.
Sa'ar al'amarin shine, akwai kayan aikin buɗaɗɗe iri-iri waɗanda al'ummar MySQL suka ƙirƙira don cike giɓin. A gefe guda, yana da matukar wahala a gano waɗannan kayan aikin ta hanyar bincike na yanar gizo, wannan shine dalilin da ya sa muka tattara kayan aikin layin umarni 4 don saka idanu akan lokacin bayanan MySQL, kaya da aiki a cikin Linux.
Uptime yana nufin tsawon lokacin da rumbun adana bayanai ke gudana da kuma sama tun lokacin da aka rufe ta na ƙarshe ko kuma ta sake farawa. Samun bayanai game da lokacin aiki yana da matukar mahimmanci a yanayi da yawa, saboda yana taimaka wa masu gudanar da tsarin su duba matsayin bayanan MySQL game da, tambayoyi nawa a cikin sakan daya da MySQL database ke hidima, zaren, jinkirin tambayoyin da ƙididdiga masu ban sha'awa.
1. Mytop
Mytop yana ɗaya daga cikin buɗaɗɗen tushen asali na kuma kayan aikin sa ido na tushen kayan aikin bidiyo na kyauta (marasa-gui) don bayanan MySQL Jereme Zawodny ne ya rubuta ta ta amfani da harshen Perl. Mytop yana gudana a cikin tasha kuma yana nuna ƙididdiga game da zaren, tambayoyin, jinkirin queries, lokacin aiki, kaya, da sauransu a cikin tsarin tambura, kama da babban shirin Linux. Wanne a kaikaice yana taimaka wa masu gudanarwa don haɓakawa da haɓaka aikin MySQl don ɗaukar manyan buƙatun da rage nauyin uwar garken.
Akwai fakitin mytop don rarraba Linux daban-daban, kamar Ubuntu, Fedora da CentOS. Don ƙarin game da umarnin shigarwa karanta: Yadda ake Sanya Mytop (MySQL Monitoring) a cikin Linux
2. Mtop
mtop (MySQL saman) wani nau'in buɗaɗɗen tushe ne mai kama da, layin umarni na tushen ainihin kayan aikin sa ido na MYSQL Server, an rubuta shi cikin yaren Perl wanda ke nuna sakamako a tsarin tambura kamar mytop. mtop yana lura da tambayoyin MySQL waɗanda ke ɗaukar mafi yawan adadin lokaci don gamawa kuma yana kashe waɗancan tambayoyin da ke gudana bayan takamaiman takamaiman lokaci.
Bugu da ƙari, yana kuma ba mu damar gano matsalolin da suka shafi aiki, bayanin daidaitawa, ƙididdiga na aiki da kuma kunna shawarwari masu alaƙa daga ƙirar layin umarni. Kayan aikin biyu suna kama da juna, amma mtop ba a kiyaye shi sosai kuma maiyuwa ba zai yi aiki akan sabbin nau'ikan MySQL da aka shigar ba.
Don ƙarin game da umarnin shigarwa karanta: Yadda ake Sanya Mtop (MySQL Monitoring) a cikin Linux
3. Innotop
Innotop shine ainihin ingantaccen tsarin binciken layin umarni don sa ido kan sabar MySQL na gida da na nesa da ke gudana ƙarƙashin injin InnoDB. Innotop ya haɗa da fasali da yawa kuma ya zo tare da nau'ikan yanayi/zaɓuɓɓuka daban-daban, waɗanda ke taimaka mana don saka idanu daban-daban na aikin MySQL don gano abin da ke faruwa tare da uwar garken MySQL.
Don ƙarin game da umarnin shigarwa karanta: Yadda ake Sanya Innotop (MySQL Monitoring) a cikin Linux
4. mysqladmin
mysqladmin shine tsohuwar layin umarni MySQL abokin ciniki wanda yazo wanda aka riga aka shigar dashi tare da kunshin MySQL don aiwatar da ayyukan gudanarwa kamar tsarin sa ido, duba saitin uwar garken, sake shigar da gata, matsayi na yanzu, saitin kalmar sirri, canza kalmar sirri, ƙirƙirar/sauke bayanan bayanai, da yawa. Kara.
Don duba matsayin mysql da kuma lokacin aiki gudanar da umarni mai zuwa daga tashar, kuma tabbatar cewa dole ne ku sami izinin tushen don aiwatar da umarnin daga harsashi.
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
Don ƙarin game da umarnin mysqladmin da misalai, karanta: Dokokin mysqladmin 20 don Gudanarwar MySQL a cikin Linux
Kammalawa
Idan kuna neman ingantaccen kayan aikin saka idanu don aikin ku, Ina ba da shawarar mytop da innotop. Na dogara da mytop don dalilai na saka idanu na yau da kullun, amma yanzu na koma innotop, saboda yana nuna ƙarin ƙididdiga da bayanai, gami da ma'amaloli masu mahimmanci.