mytop mytop is a top-like realtime command line based monitoring system for MySQL. ir top-kā reālā komandrindas balstīto uzraudzības sistēmu MySQL. It is written by Jeremy Zawodny, and is available for free download. Tas ir rakstīts ar Jeremy Zawodny, un ir pieejama bezmaksas lejupielādei. It runs on most UNIX-based systems, and most definitely on Linux machines. Tas darbojas vairumā UNIX sistēmām, un katrā ziņā uz Linux mašīnām. This kind of real-time monitoring can be very useful when administering a MySQL server. Šī reālā laika veida uzraudzību varētu būt ļoti noderīgi, ja lieto MySQL serveri.

You need a working MySQL server and a few Perl modules such as DBI, DBD::mysql, Term::ReadKey, and Getopt::Long to be able to use mytop . Jums nepieciešams darba MySQL serveris un daži Perl modules piemēram, DBI, DBD:: mysql, termins: ReadKey, un Getopt: ilgi, lai varētu izmantot mytop. You can download the source code version of mytop from the project's Jūs varat lejupielādēt pirmkoda versija mytop no projekta website mājas lapa , or you can get a pre-built binary package for your distribution. , Vai arī varat saņemt pre-built bināro paketi Jūsu izplatīšanu. I know that there are packages for Fedora/Redhat and for Ubuntu systems. Es zinu, ka ir iepakojumos Fedora / Redhat un Ubuntu sistēmām. You should be able to find them pretty easily on the web. Jūs varat atrast tos diezgan viegli ar web. Once you get the binary version of mytop install it. Kad jums bināro versiju mytop instalējiet to.

Once you have installed mytop you can check if it is working using the following command: Kad esat instalējis mytop jūs varat pārbaudīt, vai tā darbojas, izmantojot komandu:

# mytop -h dbserver -u dbuser -p dbpassword # Mytop-h dbserver-u dbuser-p dbpassword

MySQL on dbserver (5.0.37) up 50+17:53:46 [13:20:38] MySQL uz dbserver (5.0.37) līdz +17:53:46 50 [13:20:38]
Queries: 2.5G qps: 609 Slow: 0.0 Se/In/Up/De(%): 01/00/00/00 Queries: 2.5 QPS: 609 Slow: 0.0 Se / In / Up / De (%): 01/00/00/00

Key Efficiency: 99.8% Bps in/out: 0.0/ 0.0 Key Efficiency: 99,8% BPS in / out: 0.0 / 0.0

Id User Host/IP DB Time Cmd Query or State Id User Host / IP DB Time Cmd Query vai valsts
— —- ——- — —- — ———- - - --- - - - ----
9570443 dbuser 192.168.10.9 appdb 0 Prepar 9570443 dbuser 192.168.10.9 appdb 0 Prepar
9575575 dbuser 192.168.10.9 appdb 0 Sleep 9575575 dbuser 192.168.10.9 appdb 0 Sleep
9576920 dbuser 192.168.10.9 appdb 0 Sleep 9576920 dbuser 192.168.10.9 appdb 0 Sleep
9593343 dbuser 192.168.10.4 appdb 0 Sleep 9593343 dbuser 192.168.10.4 appdb 0 Sleep
9601720 dbuser 192.168.10.3 appdb 0 Query show full process 9601720 dbuser 192.168.10.3 appdb 0 Query parādīt visu procesu
9574728 dbuser 192.168.10.9 appdb 1 Sleep 9574728 dbuser 192.168.10.9 appdb 1 Sleep
9575771 dbuser 192.168.10.9 appdb 1 Sleep 9575771 dbuser 192.168.10.9 appdb 1 Sleep
9579103 dbuser 192.168.10.9 appdb 1 Sleep 9579103 dbuser 192.168.10.9 appdb 1 Sleep
9579962 dbuser 192.168.10.4 appdb 1 Sleep 9579962 dbuser 192.168.10.4 appdb 1 Sleep
9581070 dbuser 192.168.10.4 appdb 1 Sleep 9581070 dbuser 192.168.10.4 appdb 1 Sleep
9585516 dbuser 192.168.10.4 appdb 1 Sleep 9585516 dbuser 192.168.10.4 appdb 1 Sleep
9585518 dbuser 192.168.10.4 appdb 1 Sleep 9585518 dbuser 192.168.10.4 appdb 1 Sleep
9597503 dbuser 192.168.10.4 appdb 1 Sleep 9597503 dbuser 192.168.10.4 appdb 1 Sleep
9597952 dbuser 192.168.10.4 appdb 1 Sleep 9597952 dbuser 192.168.10.4 appdb 1 Sleep
9599442 dbuser 192.168.10.9 appdb 1 Sleep 9599442 dbuser 192.168.10.9 appdb 1 Sleep

Replace dbserver , dbuser , and dbpassword with the correct credentials of your MySQL server. Aizstāt dbserver, dbuser, un dbpassword ar pareizu izpausmi savam MySQL serverim. This ought to get you off the blocks with mytop . Tas būtu, lai iegūtu Jums off ar mytop blokus. You can read up this Jūs varat izlasīt līdz šai documentation dokumentācija if you want to see a list of options supported by mytop Ja jūs vēlaties redzēt opciju sarakstu apstiprina mytop