mytop mytop is a top-like realtime command line based monitoring system for MySQL. er en topp-aktig sanntid kommandolinje-basert overvåkingssystem for MySQL. It is written by Jeremy Zawodny, and is available for free download. Den er skrevet av Jeremy Zawodny, og er tilgjengelig for gratis nedlasting. It runs on most UNIX-based systems, and most definitely on Linux machines. Det kjører på de fleste UNIX-baserte systemer, og definitivt på Linux-maskiner. This kind of real-time monitoring can be very useful when administering a MySQL server. Denne typen sanntids overvåking kan være nyttig ved administrering av en MySQL-server.

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 . Du trenger en arbeider MySQL server og noen Perl-moduler som DBI, dbd:: MySQL, Term:: ReadKey og Getopt:: Lang å kunne bruke mytop. You can download the source code version of mytop from the project's Du kan laste ned kildekoden versjonen av mytop fra prosjektets website website , or you can get a pre-built binary package for your distribution. , Eller du kan få en pre-bygget binær pakke for distribusjon din. I know that there are packages for Fedora/Redhat and for Ubuntu systems. Jeg vet at det finnes pakker for Fedora / Red Hat og Ubuntu systemer. You should be able to find them pretty easily on the web. Du skal kunne finne dem ganske enkelt på nettet. Once you get the binary version of mytop install it. Når du får den binære versjonen av mytop installere den.

Once you have installed mytop you can check if it is working using the following command: Når du har installert mytop du kan sjekke om det fungerer å bruke følgende kommando:

# 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 på dbserver (5.0.37) inntil 50 +17:53:46 [13:20:38]
Queries: 2.5G qps: 609 Slow: 0.0 Se/In/Up/De(%): 01/00/00/00 Queries: 2.5G qps: 609 Slow: 0.0 Se / I / Up / De (%): 01/00/00/00

Key Efficiency: 99.8% Bps in/out: 0.0/ 0.0 Key Efficiency: 99,8% bps inn / ut: 0,0 / 0,0

Id User Host/IP DB Time Cmd Query or State Id Bruker Host / IP DB Time Cmd Query eller stat
— —- ——- — —- — ———- - - --- - - - ----
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 viser hele prosessen
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. Erstatt dbserver, dbuser og dbpassword med korrekt legitimasjon av MySQL server. This ought to get you off the blocks with mytop . Dette burde få deg av blokker med mytop. You can read up this Du kan lese dette documentation dokumentasjon if you want to see a list of options supported by mytop hvis du vil se en liste over alternativer støttes av mytop