Gecko [ ifk.uw.edu.pl ]

/ usr / bin / [ HOME SHELL ]

Name	Size	Permission
X11	[ DIR ]	drwxr-xr-x
2to3-2.7	96 B	-rwxr-xr-x
GET	15.82 KB	-rwxr-xr-x
HEAD	15.82 KB	-rwxr-xr-x
Mail	110.24 KB	-rwxr-xr-x
POST	15.82 KB	-rwxr-xr-x
[	58.66 KB	-rwxr-xr-x
aa-enabled	30.21 KB	-rwxr-xr-x
aa-exec	30.21 KB	-rwxr-xr-x
ab	54.18 KB	-rwxr-xr-x
aclocal	35.62 KB	-rwxr-xr-x
aclocal-1.16	35.62 KB	-rwxr-xr-x
acpi	23.43 KB	-rwxr-xr-x
acpi_listen	14.27 KB	-rwxr-xr-x
add-apt-repository	6.21 KB	-rwxr-xr-x
addpart	26.08 KB	-rwxr-xr-x
addr2line	31.09 KB	-rwxr-xr-x
appletviewer	6.34 KB	-rwxr-xr-x
appres	10.23 KB	-rwxr-xr-x
apropos	54.98 KB	-rwxr-xr-x
apt	18.09 KB	-rwxr-xr-x
apt-add-repository	6.21 KB	-rwxr-xr-x
apt-cache	82.16 KB	-rwxr-xr-x
apt-cdrom	26.16 KB	-rwxr-xr-x
apt-config	26.09 KB	-rwxr-xr-x
apt-extracttemplates	22.16 KB	-rwxr-xr-x
apt-ftparchive	238.16 KB	-rwxr-xr-x
apt-get	46.16 KB	-rwxr-xr-x
apt-key	27.08 KB	-rwxr-xr-x
apt-listchanges	10.61 KB	-rwxr-xr-x
apt-mark	54.16 KB	-rwxr-xr-x
apt-sortpkgs	46.09 KB	-rwxr-xr-x
aptitude	4.18 MB	-rwxr-xr-x
aptitude-create-state-bundle	1.89 KB	-rwxr-xr-x
aptitude-curses	4.18 MB	-rwxr-xr-x
aptitude-run-state-bundle	2.78 KB	-rwxr-xr-x
ar	63.07 KB	-rwxr-xr-x
arch	38.66 KB	-rwxr-xr-x
aria_chk	4.54 MB	-rwxr-xr-x
aria_dump_log	4.35 MB	-rwxr-xr-x
aria_ftdump	4.37 MB	-rwxr-xr-x
aria_pack	4.39 MB	-rwxr-xr-x
aria_read_log	4.5 MB	-rwxr-xr-x
as	872.93 KB	-rwxr-xr-x
aspell	150.34 KB	-rwxr-xr-x
aspell-import	2 KB	-rwxr-xr-x
at	54.26 KB	-rwsr-sr-x
atq	54.26 KB	-rwsr-sr-x
atrm	54.26 KB	-rwsr-sr-x
autoconf	14.42 KB	-rwxr-xr-x
autoheader	8.34 KB	-rwxr-xr-x
autom4te	31.91 KB	-rwxr-xr-x
automake	251.9 KB	-rwxr-xr-x
automake-1.16	251.9 KB	-rwxr-xr-x
autopoint	25.97 KB	-rwxr-xr-x
autoreconf	20.67 KB	-rwxr-xr-x
autoscan	16.73 KB	-rwxr-xr-x
autoupdate	33.08 KB	-rwxr-xr-x
awk	658.81 KB	-rwxr-xr-x
b2sum	58.78 KB	-rwxr-xr-x
base32	42.69 KB	-rwxr-xr-x
base64	42.69 KB	-rwxr-xr-x
basename	38.59 KB	-rwxr-xr-x
bashbug	6.63 KB	-rwxr-xr-x
batch	152 B	-rwxr-xr-x
bc	86.7 KB	-rwxr-xr-x
bootctl	46.23 KB	-rwxr-xr-x
broadwayd	118.08 KB	-rwxr-xr-x
bsd-from	10.24 KB	-rwxr-xr-x
bsd-mailx	110.24 KB	-rwxr-xr-x
bsd-write	14.39 KB	-rwxr-sr-x
buildhash	38.38 KB	-rwxr-xr-x
busctl	78.19 KB	-rwxr-xr-x
c++	1.05 MB	-rwxr-xr-x
c++filt	30.69 KB	-rwxr-xr-x
c89	428 B	-rwxr-xr-x
c89-gcc	428 B	-rwxr-xr-x
c99	454 B	-rwxr-xr-x
c99-gcc	454 B	-rwxr-xr-x
c_rehash	6.13 KB	-rwxr-xr-x
cal	29.15 KB	-rwxr-xr-x
calendar	31.15 KB	-rwxr-xr-x
captoinfo	86.11 KB	-rwxr-xr-x
catchsegv	3.23 KB	-rwxr-xr-x
catman	38.46 KB	-rwxr-xr-x
cc	1.05 MB	-rwxr-xr-x
cd-create-profile	21.99 KB	-rwxr-xr-x
cd-fix-profile	25.99 KB	-rwxr-xr-x
cd-iccdump	13.99 KB	-rwxr-xr-x
cd-it8	21.99 KB	-rwxr-xr-x
chacl	13.99 KB	-rwxr-xr-x
chage	70.13 KB	-rwxr-sr-x
chardet	389 B	-rwxr-xr-x
chardet3	389 B	-rwxr-xr-x
chardetect	389 B	-rwxr-xr-x
chardetect3	389 B	-rwxr-xr-x
chattr	14 KB	-rwxr-xr-x
chcon	62.91 KB	-rwxr-xr-x
checkgid	13.99 KB	-rwxr-xr-x
chfn	52.83 KB	-rwsr-xr-x
choom	50.08 KB	-rwxr-xr-x
chrt	34.08 KB	-rwxr-xr-x
chsh	43.48 KB	-rwsr-xr-x
ckbcomp	146.38 KB	-rwxr-xr-x
cksum	38.63 KB	-rwxr-xr-x
clear	14 KB	-rwxr-xr-x
clear_console	14.3 KB	-rwxr-xr-x
clhsdb	6.35 KB	-rwxr-xr-x
cmp	50.64 KB	-rwxr-xr-x
codepage	14.21 KB	-rwxr-xr-x
col	10.23 KB	-rwxr-xr-x
colcrt	10.2 KB	-rwxr-xr-x
colormgr	53.99 KB	-rwxr-xr-x
colrm	10.19 KB	-rwxr-xr-x
column	10.34 KB	-rwxr-xr-x
comm	42.69 KB	-rwxr-xr-x
compose	17.74 KB	-rwxr-xr-x
corelist	14.73 KB	-rwxr-xr-x
cpan	7.96 KB	-rwxr-xr-x
cpan5.28-x86_64-linux-gnu	7.99 KB	-rwxr-xr-x
cpio-filter	1.22 KB	-rwxr-xr-x
cpp	1.05 MB	-rwxr-xr-x
cpp-4.9	814.43 KB	-rwxr-xr-x
cpp-6	930.77 KB	-rwxr-xr-x
cpp-8	1.05 MB	-rwxr-xr-x
crc32	1.04 KB	-rwxr-xr-x
crontab	42.55 KB	-rwxr-sr-x
csplit	54.84 KB	-rwxr-xr-x
ctstat	22.74 KB	-rwxr-xr-x
curl	226.07 KB	-rwxr-xr-x
cut	42.75 KB	-rwxr-xr-x
cvtsudoers	250.29 KB	-rwxr-xr-x
dbilogstrip	1.35 KB	-rwxr-xr-x
dbiprof	6.06 KB	-rwxr-xr-x
dbiproxy	5.27 KB	-rwxr-xr-x
dbus-cleanup-sockets	13.98 KB	-rwxr-xr-x
dbus-daemon	235.04 KB	-rwxr-xr-x
dbus-monitor	25.99 KB	-rwxr-xr-x
dbus-run-session	13.98 KB	-rwxr-xr-x
dbus-send	29.98 KB	-rwxr-xr-x
dbus-update-activation-environ...	13.98 KB	-rwxr-xr-x
dbus-uuidgen	13.98 KB	-rwxr-xr-x
dc	46.09 KB	-rwxr-xr-x
deallocvt	14.31 KB	-rwxr-xr-x
deb-systemd-helper	20.83 KB	-rwxr-xr-x
deb-systemd-invoke	4.33 KB	-rwxr-xr-x
debconf	2.79 KB	-rwxr-xr-x
debconf-apt-progress	11.27 KB	-rwxr-xr-x
debconf-communicate	608 B	-rwxr-xr-x
debconf-copydb	1.68 KB	-rwxr-xr-x
debconf-escape	647 B	-rwxr-xr-x
debconf-gettextize	15.97 KB	-rwxr-xr-x
debconf-set-selections	2.87 KB	-rwxr-xr-x
debconf-show	1.78 KB	-rwxr-xr-x
debconf-updatepo	4.46 KB	-rwxr-xr-x
debianbts	413 B	-rwxr-xr-x
defmt-c	5.99 KB	-rwxr-xr-x
defmt-sh	5.99 KB	-rwxr-xr-x
delpart	26.08 KB	-rwxr-xr-x
delv	44.83 KB	-rwxr-xr-x
dh	30.77 KB	-rwxr-xr-x
dh_auto_build	1.37 KB	-rwxr-xr-x
dh_auto_clean	1.51 KB	-rwxr-xr-x
dh_auto_configure	1.63 KB	-rwxr-xr-x
dh_auto_install	2.8 KB	-rwxr-xr-x
dh_auto_test	1.65 KB	-rwxr-xr-x
dh_autoreconf	6.46 KB	-rwxr-xr-x
dh_autoreconf_clean	2.1 KB	-rwxr-xr-x
dh_autotools-dev_restoreconfig	1.79 KB	-rwxr-xr-x
dh_autotools-dev_updateconfig	1.81 KB	-rwxr-xr-x
dh_bash-completion	2.39 KB	-rwxr-xr-x
dh_bugfiles	3.58 KB	-rwxr-xr-x
dh_builddeb	4.96 KB	-rwxr-xr-x
dh_clean	4.91 KB	-rwxr-xr-x
dh_compress	7.58 KB	-rwxr-xr-x
dh_dkms	4.2 KB	-rwxr-xr-x
dh_dwz	3.84 KB	-rwxr-xr-x
dh_fixperms	5.28 KB	-rwxr-xr-x
dh_gconf	2.78 KB	-rwxr-xr-x
dh_gencontrol	5.85 KB	-rwxr-xr-x
dh_icons	2.04 KB	-rwxr-xr-x
dh_install	11.24 KB	-rwxr-xr-x
dh_installcatalogs	3.25 KB	-rwxr-xr-x
dh_installchangelogs	9 KB	-rwxr-xr-x
dh_installcron	1.6 KB	-rwxr-xr-x
dh_installdeb	7.8 KB	-rwxr-xr-x
dh_installdebconf	3.21 KB	-rwxr-xr-x
dh_installdirs	3 KB	-rwxr-xr-x
dh_installdocs	14.67 KB	-rwxr-xr-x
dh_installemacsen	3.74 KB	-rwxr-xr-x
dh_installexamples	5.33 KB	-rwxr-xr-x
dh_installgsettings	2.24 KB	-rwxr-xr-x
dh_installifupdown	1.47 KB	-rwxr-xr-x
dh_installinfo	2.87 KB	-rwxr-xr-x
dh_installinit	14.31 KB	-rwxr-xr-x
dh_installinitramfs	2.18 KB	-rwxr-xr-x
dh_installlogcheck	1.94 KB	-rwxr-xr-x
dh_installlogrotate	1.14 KB	-rwxr-xr-x
dh_installman	11.07 KB	-rwxr-xr-x
dh_installmanpages	4.89 KB	-rwxr-xr-x
dh_installmenu	2.15 KB	-rwxr-xr-x
dh_installmime	1.3 KB	-rwxr-xr-x
dh_installmodules	2.63 KB	-rwxr-xr-x
dh_installpam	1.13 KB	-rwxr-xr-x
dh_installppp	1.38 KB	-rwxr-xr-x
dh_installsystemd	13.06 KB	-rwxr-xr-x
dh_installsystemduser	7.41 KB	-rwxr-xr-x
dh_installtex	17.95 KB	-rwxr-xr-x
dh_installudev	2.1 KB	-rwxr-xr-x
dh_installwm	3.25 KB	-rwxr-xr-x
dh_installxfonts	2.91 KB	-rwxr-xr-x
dh_link	4.24 KB	-rwxr-xr-x
dh_lintian	1.29 KB	-rwxr-xr-x
dh_listpackages	824 B	-rwxr-xr-x
dh_makeshlibs	10.87 KB	-rwxr-xr-x
dh_md5sums	3.4 KB	-rwxr-xr-x
dh_missing	6.32 KB	-rwxr-xr-x
dh_movefiles	4.69 KB	-rwxr-xr-x
dh_perl	4.23 KB	-rwxr-xr-x
dh_perl_dbi	1.04 KB	-rwxr-xr-x
dh_perl_openssl	1.36 KB	-rwxr-xr-x
dh_phpcomposer	3.01 KB	-rwxr-xr-x
dh_phppear	5.63 KB	-rwxr-xr-x
dh_prep	1.87 KB	-rwxr-xr-x
dh_pysupport	11.95 KB	-rwxr-xr-x
dh_python2	1.03 KB	-rwxr-xr-x
dh_shlibdeps	6.13 KB	-rwxr-xr-x
dh_strip	14.45 KB	-rwxr-xr-x
dh_strip_nondeterminism	2.68 KB	-rwxr-xr-x
dh_systemd_enable	8.97 KB	-rwxr-xr-x
dh_systemd_start	8.57 KB	-rwxr-xr-x
dh_testdir	1.3 KB	-rwxr-xr-x
dh_testroot	2.86 KB	-rwxr-xr-x
dh_ucf	2.29 KB	-rwxr-xr-x
dh_update_autotools_config	1.84 KB	-rwxr-xr-x
dh_usrlocal	4.2 KB	-rwxr-xr-x
diff	215.28 KB	-rwxr-xr-x
diff3	66.84 KB	-rwxr-xr-x
dig	146.51 KB	-rwxr-xr-x
dircolors	46.66 KB	-rwxr-xr-x
dirmngr	553.55 KB	-rwxr-xr-x
dirmngr-client	114.76 KB	-rwxr-xr-x
dirname	34.59 KB	-rwxr-xr-x
discover-config	2.86 KB	-rwxr-xr-x
dnstap-read	18.01 KB	-rwxr-xr-x
dos2unix	50.02 KB	-rwxr-xr-x
dotlockfile	18.5 KB	-rwxr-sr-x
dpkg	298.53 KB	-rwxr-xr-x
dpkg-architecture	12.55 KB	-rwxr-xr-x
dpkg-buildflags	7.39 KB	-rwxr-xr-x
dpkg-buildpackage	29.89 KB	-rwxr-xr-x
dpkg-checkbuilddeps	7.45 KB	-rwxr-xr-x
dpkg-deb	162.38 KB	-rwxr-xr-x
dpkg-distaddfile	2.72 KB	-rwxr-xr-x
dpkg-divert	150.44 KB	-rwxr-xr-x
dpkg-genbuildinfo	16.4 KB	-rwxr-xr-x
dpkg-genchanges	17.08 KB	-rwxr-xr-x
dpkg-gencontrol	13.82 KB	-rwxr-xr-x
dpkg-gensymbols	10.65 KB	-rwxr-xr-x
dpkg-maintscript-helper	20.03 KB	-rwxr-xr-x
dpkg-mergechangelogs	8.35 KB	-rwxr-xr-x
dpkg-name	6.63 KB	-rwxr-xr-x
dpkg-parsechangelog	4.46 KB	-rwxr-xr-x
dpkg-query	158.43 KB	-rwxr-xr-x
dpkg-scanpackages	8.49 KB	-rwxr-xr-x
dpkg-scansources	8.95 KB	-rwxr-xr-x
dpkg-shlibdeps	30.68 KB	-rwxr-xr-x
dpkg-source	22.48 KB	-rwxr-xr-x
dpkg-split	122.34 KB	-rwxr-xr-x
dpkg-statoverride	62.12 KB	-rwxr-xr-x
dpkg-trigger	78.34 KB	-rwxr-xr-x
dpkg-vendor	3.19 KB	-rwxr-xr-x
du	107.09 KB	-rwxr-xr-x
dumpkeys	174.91 KB	-rwxr-xr-x
dvipdf	1023 B	-rwxr-xr-x
dwp	2.74 MB	-rwxr-xr-x
dwz	164.09 KB	-rwxr-xr-x
edit	17.74 KB	-rwxr-xr-x
editor	240.39 KB	-rwxr-xr-x
editres	69.38 KB	-rwxr-xr-x
eject	30.69 KB	-rwxr-xr-x
elfedit	38.84 KB	-rwxr-xr-x
enc2xs	41.12 KB	-rwxr-xr-x
encguess	2.99 KB	-rwxr-xr-x
enchant	22.07 KB	-rwxr-xr-x
enchant-lsmod	13.99 KB	-rwxr-xr-x
env	42.66 KB	-rwxr-xr-x
envsubst	42.64 KB	-rwxr-xr-x
eps2eps	639 B	-rwxr-xr-x
eqn	201.19 KB	-rwxr-xr-x
ex	2.58 MB	-rwxr-xr-x
expand	42.69 KB	-rwxr-xr-x
expiry	30.27 KB	-rwxr-sr-x
expr	50.72 KB	-rwxr-xr-x
extcheck	6.34 KB	-rwxr-xr-x
factor	74.75 KB	-rwxr-xr-x
faillog	22.29 KB	-rwxr-xr-x
faked-sysv	26.56 KB	-rwxr-xr-x
faked-tcp	30.58 KB	-rwxr-xr-x
fakeroot	3.76 KB	-rwxr-xr-x
fakeroot-sysv	3.76 KB	-rwxr-xr-x
fakeroot-tcp	3.76 KB	-rwxr-xr-x
fallocate	30.08 KB	-rwxr-xr-x
fc-cache	18.51 KB	-rwxr-xr-x
fc-cat	18.46 KB	-rwxr-xr-x
fc-conflist	14.27 KB	-rwxr-xr-x
fc-list	14.34 KB	-rwxr-xr-x
fc-match	14.4 KB	-rwxr-xr-x
fc-pattern	14.33 KB	-rwxr-xr-x
fc-query	14.3 KB	-rwxr-xr-x
fc-scan	14.34 KB	-rwxr-xr-x
fc-validate	14.34 KB	-rwxr-xr-x
fcgistarter	13.99 KB	-rwxr-xr-x
filan	83.78 KB	-rwxr-xr-x
file	26.31 KB	-rwxr-xr-x
fincore	30.13 KB	-rwxr-xr-x
find	308.5 KB	-rwxr-xr-x
findaffix	11.74 KB	-rwxr-xr-x
finger	27.08 KB	-rwxr-xr-x
firewall-cmd	113.47 KB	-rwxr-xr-x
firewall-offline-cmd	101.17 KB	-rwxr-xr-x
flock	34.16 KB	-rwxr-xr-x
fmt	42.66 KB	-rwxr-xr-x
fold	38.66 KB	-rwxr-xr-x
formail	46.59 KB	-rwxr-xr-x
free	18.08 KB	-rwxr-xr-x
from	10.24 KB	-rwxr-xr-x
ftp	99.62 KB	-rwxr-xr-x
funzip	22.26 KB	-rwxr-xr-x
g++	1.05 MB	-rwxr-xr-x
g++-8	1.05 MB	-rwxr-xr-x
galera_new_cluster	917 B	-rwxr-xr-x
galera_recovery	3.28 KB	-rwxr-xr-x
gamma4scanimage	13.99 KB	-rwxr-xr-x
gapplication	22.07 KB	-rwxr-xr-x
gawk	658.81 KB	-rwxr-xr-x
gcc	1.05 MB	-rwxr-xr-x
gcc-4.9	813.49 KB	-rwxr-xr-x
gcc-6	926.77 KB	-rwxr-xr-x
gcc-8	1.05 MB	-rwxr-xr-x
gcc-ar	34.47 KB	-rwxr-xr-x
gcc-ar-4.9	24.25 KB	-rwxr-xr-x
gcc-ar-6	26.53 KB	-rwxr-xr-x
gcc-ar-8	34.47 KB	-rwxr-xr-x
gcc-nm	34.47 KB	-rwxr-xr-x
gcc-nm-4.9	24.19 KB	-rwxr-xr-x
gcc-nm-6	26.53 KB	-rwxr-xr-x
gcc-nm-8	34.47 KB	-rwxr-xr-x
gcc-ranlib	34.47 KB	-rwxr-xr-x
gcc-ranlib-4.9	24.19 KB	-rwxr-xr-x
gcc-ranlib-6	26.53 KB	-rwxr-xr-x
gcc-ranlib-8	34.47 KB	-rwxr-xr-x
gcov	672.09 KB	-rwxr-xr-x
gcov-4.9	440.43 KB	-rwxr-xr-x
gcov-6	507.93 KB	-rwxr-xr-x
gcov-8	672.09 KB	-rwxr-xr-x
gcov-dump	511.95 KB	-rwxr-xr-x
gcov-dump-6	439.86 KB	-rwxr-xr-x
gcov-dump-8	511.95 KB	-rwxr-xr-x
gcov-tool	548.02 KB	-rwxr-xr-x
gcov-tool-6	463.92 KB	-rwxr-xr-x
gcov-tool-8	548.02 KB	-rwxr-xr-x
gdbus	50.08 KB	-rwxr-xr-x
gdk-pixbuf-csource	14.01 KB	-rwxr-xr-x
gdk-pixbuf-pixdata	13.99 KB	-rwxr-xr-x
gdk-pixbuf-thumbnailer	18.08 KB	-rwxr-xr-x
gencat	26.6 KB	-rwxr-xr-x
geqn	201.19 KB	-rwxr-xr-x
getconf	34.37 KB	-rwxr-xr-x
getent	35.34 KB	-rwxr-xr-x
getfacl	30.62 KB	-rwxr-xr-x
getkeycodes	14.3 KB	-rwxr-xr-x
getopt	22.07 KB	-rwxr-xr-x
gettext	42.62 KB	-rwxr-xr-x
gettext.sh	4.52 KB	-rwxr-xr-x
gettextize	42.73 KB	-rwxr-xr-x
ghostscript	14.18 KB	-rwxr-xr-x
ginstall-info	47.73 KB	-rwxr-xr-x
gio	86.09 KB	-rwxr-xr-x
gio-querymodules	13.99 KB	-rwxr-xr-x
glib-compile-schemas	46.07 KB	-rwxr-xr-x
gold	2.97 MB	-rwxr-xr-x
gpasswd	82.05 KB	-rwsr-xr-x
gpg	1021.73 KB	-rwxr-xr-x
gpg-agent	396.73 KB	-rwxr-xr-x
gpg-connect-agent	158.85 KB	-rwxr-xr-x
gpg-wks-server	199.05 KB	-rwxr-xr-x
gpg-zip	3.43 KB	-rwxr-xr-x
gpg2	1021.73 KB	-rwxr-xr-x
gpgcompose	853.98 KB	-rwxr-xr-x
gpgconf	166.32 KB	-rwxr-xr-x
gpgparsemail	30.07 KB	-rwxr-xr-x
gpgsm	495.09 KB	-rwxr-xr-x
gpgsplit	82.45 KB	-rwxr-xr-x
gpgtar	151.32 KB	-rwxr-xr-x
gpgv	434.99 KB	-rwxr-xr-x
gpic	208.03 KB	-rwxr-xr-x
gprof	96.39 KB	-rwxr-xr-x
gresource	21.99 KB	-rwxr-xr-x
groff	117.22 KB	-rwxr-xr-x
grog	2.71 KB	-rwxr-xr-x
grops	177.63 KB	-rwxr-xr-x
grotty	129.25 KB	-rwxr-xr-x
groups	38.66 KB	-rwxr-xr-x
grub-editenv	369.96 KB	-rwxr-xr-x
grub-file	801.21 KB	-rwxr-xr-x
grub-fstest	922.9 KB	-rwxr-xr-x
grub-glue-efi	244.77 KB	-rwxr-xr-x
grub-kbdcomp	1.64 KB	-rwxr-xr-x
grub-menulst2cfg	228.85 KB	-rwxr-xr-x
grub-mkfont	269.46 KB	-rwxr-xr-x
grub-mkimage	349.96 KB	-rwxr-xr-x
grub-mklayout	249.09 KB	-rwxr-xr-x
grub-mknetdir	402.76 KB	-rwxr-xr-x
grub-mkpasswd-pbkdf2	249.15 KB	-rwxr-xr-x
grub-mkrelpath	240.49 KB	-rwxr-xr-x
grub-mkrescue	979.63 KB	-rwxr-xr-x
grub-mkstandalone	487.09 KB	-rwxr-xr-x
grub-mount	745.85 KB	-rwxr-xr-x
grub-ntldr-img	38.38 KB	-rwxr-xr-x
grub-render-label	817.77 KB	-rwxr-xr-x
grub-script-check	264.62 KB	-rwxr-xr-x
grub-syslinux2cfg	766.29 KB	-rwxr-xr-x
gs	14.18 KB	-rwxr-xr-x
gsbj	350 B	-rwxr-xr-x
gsdj	352 B	-rwxr-xr-x
gsdj500	352 B	-rwxr-xr-x
gsettings	30.07 KB	-rwxr-xr-x
gslj	353 B	-rwxr-xr-x
gslp	350 B	-rwxr-xr-x
gsnd	277 B	-rwxr-xr-x
gtbl	138.2 KB	-rwxr-xr-x
gtk-builder-tool	34.42 KB	-rwxr-xr-x
gtk-launch	18.15 KB	-rwxr-xr-x
gtk-query-settings	13.99 KB	-rwxr-xr-x
gtk-update-icon-cache	38.47 KB	-rwxr-xr-x
h2ph	28.54 KB	-rwxr-xr-x
h2xs	59.44 KB	-rwxr-xr-x
hd	26.55 KB	-rwxr-xr-x
head	46.72 KB	-rwxr-xr-x
helpztags	2.46 KB	-rwxr-xr-x
hexdump	26.55 KB	-rwxr-xr-x
host	126.63 KB	-rwxr-xr-x
hostid	34.59 KB	-rwxr-xr-x
hostnamectl	26.07 KB	-rwxr-xr-x
hsdb	6.35 KB	-rwxr-xr-x
htcacheclean	34 KB	-rwxr-xr-x
htdbm	25.99 KB	-rwxr-xr-x
htdigest	13.99 KB	-rwxr-xr-x
htpasswd	25.99 KB	-rwxr-xr-x
i386	22.34 KB	-rwxr-xr-x
icombine	34.38 KB	-rwxr-xr-x
iconv	59.01 KB	-rwxr-xr-x
id	42.78 KB	-rwxr-xr-x
idlj	6.34 KB	-rwxr-xr-x
ifnames	4.03 KB	-rwxr-xr-x
ijoin	14.03 KB	-rwxr-xr-x
info	242.79 KB	-rwxr-xr-x
infobrowser	242.79 KB	-rwxr-xr-x
infocmp	62.07 KB	-rwxr-xr-x
infotocap	86.11 KB	-rwxr-xr-x
innochecksum	3.46 MB	-rwxr-xr-x
innotop	445.81 KB	-rwxr-xr-x
install	151.6 KB	-rwxr-xr-x
install-info	47.73 KB	-rwxr-xr-x
instmodsh	4.27 KB	-rwxr-xr-x
ionice	30.08 KB	-rwxr-xr-x
ipcmk	30.14 KB	-rwxr-xr-x
ipcrm	30.08 KB	-rwxr-xr-x
ipcs	66.08 KB	-rwxr-xr-x
iptables-xml	100.68 KB	-rwxr-xr-x
ischroot	14.23 KB	-rwxr-xr-x
ispell	94.46 KB	-rwxr-xr-x
ispell-wrapper	7.05 KB	-rwxr-xr-x
jar	6.34 KB	-rwxr-xr-x
jarsigner	6.34 KB	-rwxr-xr-x
java	6.3 KB	-rwxr-xr-x
javac	6.34 KB	-rwxr-xr-x
javadoc	6.34 KB	-rwxr-xr-x
javah	6.34 KB	-rwxr-xr-x
javap	6.34 KB	-rwxr-xr-x
jcmd	6.34 KB	-rwxr-xr-x
jconsole	6.36 KB	-rwxr-xr-x
jdb	6.35 KB	-rwxr-xr-x
jdeps	6.34 KB	-rwxr-xr-x
jexec	10.33 KB	-rwxr-xr-x
jfr	6.34 KB	-rwxr-xr-x
jhat	6.34 KB	-rwxr-xr-x
jinfo	6.38 KB	-rwxr-xr-x
jjs	6.34 KB	-rwxr-xr-x
jmap	6.38 KB	-rwxr-xr-x
join	50.75 KB	-rwxr-xr-x
jps	6.34 KB	-rwxr-xr-x
jrunscript	6.34 KB	-rwxr-xr-x
jsadebugd	6.35 KB	-rwxr-xr-x
json_pp	4.28 KB	-rwxr-xr-x
jstack	6.38 KB	-rwxr-xr-x
jstat	6.34 KB	-rwxr-xr-x
jstatd	6.34 KB	-rwxr-xr-x
kbdinfo	14.31 KB	-rwxr-xr-x
kbxutil	162.66 KB	-rwxr-xr-x
kernel-install	4.53 KB	-rwxr-xr-x
keytool	6.34 KB	-rwxr-xr-x
killall	31.72 KB	-rwxr-xr-x
laptop-detect	3.73 KB	-rwxr-xr-x
last	46.08 KB	-rwxr-xr-x
lastb	46.08 KB	-rwxr-xr-x
lastlog	22.07 KB	-rwxr-xr-x
lcf	7.6 KB	-rwxr-xr-x
ld	1.7 MB	-rwxr-xr-x
ld.bfd	1.7 MB	-rwxr-xr-x
ld.gold	2.97 MB	-rwxr-xr-x
ldd	5.27 KB	-rwxr-xr-x
less	166.76 KB	-rwxr-xr-x
lessecho	14.02 KB	-rwxr-xr-x
lessfile	8.36 KB	-rwxr-xr-x
lesskey	23.39 KB	-rwxr-xr-x
lesspipe	8.36 KB	-rwxr-xr-x
lexgrog	94.57 KB	-rwxr-xr-x
lft	2.43 KB	-rwxr-xr-x
lft.db	2.43 KB	-rwxr-xr-x
libnetcfg	15.41 KB	-rwxr-xr-x
libtoolize	128.26 KB	-rwxr-xr-x
link	34.59 KB	-rwxr-xr-x
linux-boot-prober	1.54 KB	-rwxr-xr-x
linux-check-removal	4.56 KB	-rwxr-xr-x
linux-update-symlinks	6.17 KB	-rwxr-xr-x
linux-version	2.63 KB	-rwxr-xr-x
linux32	22.34 KB	-rwxr-xr-x
linux64	22.34 KB	-rwxr-xr-x
listres	10.62 KB	-rwxr-xr-x
lnstat	22.74 KB	-rwxr-xr-x
loadkeys	207.14 KB	-rwxr-xr-x
loadunimap	34.61 KB	-rwxr-xr-x
locale	54.04 KB	-rwxr-xr-x
localectl	26.07 KB	-rwxr-xr-x
localedef	299.75 KB	-rwxr-xr-x
locate	38.68 KB	-rwxr-sr-x
lockfile	18.25 KB	-rwxr-sr-x
logger	46.67 KB	-rwxr-xr-x
logname	34.59 KB	-rwxr-xr-x
logresolve	14 KB	-rwxr-xr-x
look	10.49 KB	-rwxr-xr-x
lorder	2.82 KB	-rwxr-xr-x
lsattr	14 KB	-rwxr-xr-x
lsb_release	3.55 KB	-rwxr-xr-x
lscpu	86.08 KB	-rwxr-xr-x
lsinitramfs	706 B	-rwxr-xr-x
lsipc	90.08 KB	-rwxr-xr-x
lslocks	34.41 KB	-rwxr-xr-x
lslogins	66.08 KB	-rwxr-xr-x
lsmem	62.08 KB	-rwxr-xr-x
lsns	50.08 KB	-rwxr-xr-x
lsof	171.47 KB	-rwxr-xr-x
lspci	80.31 KB	-rwxr-xr-x
lspgpot	1.06 KB	-rwxr-xr-x
luit	48.72 KB	-rwxr-xr-x
lwp-download	10.05 KB	-rwxr-xr-x
lwp-dump	2.65 KB	-rwxr-xr-x
lwp-mirror	2.36 KB	-rwxr-xr-x
lwp-request	15.82 KB	-rwxr-xr-x
lzcat	79.29 KB	-rwxr-xr-x
lzcmp	6.48 KB	-rwxr-xr-x
lzdiff	6.48 KB	-rwxr-xr-x
lzegrep	5.76 KB	-rwxr-xr-x
lzfgrep	5.76 KB	-rwxr-xr-x
lzgrep	5.76 KB	-rwxr-xr-x
lzless	1.76 KB	-rwxr-xr-x
lzma	79.29 KB	-rwxr-xr-x
lzmainfo	14.31 KB	-rwxr-xr-x
lzmore	2.11 KB	-rwxr-xr-x
m-a	57.17 KB	-rwxr-xr-x
m4	159.18 KB	-rwxr-xr-x
mac2unix	50.02 KB	-rwxr-xr-x
mail	110.24 KB	-rwxr-xr-x
mailq	1.13 MB	-rwsr-xr-x
mailstat	5.72 KB	-rwxr-xr-x
mailx	110.24 KB	-rwxr-xr-x
make	226.59 KB	-rwxr-xr-x
make-first-existing-target	4.79 KB	-rwxr-xr-x
makeinfo	52.78 KB	-rwxr-xr-x
man	112.5 KB	-rwxr-xr-x
mandb	134.72 KB	-rwxr-xr-x
manpath	34.47 KB	-rwxr-xr-x
mapscrn	26.58 KB	-rwxr-xr-x
mariadb	3.91 MB	-rwxr-xr-x
mariadb-check	3.67 MB	-rwxr-xr-x
mariadb-service-convert	2.45 KB	-rwxr-xr-x
mawk	119.12 KB	-rwxr-xr-x
mc	1011.96 KB	-rwxr-xr-x
mcdiff	1011.96 KB	-rwxr-xr-x
mcedit	1011.96 KB	-rwxr-xr-x
mcookie	34.14 KB	-rwxr-xr-x
mcview	1011.96 KB	-rwxr-xr-x
md5sum	46.72 KB	-rwxr-xr-x
md5sum.textutils	46.72 KB	-rwxr-xr-x
mdig	46.09 KB	-rwxr-xr-x
mesg	14.07 KB	-rwxr-xr-x
migrate-pubring-from-classic-g...	2.99 KB	-rwxr-xr-x
mk_modmap	15.78 KB	-rwxr-xr-x
mkfifo	62.91 KB	-rwxr-xr-x
mkpasswd	26.47 KB	-rwxr-xr-x
mlocate	38.68 KB	-rwxr-sr-x
mlock	14.3 KB	-rwxr-sr-x
module-assistant	57.17 KB	-rwxr-xr-x
msgattrib	26.45 KB	-rwxr-xr-x
msgcat	22.45 KB	-rwxr-xr-x
msgcmp	26.56 KB	-rwxr-xr-x
msgcomm	22.43 KB	-rwxr-xr-x
msgconv	22.41 KB	-rwxr-xr-x
msgen	22.41 KB	-rwxr-xr-x
msgexec	18.45 KB	-rwxr-xr-x
msgfilter	34.54 KB	-rwxr-xr-x
msgfmt	83.37 KB	-rwxr-xr-x
msggrep	42.79 KB	-rwxr-xr-x
msginit	67.17 KB	-rwxr-xr-x
msgmerge	71.39 KB	-rwxr-xr-x
msgunfmt	30.64 KB	-rwxr-xr-x
msguniq	22.42 KB	-rwxr-xr-x
msql2mysql	1.41 KB	-rwxr-xr-x
mtrace	6.32 KB	-rwxr-xr-x
munchlist	31.23 KB	-rwxr-xr-x
mutt	1.02 MB	-rwxr-xr-x
mutt_dotlock	14.01 KB	-rwxr-sr-x
my_print_defaults	3.37 MB	-rwxr-xr-x
myisam_ftdump	3.64 MB	-rwxr-xr-x
myisamchk	3.75 MB	-rwxr-xr-x
myisamlog	3.62 MB	-rwxr-xr-x
myisampack	3.65 MB	-rwxr-xr-x
mysql	3.91 MB	-rwxr-xr-x
mysql_convert_table_format	4.12 KB	-rwxr-xr-x
mysql_embedded	18.94 MB	-rwxr-xr-x
mysql_find_rows	3.21 KB	-rwxr-xr-x
mysql_fix_extensions	1.22 KB	-rwxr-xr-x
mysql_install_db	19.74 KB	-rwxr-xr-x
mysql_plugin	3.37 MB	-rwxr-xr-x
mysql_secure_installation	12.23 KB	-rwxr-xr-x
mysql_setpermission	17.13 KB	-rwxr-xr-x
mysql_tzinfo_to_sql	3.37 MB	-rwxr-xr-x
mysql_upgrade	3.46 MB	-rwxr-xr-x
mysql_waitpid	3.36 MB	-rwxr-xr-x
mysqlaccess	109.3 KB	-rwxr-xr-x
mysqladmin	3.7 MB	-rwxr-xr-x
mysqlanalyze	3.67 MB	-rwxr-xr-x
mysqlbinlog	3.92 MB	-rwxr-xr-x
mysqlcheck	3.67 MB	-rwxr-xr-x
mysqld_multi	26.67 KB	-rwxr-xr-x
mysqld_safe	30.08 KB	-rwxr-xr-x
mysqld_safe_helper	3.33 MB	-rwxr-xr-x
mysqldump	3.75 MB	-rwxr-xr-x
mysqldumpslow	8.05 KB	-rwxr-xr-x
mysqlhotcopy	34.14 KB	-rwxr-xr-x
mysqlimport	3.66 MB	-rwxr-xr-x
mysqloptimize	3.67 MB	-rwxr-xr-x
mysqlrepair	3.67 MB	-rwxr-xr-x
mysqlreport	50.03 KB	-rwxr-xr-x
mysqlshow	3.66 MB	-rwxr-xr-x
mysqlslap	3.68 MB	-rwxr-xr-x
mytop	63.3 KB	-rwxr-xr-x
namei	34.08 KB	-rwxr-xr-x
native2ascii	6.34 KB	-rwxr-xr-x
nawk	658.81 KB	-rwxr-xr-x
ncal	29.15 KB	-rwxr-xr-x
neqn	913 B	-rwxr-xr-x
netkit-ftp	99.62 KB	-rwxr-xr-x
newaliases	1.13 MB	-rwsr-xr-x
newgrp	43.4 KB	-rwsr-xr-x
ngettext	42.63 KB	-rwxr-xr-x
nice	38.63 KB	-rwxr-xr-x
nl	42.78 KB	-rwxr-xr-x
nload	138.03 KB	-rwxr-xr-x
nm	47.91 KB	-rwxr-xr-x
nohup	38.66 KB	-rwxr-xr-x
nproc	38.66 KB	-rwxr-xr-x
nroff	3.22 KB	-rwxr-xr-x
nsenter	34.28 KB	-rwxr-xr-x
nslookup	134.51 KB	-rwxr-xr-x
nstat	79.14 KB	-rwxr-xr-x
nsupdate	70.02 KB	-rwxr-xr-x
numfmt	62.81 KB	-rwxr-xr-x
objcopy	175.42 KB	-rwxr-xr-x
objdump	345.55 KB	-rwxr-xr-x
od	70.78 KB	-rwxr-xr-x
openssl	719.52 KB	-rwxr-xr-x
orbd	6.39 KB	-rwxr-xr-x
os-prober	4.44 KB	-rwxr-xr-x
pack200	6.34 KB	-rwxr-xr-x
pager	166.76 KB	-rwxr-xr-x
paperconf	14.29 KB	-rwxr-xr-x
parsechangelog	8.63 KB	-rwxr-xr-x
partx	106.08 KB	-rwxr-xr-x
passwd	62.24 KB	-rwsr-xr-x
paste	38.66 KB	-rwxr-xr-x
patch	183.44 KB	-rwxr-xr-x
pathchk	38.63 KB	-rwxr-xr-x
pcimodules	14.59 KB	-rwxr-xr-x
pcre-config	2.29 KB	-rwxr-xr-x
pcre2-config	1.93 KB	-rwxr-xr-x
pdb	45.02 KB	-rwxr-xr-x
pdb2	45.02 KB	-rwxr-xr-x
pdb2.7	45.02 KB	-rwxr-xr-x
pdb3	61.08 KB	-rwxr-xr-x
pdb3.7	61.08 KB	-rwxr-xr-x
pdf2dsc	698 B	-rwxr-xr-x
pdf2ps	909 B	-rwxr-xr-x
pdftexi2dvi	1.27 KB	-rwxr-xr-x
pear	793 B	-rwxr-xr-x
peardev	814 B	-rwxr-xr-x
pecl	727 B	-rwxr-xr-x
peekfd	14.28 KB	-rwxr-xr-x
perf	528 B	-rwxr-xr-x
perl	3.05 MB	-rwxr-xr-x
perl5.28-x86_64-linux-gnu	14.17 KB	-rwxr-xr-x
perl5.28.1	3.05 MB	-rwxr-xr-x
perlbug	45.28 KB	-rwxr-xr-x
perldoc	125 B	-rwxr-xr-x
perlivp	10.61 KB	-rwxr-xr-x
perlthanks	45.28 KB	-rwxr-xr-x
perror	3.55 MB	-rwxr-xr-x
pf2afm	498 B	-rwxr-xr-x
pfbtopfa	516 B	-rwxr-xr-x
pftp	99.62 KB	-rwxr-xr-x
pgrep	26.09 KB	-rwxr-xr-x
phar	14.88 KB	-rwxr-xr-x
phar.phar	14.88 KB	-rwxr-xr-x
phar.phar5.6	14.48 KB	-rwxr-xr-x
phar.phar7.0	14.48 KB	-rwxr-xr-x
phar.phar7.2	14.47 KB	-rwxr-xr-x
phar.phar7.3	14.47 KB	-rwxr-xr-x
phar.phar7.4	14.54 KB	-rwxr-xr-x
phar.phar8.2	14.88 KB	-rwxr-xr-x
phar5	14.48 KB	-rwxr-xr-x
phar5.6	14.48 KB	-rwxr-xr-x
phar7.0	14.48 KB	-rwxr-xr-x
phar7.2	14.47 KB	-rwxr-xr-x
phar7.3	14.47 KB	-rwxr-xr-x
phar7.4	14.54 KB	-rwxr-xr-x
phar7.4.phar	14.54 KB	-rwxr-xr-x
phar8.2	14.88 KB	-rwxr-xr-x
phar8.2.phar	14.88 KB	-rwxr-xr-x
php	4.53 MB	-rwxr-xr-x
php-cgi	4.43 MB	-rwxr-xr-x
php-cgi7.2	4.68 MB	-rwxr-xr-x
php-cgi7.3	4.47 MB	-rwxr-xr-x
php-cgi7.4	4.43 MB	-rwxr-xr-x
php-config	4.24 KB	-rwxr-xr-x
php-config7.2	4.14 KB	-rwxr-xr-x
php-config7.3	4.11 KB	-rwxr-xr-x
php-config7.4	4.24 KB	-rwxr-xr-x
php5	8.66 MB	-rwxr-xr-x
php5.6	4.3 MB	-rwxr-xr-x
php7.0	4.3 MB	-rwxr-xr-x
php7.2	4.79 MB	-rwxr-xr-x
php7.3	4.57 MB	-rwxr-xr-x
php7.4	4.53 MB	-rwxr-xr-x
php8.2	5.37 MB	-rwxr-xr-x
phpdbg	4.65 MB	-rwxr-xr-x
phpdbg7.2	4.91 MB	-rwxr-xr-x
phpdbg7.3	4.69 MB	-rwxr-xr-x
phpdbg7.4	4.65 MB	-rwxr-xr-x
phpize	4.81 KB	-rwxr-xr-x
phpize7.2	4.84 KB	-rwxr-xr-x
phpize7.3	4.87 KB	-rwxr-xr-x
phpize7.4	4.81 KB	-rwxr-xr-x
pic	208.03 KB	-rwxr-xr-x
pico	240.39 KB	-rwxr-xr-x
piconv	8.16 KB	-rwxr-xr-x
pigz	114.2 KB	-rwxr-xr-x
pinentry	86.49 KB	-rwxr-xr-x
pinentry-gtk-2	86.49 KB	-rwxr-xr-x
pinentry-x11	86.49 KB	-rwxr-xr-x
pinky	42.81 KB	-rwxr-xr-x
pkaction	14.31 KB	-rwxr-xr-x
pkcheck	22.66 KB	-rwxr-xr-x
pkcon	71.71 KB	-rwxr-xr-x
pkg-config	54.83 KB	-rwxr-xr-x
pkgtools	1.34 KB	-rwxr-xr-x
pkill	26.09 KB	-rwxr-xr-x
pkmon	22.49 KB	-rwxr-xr-x
pkttyagent	18.37 KB	-rwxr-xr-x
pl2pm	4.43 KB	-rwxr-xr-x
pldd	22.57 KB	-rwxr-xr-x
pmap	30.09 KB	-rwxr-xr-x
po2debconf	8.47 KB	-rwxr-xr-x
pod2html	4.04 KB	-rwxr-xr-x
pod2man	14.86 KB	-rwxr-xr-x
pod2texi	19.65 KB	-rwxr-xr-x
pod2text	10.85 KB	-rwxr-xr-x
pod2usage	3.86 KB	-rwxr-xr-x
podchecker	3.57 KB	-rwxr-xr-x
podebconf-display-po	12.67 KB	-rwxr-xr-x
podebconf-report-po	31.76 KB	-rwxr-xr-x
podselect	2.47 KB	-rwxr-xr-x
policytool	6.34 KB	-rwxr-xr-x
pphs	404 B	-rwxr-xr-x
pr	74.94 KB	-rwxr-xr-x
precat	5.52 KB	-rwxr-xr-x
preconv	66.2 KB	-rwxr-xr-x
preunzip	5.52 KB	-rwxr-xr-x
prezip	5.52 KB	-rwxr-xr-x
prezip-bin	13.99 KB	-rwxr-xr-x
print	17.74 KB	-rwxr-xr-x
printafm	395 B	-rwxr-xr-x
printenv	34.59 KB	-rwxr-xr-x
printerbanner	22.23 KB	-rwxr-xr-x
printf	54.69 KB	-rwxr-xr-x
prlimit	38.59 KB	-rwxr-xr-x
procan	71.68 KB	-rwxr-xr-x
procmail	95.2 KB	-rwsr-sr-x
prove	13.33 KB	-rwxr-xr-x
prtstat	18.36 KB	-rwxr-xr-x
ps2ascii	631 B	-rwxr-xr-x
ps2epsi	2.69 KB	-rwxr-xr-x
ps2pdf	272 B	-rwxr-xr-x
ps2pdf12	215 B	-rwxr-xr-x
ps2pdf13	215 B	-rwxr-xr-x
ps2pdf14	215 B	-rwxr-xr-x
ps2pdfwr	1.07 KB	-rwxr-xr-x
ps2ps	647 B	-rwxr-xr-x
ps2ps2	669 B	-rwxr-xr-x
ps2txt	631 B	-rwxr-xr-x
psfaddtable	22.31 KB	-rwxr-xr-x
psfgettable	22.31 KB	-rwxr-xr-x
psfstriptable	22.31 KB	-rwxr-xr-x
psfxtable	22.31 KB	-rwxr-xr-x
pslog	14.23 KB	-rwxr-xr-x
pstree	31.48 KB	-rwxr-xr-x
pstree.x11	31.48 KB	-rwxr-xr-x
ptar	3.47 KB	-rwxr-xr-x
ptardiff	2.57 KB	-rwxr-xr-x
ptargrep	4.29 KB	-rwxr-xr-x
ptx	74.91 KB	-rwxr-xr-x
pwdx	10.07 KB	-rwxr-xr-x
py3clean	7.62 KB	-rwxr-xr-x
py3compile	11.83 KB	-rwxr-xr-x
py3versions	11.44 KB	-rwxr-xr-x
pyclean	4.03 KB	-rwxr-xr-x
pycompile	11.62 KB	-rwxr-xr-x
pydoc	79 B	-rwxr-xr-x
pydoc2	79 B	-rwxr-xr-x
pydoc2.7	79 B	-rwxr-xr-x
pydoc3	79 B	-rwxr-xr-x
pydoc3.7	79 B	-rwxr-xr-x
pygettext	21.56 KB	-rwxr-xr-x
pygettext2	21.56 KB	-rwxr-xr-x
pygettext2.7	21.56 KB	-rwxr-xr-x
pygettext3	21.04 KB	-rwxr-xr-x
pygettext3.7	21.04 KB	-rwxr-xr-x
python	3.51 MB	-rwxr-xr-x
python2	3.51 MB	-rwxr-xr-x
python2.7	3.51 MB	-rwxr-xr-x
python3	4.65 MB	-rwxr-xr-x
python3.7	4.65 MB	-rwxr-xr-x
python3.7m	4.65 MB	-rwxr-xr-x
python3m	4.65 MB	-rwxr-xr-x
pyversions	14.76 KB	-rwxr-xr-x
querybts	10.75 KB	-rwxr-xr-x
ranlib	63.1 KB	-rwxr-xr-x
rcp	98.14 KB	-rwxr-xr-x
rdma	107.16 KB	-rwxr-xr-x
readelf	583.06 KB	-rwxr-xr-x
realpath	46.69 KB	-rwxr-xr-x
recode-sr-latin	14.4 KB	-rwxr-xr-x
rename.ul	22.07 KB	-rwxr-xr-x
renice	14.07 KB	-rwxr-xr-x
replace	3.34 MB	-rwxr-xr-x
report-hw	2.05 KB	-rwxr-xr-x
reportbug	105.14 KB	-rwxr-xr-x
reset	30 KB	-rwxr-xr-x
resizecons	22.58 KB	-rwxr-xr-x
resizepart	58.08 KB	-rwxr-xr-x
resolve_stack_dump	3.37 MB	-rwxr-xr-x
resolvectl	114.22 KB	-rwxr-xr-x
resolveip	3.36 MB	-rwxr-xr-x
rev	14.07 KB	-rwxr-xr-x
rgrep	30 B	-rwxr-xr-x
rlogin	714.79 KB	-rwxr-xr-x
rmic	6.34 KB	-rwxr-xr-x
rmid	6.34 KB	-rwxr-xr-x
rmiregistry	6.34 KB	-rwxr-xr-x
rotatelogs	26.07 KB	-rwxr-xr-x
routef	208 B	-rwxr-xr-x
routel	1.62 KB	-rwxr-xr-x
rpcgen	90.98 KB	-rwxr-xr-x
rpcinfo	34.16 KB	-rwxr-xr-x
rsh	714.79 KB	-rwxr-xr-x
rsync	488.37 KB	-rwxr-xr-x
rtstat	22.74 KB	-rwxr-xr-x
run-mailcap	17.74 KB	-rwxr-xr-x
run-with-aspell	57 B	-rwxr-xr-x
runcon	38.72 KB	-rwxr-xr-x
rview	2.58 MB	-rwxr-xr-x
rvim	2.58 MB	-rwxr-xr-x
sane-find-scanner	114.7 KB	-rwxr-xr-x
savelog	10.22 KB	-rwxr-xr-x
scanimage	50.77 KB	-rwxr-xr-x
schemagen	6.34 KB	-rwxr-xr-x
scp	98.14 KB	-rwxr-xr-x
screendump	14.29 KB	-rwxr-xr-x
script	50.08 KB	-rwxr-xr-x
scriptreplay	30.08 KB	-rwxr-xr-x
sdiff	50.77 KB	-rwxr-xr-x
see	17.74 KB	-rwxr-xr-x
select-default-iwrap	474 B	-rwxr-xr-x
select-editor	2.38 KB	-rwxr-xr-x
sensible-browser	1.18 KB	-rwxr-xr-x
sensible-editor	1.08 KB	-rwxr-xr-x
sensible-pager	433 B	-rwxr-xr-x
seq	50.69 KB	-rwxr-xr-x
serialver	6.34 KB	-rwxr-xr-x
servertool	6.34 KB	-rwxr-xr-x
setarch	22.34 KB	-rwxr-xr-x
setfacl	38.68 KB	-rwxr-xr-x
setkeycodes	14.3 KB	-rwxr-xr-x
setleds	14.29 KB	-rwxr-xr-x
setlogcons	14.3 KB	-rwxr-xr-x
setmetamode	14.34 KB	-rwxr-xr-x
setpci	22.54 KB	-rwxr-xr-x
setpriv	42.08 KB	-rwxr-xr-x
setsid	14.07 KB	-rwxr-xr-x
setterm	42.08 KB	-rwxr-xr-x
setvtrgb	14.42 KB	-rwxr-xr-x
sftp	150.35 KB	-rwxr-xr-x
sg	43.4 KB	-rwsr-xr-x
sha1sum	50.72 KB	-rwxr-xr-x
sha224sum	54.72 KB	-rwxr-xr-x
sha256sum	54.72 KB	-rwxr-xr-x
sha384sum	62.72 KB	-rwxr-xr-x
sha512sum	62.72 KB	-rwxr-xr-x
shasum	9.74 KB	-rwxr-xr-x
showconsolefont	18.38 KB	-rwxr-xr-x
showkey	18.34 KB	-rwxr-xr-x
shred	58.94 KB	-rwxr-xr-x
shtool	138.76 KB	-rwxr-xr-x
shtoolize	15.16 KB	-rwxr-xr-x
shuf	58.81 KB	-rwxr-xr-x
size	34.97 KB	-rwxr-xr-x
skill	26.08 KB	-rwxr-xr-x
slabtop	18.08 KB	-rwxr-xr-x
slogin	714.79 KB	-rwxr-xr-x
smime_keys	30.08 KB	-rwxr-xr-x
snice	26.08 KB	-rwxr-xr-x
socat	369.43 KB	-rwxr-xr-x
soelim	42.2 KB	-rwxr-xr-x
sort	111.45 KB	-rwxr-xr-x
sotruss	4.18 KB	-rwxr-xr-x
splain	18.7 KB	-rwxr-xr-x
split	59.32 KB	-rwxr-xr-x
splitfont	14.19 KB	-rwxr-xr-x
sprof	26.69 KB	-rwxr-xr-x
sq	5.99 KB	-rwxr-xr-x
ssh	714.79 KB	-rwxr-xr-x
ssh-add	334.13 KB	-rwxr-xr-x
ssh-agent	314.13 KB	-rwxr-sr-x
ssh-argv0	1.42 KB	-rwxr-xr-x
ssh-copy-id	10.41 KB	-rwxr-xr-x
ssh-keygen	406.15 KB	-rwxr-xr-x
ssh-keyscan	410.15 KB	-rwxr-xr-x
stat	79.03 KB	-rwxr-xr-x
stdbuf	50.69 KB	-rwxr-xr-x
strings	31.13 KB	-rwxr-xr-x
strip	175.43 KB	-rwxr-xr-x
sudo	153.51 KB	-rwsr-xr-x
sudoedit	153.51 KB	-rwsr-xr-x
sudoreplay	62.84 KB	-rwxr-xr-x
sum	42.73 KB	-rwxr-xr-x
symcryptrun	118.73 KB	-rwxr-xr-x
systemd-analyze	1.38 MB	-rwxr-xr-x
systemd-cat	14.08 KB	-rwxr-xr-x
systemd-cgls	18.17 KB	-rwxr-xr-x
systemd-cgtop	38.09 KB	-rwxr-xr-x
systemd-delta	26.07 KB	-rwxr-xr-x
systemd-detect-virt	14.06 KB	-rwxr-xr-x
systemd-id128	14.06 KB	-rwxr-xr-x
systemd-mount	46.29 KB	-rwxr-xr-x
systemd-path	18.06 KB	-rwxr-xr-x
systemd-resolve	114.22 KB	-rwxr-xr-x
systemd-run	50.27 KB	-rwxr-xr-x
systemd-socket-activate	26.07 KB	-rwxr-xr-x
systemd-stdio-bridge	18.07 KB	-rwxr-xr-x
systemd-umount	46.29 KB	-rwxr-xr-x
tabs	17.99 KB	-rwxr-xr-x
tac	42.72 KB	-rwxr-xr-x
tail	70.91 KB	-rwxr-xr-x
tasksel	16.1 KB	-rwxr-xr-x
taskset	34.08 KB	-rwxr-xr-x
tbl	138.2 KB	-rwxr-xr-x
tee	38.72 KB	-rwxr-xr-x
telnet	113.37 KB	-rwxr-xr-x
telnet.netkit	113.37 KB	-rwxr-xr-x
test	50.66 KB	-rwxr-xr-x
texi2any	52.78 KB	-rwxr-xr-x
texi2dvi	60.31 KB	-rwxr-xr-x
texi2pdf	1.27 KB	-rwxr-xr-x
texindex	3.96 KB	-rwxr-xr-x
tic	86.11 KB	-rwxr-xr-x
time	14.73 KB	-rwxr-xr-x
timedatectl	38.07 KB	-rwxr-xr-x
timeout	43.26 KB	-rwxr-xr-x
tload	14.09 KB	-rwxr-xr-x
tnameserv	6.39 KB	-rwxr-xr-x
toe	21.99 KB	-rwxr-xr-x
top	113.89 KB	-rwxr-xr-x
touch	94.88 KB	-rwxr-xr-x
tput	22.02 KB	-rwxr-xr-x
tr	50.69 KB	-rwxr-xr-x
traceproto	2.82 KB	-rwxr-xr-x
traceproto.db	2.82 KB	-rwxr-xr-x
traceroute	67.16 KB	-rwxr-xr-x
traceroute-nanog	1.58 KB	-rwxr-xr-x
traceroute.db	67.16 KB	-rwxr-xr-x
traceroute6	67.16 KB	-rwxr-xr-x
traceroute6.db	67.16 KB	-rwxr-xr-x
troff	723.59 KB	-rwxr-xr-x
truncate	42.66 KB	-rwxr-xr-x
tryaffix	4.8 KB	-rwxr-xr-x
tset	30 KB	-rwxr-xr-x
tsort	42.66 KB	-rwxr-xr-x
tty	34.63 KB	-rwxr-xr-x
txixml2texi	14.67 KB	-rwxr-xr-x
tzselect	15.01 KB	-rwxr-xr-x
ucf	39.73 KB	-rwxr-xr-x
ucfq	18.91 KB	-rwxr-xr-x
ucfr	10.47 KB	-rwxr-xr-x
ul	14.3 KB	-rwxr-xr-x
umax_pp	179.07 KB	-rwxr-xr-x
unattended-upgrade	83.83 KB	-rwxr-xr-x
unattended-upgrades	83.83 KB	-rwxr-xr-x
unexpand	42.69 KB	-rwxr-xr-x
unicode_stop	530 B	-rwxr-xr-x
uniq	50.75 KB	-rwxr-xr-x
unix2dos	50.02 KB	-rwxr-xr-x
unix2mac	50.02 KB	-rwxr-xr-x
unlink	34.59 KB	-rwxr-xr-x
unlzma	79.29 KB	-rwxr-xr-x
unmkinitramfs	3.51 KB	-rwxr-xr-x
unpack200	101.48 KB	-rwxr-xr-x
unpigz	114.2 KB	-rwxr-xr-x
unshare	26.27 KB	-rwxr-xr-x
unsq	5.99 KB	-rwxr-xr-x
unxz	79.29 KB	-rwxr-xr-x
unzip	178.84 KB	-rwxr-xr-x
unzipsfx	82.66 KB	-rwxr-xr-x
update-alternatives	54.25 KB	-rwxr-xr-x
update-mime-database	55.19 KB	-rwxr-xr-x
update-perl-sax-parsers	6.03 KB	-rwxr-xr-x
updatedb	46.82 KB	-rwxr-xr-x
updatedb.mlocate	46.82 KB	-rwxr-xr-x
uptime	10.07 KB	-rwxr-xr-x
users	34.66 KB	-rwxr-xr-x
utmpdump	30.07 KB	-rwxr-xr-x
vi	2.58 MB	-rwxr-xr-x
view	2.58 MB	-rwxr-xr-x
viewres	27.38 KB	-rwxr-xr-x
vim	2.58 MB	-rwxr-xr-x
vim.basic	2.58 MB	-rwxr-xr-x
vim.tiny	1.15 MB	-rwxr-xr-x
vimdiff	2.58 MB	-rwxr-xr-x
vimtutor	2.07 KB	-rwxr-xr-x
vmstat	34.09 KB	-rwxr-xr-x
volname	5.99 KB	-rwxr-xr-x
w	18.07 KB	-rwxr-xr-x
w.procps	18.07 KB	-rwxr-xr-x
w3m	1.4 MB	-rwxr-xr-x
w3mman	1.18 KB	-rwxr-xr-x
wall	34.08 KB	-rwxr-xr-x
watch	26.41 KB	-rwxr-xr-x
watchgnupg	17.99 KB	-rwxr-xr-x
wc	46.76 KB	-rwxr-xr-x
wget	455.56 KB	-rwxr-xr-x
whatis	54.98 KB	-rwxr-xr-x
whereis	30.51 KB	-rwxr-xr-x
which	946 B	-rwxr-xr-x
whiptail	26.7 KB	-rwxr-xr-x
who	54.81 KB	-rwxr-xr-x
whoami	34.63 KB	-rwxr-xr-x
whois	153.27 KB	-rwxr-xr-x
word-list-compress	13.99 KB	-rwxr-xr-x
write	14.39 KB	-rwxr-sr-x
wsgen	6.34 KB	-rwxr-xr-x
wsimport	6.34 KB	-rwxr-xr-x
wsrep_sst_common	54.05 KB	-rwxr-xr-x
wsrep_sst_mariabackup	50.87 KB	-rwxr-xr-x
wsrep_sst_mysqldump	7.67 KB	-rwxr-xr-x
wsrep_sst_rsync	32.17 KB	-rwxr-xr-x
wsrep_sst_rsync_wan	32.17 KB	-rwxr-xr-x
www-browser	1.4 MB	-rwxr-xr-x
x86_64	22.34 KB	-rwxr-xr-x
x86_64-linux-gnu-addr2line	31.09 KB	-rwxr-xr-x
x86_64-linux-gnu-ar	63.07 KB	-rwxr-xr-x
x86_64-linux-gnu-as	872.93 KB	-rwxr-xr-x
x86_64-linux-gnu-c++filt	30.69 KB	-rwxr-xr-x
x86_64-linux-gnu-cpp	1.05 MB	-rwxr-xr-x
x86_64-linux-gnu-cpp-4.9	814.43 KB	-rwxr-xr-x
x86_64-linux-gnu-cpp-6	930.77 KB	-rwxr-xr-x
x86_64-linux-gnu-cpp-8	1.05 MB	-rwxr-xr-x
x86_64-linux-gnu-dwp	2.74 MB	-rwxr-xr-x
x86_64-linux-gnu-elfedit	38.84 KB	-rwxr-xr-x
x86_64-linux-gnu-g++	1.05 MB	-rwxr-xr-x
x86_64-linux-gnu-g++-8	1.05 MB	-rwxr-xr-x
x86_64-linux-gnu-gcc	1.05 MB	-rwxr-xr-x
x86_64-linux-gnu-gcc-4.9	813.49 KB	-rwxr-xr-x
x86_64-linux-gnu-gcc-6	926.77 KB	-rwxr-xr-x
x86_64-linux-gnu-gcc-8	1.05 MB	-rwxr-xr-x
x86_64-linux-gnu-gcc-ar	34.47 KB	-rwxr-xr-x
x86_64-linux-gnu-gcc-ar-4.9	24.25 KB	-rwxr-xr-x
x86_64-linux-gnu-gcc-ar-6	26.53 KB	-rwxr-xr-x
x86_64-linux-gnu-gcc-ar-8	34.47 KB	-rwxr-xr-x
x86_64-linux-gnu-gcc-nm	34.47 KB	-rwxr-xr-x
x86_64-linux-gnu-gcc-nm-4.9	24.19 KB	-rwxr-xr-x
x86_64-linux-gnu-gcc-nm-6	26.53 KB	-rwxr-xr-x
x86_64-linux-gnu-gcc-nm-8	34.47 KB	-rwxr-xr-x
x86_64-linux-gnu-gcc-ranlib	34.47 KB	-rwxr-xr-x
x86_64-linux-gnu-gcc-ranlib-4....	24.19 KB	-rwxr-xr-x
x86_64-linux-gnu-gcc-ranlib-6	26.53 KB	-rwxr-xr-x
x86_64-linux-gnu-gcc-ranlib-8	34.47 KB	-rwxr-xr-x
x86_64-linux-gnu-gcov	672.09 KB	-rwxr-xr-x
x86_64-linux-gnu-gcov-4.9	440.43 KB	-rwxr-xr-x
x86_64-linux-gnu-gcov-6	507.93 KB	-rwxr-xr-x
x86_64-linux-gnu-gcov-8	672.09 KB	-rwxr-xr-x
x86_64-linux-gnu-gcov-dump	511.95 KB	-rwxr-xr-x
x86_64-linux-gnu-gcov-dump-6	439.86 KB	-rwxr-xr-x
x86_64-linux-gnu-gcov-dump-8	511.95 KB	-rwxr-xr-x
x86_64-linux-gnu-gcov-tool	548.02 KB	-rwxr-xr-x
x86_64-linux-gnu-gcov-tool-6	463.92 KB	-rwxr-xr-x
x86_64-linux-gnu-gcov-tool-8	548.02 KB	-rwxr-xr-x
x86_64-linux-gnu-gold	2.97 MB	-rwxr-xr-x
x86_64-linux-gnu-gprof	96.39 KB	-rwxr-xr-x
x86_64-linux-gnu-ld	1.7 MB	-rwxr-xr-x
x86_64-linux-gnu-ld.bfd	1.7 MB	-rwxr-xr-x
x86_64-linux-gnu-ld.gold	2.97 MB	-rwxr-xr-x
x86_64-linux-gnu-nm	47.91 KB	-rwxr-xr-x
x86_64-linux-gnu-objcopy	175.42 KB	-rwxr-xr-x
x86_64-linux-gnu-objdump	345.55 KB	-rwxr-xr-x
x86_64-linux-gnu-pkg-config	2 KB	-rwxr-xr-x
x86_64-linux-gnu-ranlib	63.1 KB	-rwxr-xr-x
x86_64-linux-gnu-readelf	583.06 KB	-rwxr-xr-x
x86_64-linux-gnu-size	34.97 KB	-rwxr-xr-x
x86_64-linux-gnu-strings	31.13 KB	-rwxr-xr-x
x86_64-linux-gnu-strip	175.43 KB	-rwxr-xr-x
x86_64-pc-linux-gnu-pkg-config	54.83 KB	-rwxr-xr-x
xargs	70.21 KB	-rwxr-xr-x
xauth	47.45 KB	-rwxr-xr-x
xdg-user-dir	234 B	-rwxr-xr-x
xdg-user-dirs-update	26.07 KB	-rwxr-xr-x
xdpyinfo	31.49 KB	-rwxr-xr-x
xdriinfo	10.19 KB	-rwxr-xr-x
xev	30.96 KB	-rwxr-xr-x
xfd	32.33 KB	-rwxr-xr-x
xfontsel	40.33 KB	-rwxr-xr-x
xgettext	269.8 KB	-rwxr-xr-x
xjc	6.34 KB	-rwxr-xr-x
xkill	14.32 KB	-rwxr-xr-x
xlsatoms	10.26 KB	-rwxr-xr-x
xlsclients	14.34 KB	-rwxr-xr-x
xlsfonts	18.44 KB	-rwxr-xr-x
xmessage	23.33 KB	-rwxr-xr-x
xprop	40.9 KB	-rwxr-xr-x
xsubpp	5.04 KB	-rwxr-xr-x
xvinfo	14.26 KB	-rwxr-xr-x
xwininfo	42.78 KB	-rwxr-xr-x
xxd	18.12 KB	-rwxr-xr-x
xz	79.29 KB	-rwxr-xr-x
xzcat	79.29 KB	-rwxr-xr-x
xzcmp	6.48 KB	-rwxr-xr-x
xzdiff	6.48 KB	-rwxr-xr-x
xzegrep	5.76 KB	-rwxr-xr-x
xzfgrep	5.76 KB	-rwxr-xr-x
xzgrep	5.76 KB	-rwxr-xr-x
xzless	1.76 KB	-rwxr-xr-x
xzmore	2.11 KB	-rwxr-xr-x
yes	34.59 KB	-rwxr-xr-x
zdump	18.4 KB	-rwxr-xr-x
zipdetails	47.36 KB	-rwxr-xr-x
zipgrep	2.88 KB	-rwxr-xr-x
zipinfo	178.84 KB	-rwxr-xr-x

Code Editor : mytop

#!/usr/bin/perl
#
# $Id: mytop,v 1.91 2012/01/18 16:49:12 mgrennan Exp $

=pod

=head1 NAME

mytop - display MariaDB server performance info like `top'

=cut

## most of the POD is at the bottom of the file

use 5.005;
use strict;
use DBI;
use Config::IniFiles;
use Getopt::Long;
use Socket;
use List::Util qw(min max);
use File::Basename;

$main::VERSION = "1.91a";
my $path_for_script= dirname($0);

$|=1;
$0 = 'mytop';

my $WIN = ($^O eq 'MSWin32') ? 1 : 0;

## Test for color support.

eval { require Term::ANSIColor; };

my $HAS_COLOR = $@ ? 0 : 1;

$HAS_COLOR = 0 if $WIN;

## Test of Time::HiRes support

eval { require Time::HiRes };

my $HAS_TIME = $@ ? 0 : 1;

my $debug = 0;

## Try to lower our priority (which, who, pri)

setpriority(0,0,10) unless $WIN;

## Prototypes

sub Clear();
sub GetData();
sub GetQPS();
sub FullQueryInfo($);
sub Explain($);
sub PrintTable(@);
sub PrintHelp();
sub Sum(@);
sub commify($);
sub make_short($);
sub Hashes($);
sub Execute($);
sub StringOrRegex($);
sub GetInnoDBStatus();
sub GetCmdSummary();
sub GetShowVariables();
sub GetShowStatus();
sub cmd_s;
sub cmd_S;
sub cmd_q;

## Default Config Values

my %config = (
    batchmode     => 0,
    color         => 1,
    db            => '',
    database	  => '',
    delay         => 5,
    filter_user   => qr/.?/,
    filter_db     => qr/.?/,
    filter_host   => qr/.?/,
    filter_state  => qr/.?/,
    header        => 1,
    help          => 0,
    host          => 'localhost',
    idle          => 1,
    long	  => 120,
    long_nums     => 0,
    mode          => 'top',
    prompt        => 0,
    pass          => '',
    password	  => '',
    port          => 3306,
    resolve       => 0,
    slow	  => 10,	# slow query time
    socket        => '',
    sort          => 1,         # default or reverse sort ("s")
    user          => 'root',
    fullqueries   => 0
);

my %qcache = ();    ## The query cache--used for full query info support.
my %ucache = ();    ## The user cache--used for full killing by user
my %dbcache = ();   ## The db cache.  This should be merged at some point.
my %statcache = (); ## The show status cache for GetShowStatus()

my (%STATUS, %OLD_STATUS); # header stuff.

my $CLEAR = $WIN ? '': `clear`;

## Term::ReadKey values

my $RM_RESET   = 0;
my $RM_NOBLKRD = 3; ## using 4 traps Ctrl-C :-(

# Add options from .my.cnf first

my $my_print_defaults;
if (!defined($my_print_defaults=my_which("my_print_defaults")))
{
  print "Warning: Can't find my_print_defaults. Please add it to your PATH!\n";
  exit(1);
}

unshift @ARGV, split "\n", `$my_print_defaults client mytop`;

## Try ~/.my.cnf first

my $mycnf = "$ENV{HOME}/.my.cnf";

if (-e $mycnf)
{
       my $cfgini = new Config::IniFiles( -file => $mycnf );
	if ( not defined $cfgini )
        {
                foreach my $error (@Config::IniFiles::errors)
                {
                        print $error;
                        print "\n";
                }
                exit;
        }

my @sections = ('client', 'mytop');

foreach my $section (@sections) {
                foreach my $param ($cfgini->Parameters ($section))
                {
                        $config{$param} = $cfgini->val($section, $param) if exists $config{$param};
                }
        }
        ## map database/password onto db/pass (long version gets precedence in .my.cnf)
        $config{'db'} = $config{'database'} if $config{'database'};
        $config{'pass'} = $config{'password'} if $config{'password'};
}

## Read the user's config file, if it exists.

my $config = "$ENV{HOME}/.mytop";

if (-e $config)
{
    if (open CFG, "<$config")
    {
        while (<CFG>)
        {
            next if /^\s*$/;  ## skip blanks
            next if /^\s*#/;  ## skip comments

chomp;

if (/(\S+)\s*=\s*(.*\S)/)
            {
                $config{lc $1} = $2 if exists $config{lc $1};
            }
        }
        close CFG;
    }
    ## map database/password onto db/pass (short version gets precedence for historical reasons)
    $config{'db'} = $config{'database'} unless $config{'db'};
    $config{'pass'} = $config{'password'} unless $config{'pass'};
}

## Command-line args.

use vars qw($opt_foo);

Getopt::Long::Configure('no_ignore_case', 'bundling');

GetOptions(
    "color!"              => \$config{color},
    "user|u=s"            => \$config{user},
    "pass|password|p=s"   => \$config{pass},
    "database|db|d=s"     => \$config{db},
    "host|h=s"            => \$config{host},
    "port|P=i"            => \$config{port},
    "socket|S=s"          => \$config{socket},
    "delay|s=i"           => \$config{delay},
    "batch|batchmode|b"   => \$config{batchmode},
    "header!"             => \$config{header},
    "idle|i!"             => \$config{idle},
    "resolve|r!"          => \$config{resolve},
    "prompt!"             => \$config{prompt},
    "long=i"		  => \$config{long},
    "long_nums!"          => \$config{long_nums},
    "mode|m=s"            => \$config{mode},
    "slow=i"		  => \$config{slow},
    "sort=s"              => \$config{sort},
    "fullqueries|L!"      => \$config{fullqueries}
);

## User may have put the port with the host.

if ($config{host} =~ s/:(\d+)$//)
{
    $config{port} = $1;
}

## Don't use Term::ReadKey unless running interactively.

if (not $config{batchmode})
{
    require Term::ReadKey;
    Term::ReadKey->import();
}

## User may want to disable color.

if ($HAS_COLOR and not $config{color})
{
    $HAS_COLOR = 0;
}

if ($HAS_COLOR)
{
    import Term::ANSIColor ':constants';
}
else
{
    *RESET  = sub { };
    *YELLOW = sub { };
    *RED    = sub { };
    *MAGENTA  = sub { };
    *GREEN  = sub { };
    *BLUE   = sub { };
    *WHITE  = sub { };
    *BOLD   = sub { };
}

my $RESET  = RESET()   || '';
my $YELLOW = YELLOW()  || '';
my $RED    = RED()     || '';
my $MAGENTA  = MAGENTA()   || '';
my $GREEN  = GREEN()   || '';
my $BLUE   = BLUE()    || '';
my $WHITE  = WHITE()   || '';
my $BOLD   = BOLD()    || '';

## Connect

my $dsn;

## Socket takes precedence.

$dsn ="DBI:mysql:database=$config{db};mysql_read_default_group=mytop;";

if ($config{socket} and -S $config{socket})
{
    $dsn .= "mysql_socket=$config{socket}";
}
else
{
    $dsn .= "host=$config{host};port=$config{port}";
}

if ($config{prompt})
{
    print "Password: ";
    ReadMode(2);
    chomp($config{pass} = <STDIN>);
    ReadMode(0);
    print "\n";
}

my $dbh = DBI->connect($dsn, $config{user}, $config{pass},
                       { PrintError => 0 });

if (not ref $dbh)
{
    my $Error = <<EODIE
Cannot connect to MariaDB server. Please check the:

* database you specified "$config{db}" (default is "")
  * username you specified "$config{user}" (default is "root")
  * password you specified "$config{pass}" (default is "")
  * hostname you specified "$config{host}" (default is "localhost")
  * port you specified "$config{port}" (default is 3306)
  * socket you specified "$config{socket}" (default is "")

The options my be specified on the command-line or in a ~/.mytop or
~/.my.cnf config file. See the manual (perldoc mytop) for details.

Here's the exact error from DBI. It might help you debug:

$DBI::errstr

EODIE
;

die $Error;

}

ReadMode($RM_RESET) unless $config{batchmode};

## Get static data

my $db_version;
my $db_release;
my $server="MySQL";
my $have_query_cache;

my @variables = Hashes("show variables");

foreach (@variables)
{
    if ($_->{Variable_name} eq "version")
    {
	if($_->{Value} =~ m/-/)
	{
	    my @tmp_db_version = split(/-/,$_->{Value});
	    $_->{Value} = $tmp_db_version[0];
	}
        $db_version = $_->{Value};
	$db_version =~ /(\d+)/;
        $db_release = $1;
        $server="MariaDB" if ($db_version =~ /maria/i);
        next;
    }
    if ($_->{Variable_name} eq "have_query_cache")
    {
#        if ($_->{Value} eq 'YES')
	if ($_->{Value} eq 'YES' or $_->{Value} eq 'DEMAND')  # http://freshmeat.net/users/jerjones
        {
            $have_query_cache = 1;
        }
        else
        {
            $have_query_cache = 0;
        }
        next;
    }
}

#########################################################################
##
## The main loop
##
#########################################################################

ReadMode($RM_NOBLKRD)  unless $config{batchmode};

while (1)
{
    my $key;

if ($config{mode} eq 'qps')
    {
        GetQPS();
        $key = ReadKey(1);

next unless $key;

if ($key =~ /t/i)
        {
            $config{mode} = 'top';
        }
        if ($key =~ /q/)
        {
            cmd_q();
        }
        next;
    }
    if ($config{mode} eq 'top')
    {
        GetData();
        last if $config{batchmode};
        $key = ReadKey($config{delay});
        next unless $key;
    }
    elsif ($config{mode} eq 'cmd')
    {
        GetCmdSummary();
        last if $config{batchmode};
        $key = ReadKey($config{delay});
        next unless $key;
    }
    elsif ($config{mode} eq 'innodb')
    {
        GetInnoDBStatus();
        last if $config{batchmode};
        $key = ReadKey($config{delay});
        next unless $key;
    }
    elsif ($config{mode} eq 'status')
    {
        GetShowStatus();
        last if $config{batchmode};
        $key = ReadKey($config{delay});
        next unless $key;
    }

##
    ## keystroke command processing (if we get this far)
    ##

if ($key eq '!')
    {
        Execute("stop slave");
	Execute("set global sql_slave_skip_counter=1");
	Execute("start slave");
    }

# t - top

if ($key =~ /t/i)
    {
        $config{mode} = 'top';
    }

## q - quit

if ($key eq 'q')
    {
        cmd_q();
    }

if ($key eq 'D')
    {
        require Data::Dumper;
        print Data::Dumper::Dumper([\%config]);
        ReadKey(0);
    }

## l - change long running hightling

if ($key eq 'l')
    {
        cmd_l();
        next;
    }

## m - mode switch to qps

if ($key eq 'm')
    {
        $config{mode} = 'qps';
        Clear() unless $config{batchmode};
	print "Queries Per Second\n";
        next;
    }

## c - mode switch to command summary

if ($key eq 'c')
    {
        $config{mode} = 'cmd';
        Clear() unless $config{batchmode};
       	print "Command Summary\n";
	next;
    }

## C - change Color on and off

if ($key eq 'C')
    {
	if ( $HAS_COLOR )
        {
	    $HAS_COLOR = 0;
	}
	else
	{
	    $HAS_COLOR = 1;
	}
    }

## s - seconds of delay

if ($key eq 's')
    {
        cmd_s();
        next;
    }

if ($key eq 'S')
    {
	cmd_S();
	next;
    }

## R - resolve hostnames
    if ($key eq 'R')
    {
        if ($config{resolve})
        {
            $config{resolve} = 0;
        }
        else
        {
            $config{resolve} = 1;
        }
    }

## t - username based filter

if ($key eq 't')
    {
        ReadMode($RM_RESET);
        print RED(), "Which state (blank for all, /.../ for regex): ", RESET();
        $config{filter_state} = StringOrRegex(ReadLine(0));
        ReadMode($RM_NOBLKRD);
        next;
    }

## u - username based filter

if ($key eq 'u')
    {
        ReadMode($RM_RESET);
        print RED(), "Which user (blank for all, /.../ for regex): ", RESET();
        $config{filter_user} = StringOrRegex(ReadLine(0));
        ReadMode($RM_NOBLKRD);
        next;
    }

## d - database name based filter

if ($key eq 'd')
    {
        ReadMode($RM_RESET);
        print RED(), "Which database (blank for all, /.../ for regex): ",
            RESET();
        $config{filter_db} = StringOrRegex(ReadLine(0));
        ReadMode($RM_NOBLKRD);
        next;
    }

## h - hostname based filter

if ($key eq 'h')
    {
        ReadMode($RM_RESET);
        print RED(), "Which hostname (blank for all, /.../ for regex): ",
            RESET();
        $config{filter_host} = StringOrRegex(ReadLine(0));
        ReadMode($RM_NOBLKRD);
        next;
    }

## E - Show full Replication Error

if ($key eq 'E')
    {
	my($data) = Hashes('SHOW SLAVE STATUS');
	Clear();
	print "Error is: $data->{Last_Error}\n";
        print RED(), "-- paused. press any key to resume --", RESET();
	ReadKey(0);
	next;
    }
    ## F - remove all filters

if ($key eq 'F')
    {
        $config{filter_host}  = qr/.?/;
        $config{filter_db}    = qr/.?/;
        $config{filter_user}  = qr/.?/;
        $config{filter_state} = qr/.?/;
        print RED(), "-- display unfiltered --", RESET();
        sleep 1;
        next;
    }

## p - pause

if ($key eq 'p')
    {
        print RED(), "-- paused. press any key to resume --", RESET();
        ReadKey(0);
        next;
    }

## i - idle toggle

if ($key =~ /i/)
    {
        if ($config{idle})
        {
            $config{idle} = 0;
            $config{sort} = 1;
            print RED(), "-- idle (sleeping) processed filtered --", RESET();
            sleep 1;
        }
        else
        {
            $config{idle} = 1;
            $config{sort} = 0;
            print RED(), "-- idle (sleeping) processed unfiltered --", RESET();
            sleep 1;
        }
    }

## I - InnoDB status

if ($key =~ 'I')
    {
        $config{mode} = 'innodb';
        Clear() unless $config{batchmode};
	print "InnoDB Status\n";
        next;
    }

## o - sort order

if ($key =~ /o/)
    {
        if ($config{sort})
        {
            $config{sort} = 0;
            print RED(), "-- sort order reversed --", RESET();
            sleep 1;
        }
        else
        {
            $config{sort} = 1;
            print RED(), "-- sort order reversed --", RESET();
            sleep 1;
        }
    }

## ? - help

if ($key eq '?')
    {
        Clear();
        PrintHelp();
        ReadKey(0);
        next;
    }

## k - kill

if ($key eq 'k')
    {
        ReadMode($RM_RESET);

print RED(), "Thread id to kill: ", RESET();
        my $id = ReadLine(0);

$id =~ s/\s//g;

if ($id =~ /^\d+$/)
        {
            Execute("KILL $id");
        }
        else
        {
            print RED(), "-- invalid thread id --", RESET();
            sleep 1;
        }

ReadMode($RM_NOBLKRD);
        next;
    }

## K - kill based on a username
    if ($key =~ /K/)
    {
        ReadMode($RM_RESET);

print RED(), "User to kill: ", RESET();
        my $user = ReadLine(0);

$user =~ s/\s//g;

if ($user =~ /^\S+$/)
        {
            for my $pid (keys %ucache)
            {
                next unless $ucache{$pid} eq $user;
                Execute("KILL $pid");
                select(undef, undef, undef, 0.2);
            }
        }
        else
        {
            print RED(), "-- invalid thread id --", RESET();
            sleep 1;
        }

ReadMode($RM_NOBLKRD);
    }

## f - full info

if ($key =~ /f/)
    {
        ReadMode($RM_RESET);
        print RED(), "Full query for which thread id: ", RESET();
        my $id = ReadLine(0);
        chomp $id;
        FullQueryInfo($id);
        ReadMode($RM_NOBLKRD);
        print RED(), "-- paused. press any key to resume or (e) to explain --",
            RESET();
        my $key = ReadKey(0);

if ($key eq 'e')
        {
            Explain($id);
            print RED(), "-- paused. press any key to resume --", RESET();
            ReadKey(0);
        }

next;
    }

## e - explain

if ($key =~ /e/)
    {
        ReadMode($RM_RESET);
        print RED(), "Explain which query (id): ", RESET();
        my $id = ReadLine(0);
        chomp $id;
        Explain($id);
        ReadMode($RM_NOBLKRD);
        print RED(), "-- paused. press any key to resume --", RESET();
        ReadKey(0);
        next;
    }

## r - reset status counters

if ($key =~ /r/)
    {
        Execute("FLUSH STATUS");
        print RED(), "-- counters reset --", RESET();
        sleep 1;
        next;
    }

## H - header toggle

if ($key eq 'H')
    {
        if ($config{header})
        {
            $config{header} = 0;
        }
        else
        {
            $config{header}++;
        }
    }

## # - magic debug key

if ($key eq '#')
    {
        $debug = 1;
    }

if ($key eq 'V')
    {
        GetShowVariables();
        print RED(), "-- paused. press any key to resume --", RESET();
        ReadKey(0);
    }

# Switch to show status mode

if ($key eq 'M')
    {
        $config{mode} = 'status';
    }

## L - full queries toggle

if ($key eq 'L')
    {
        if ($config{fullqueries})
        {
            $config{fullqueries} = 0;
            print RED(), "-- full queries OFF --", RESET();
            sleep 1;
        }
        else
        {
            $config{fullqueries} = 1;
            print RED(), "-- full queries ON --", RESET();
            sleep 1;
        }
    }

}

ReadMode($RM_RESET) unless $config{batchmode};

exit;

#######################################################################

sub Clear()
{
    if (not $WIN)
    {
        print "$CLEAR"
    }
    else
    {
        print "\n" x 90; ## dumb hack for now. Anyone know how to
                         ## clear the screen in dos window on a Win32
                         ## system??
    }
}

my $last_time;

sub GetData()
{
    ## Get terminal info
    my $now_time;
    %qcache = ();  ## recycle memory
    %dbcache = ();

my ($width, $height, $wpx, $hpx, $lines_left);

if (not $config{batchmode})
    {
        ($width, $height, $wpx, $hpx) = GetTerminalSize();
        $lines_left = $height - 2;
    }
    else
    {
        $height = 999_999;     ## I hope you don't have more than that!
        $lines_left = 999_999;
        $width = 80;
    }

##
    ## Header stuff.
    ##
    if ($config{header})
    {
        my @recs = "";
        if ( $db_release > 4 )
	{
            @recs = Hashes("show global status");
	}
	else
	{
           @recs = Hashes("show status");
	}

## if the server died or we lost connectivity
        if (not @recs)
        {
            ReadMode($RM_RESET);
            exit 1;
        }

## get high-res or low-res time
        my ($t_delta);

if ($HAS_TIME)
        {
            $now_time = Time::HiRes::gettimeofday();
        }
        else
        {
            $now_time = time;
        }

if ($last_time and $last_time != $now_time)
        {
          $t_delta = $now_time - $last_time;
        }

%OLD_STATUS = %STATUS;

# Set some status that may not exist in all versions
	$STATUS{Handler_tmp_write}= 0;
	$STATUS{Handler_tmp_update}= 0;
	$STATUS{Rows_tmp_read}= 0;

foreach my $ref (@recs)
        {
            my $key = $ref->{Variable_name};
            my $val = $ref->{Value};

$STATUS{$key} = $val;
        }

## Compute Key Cache Hit Stats

$STATUS{Key_read_requests} ||= 1; ## can't divide by zero next

my $cache_hits_percent = (100-($STATUS{Key_reads}/$STATUS{Key_read_requests}) * 100);
        $cache_hits_percent = sprintf("%2.2f",$cache_hits_percent);

## Query Cache info for <= Ver. 4.1
        ##
        ## mysql> show status like 'qcache%';
        ## +-------------------------+----------+
        ## | Variable_name           | Value    |
        ## +-------------------------+----------+
        ## | Qcache_queries_in_cache | 81       |
        ## | Qcache_inserts          | 4961668  |
        ## | Qcache_hits             | 1374170  |
        ## | Qcache_not_cached       | 5656249  |
        ## | Qcache_free_memory      | 33164800 |
        ## | Qcache_free_blocks      | 2        |
        ## | Qcache_total_blocks     | 168      |
        ## +-------------------------+----------+
	##
        ## Query Cache info for => Ver. 5.0
        ##
        ## mysql> show status like 'qcache%';
        ## +-------------------------+------------+
        ## | Variable_name           | Value      |
        ## +-------------------------+------------+
        ## | Qcache_free_blocks      | 37652      |
        ## | Qcache_free_memory      | 110289712  |
        ## | Qcache_hits             | 1460617356 |
        ## | Qcache_inserts          | 390563495  |
        ## | Qcache_lowmem_prunes    | 6414172    |
        ## | Qcache_not_cached       | 93002420   |
        ## | Qcache_queries_in_cache | 66558      |
        ## | Qcache_total_blocks     | 192031     |
        ## +-------------------------+------------+

my $query_cache_hits             = 0;
        my $query_cache_hits_per_sec     = 0;
        my $now_query_cache_hits_per_sec = 0;

if ($have_query_cache)
        {
            $query_cache_hits = $STATUS{Qcache_hits};
            $query_cache_hits_per_sec = $STATUS{Qcache_hits} / $STATUS{Uptime};

if (defined $last_time and $last_time != $now_time)
            {
                my $q_delta = $STATUS{Qcache_hits} - $OLD_STATUS{Qcache_hits};
                $now_query_cache_hits_per_sec = sprintf "%.2f", $q_delta / $t_delta;
            }
        }

open L, "</proc/loadavg";
	my $l = <L>;
	close L;
	chomp $l;

$last_time = $now_time;

## Server Uptime in meaningful terms...

my $time         = $STATUS{Uptime};
        my ($d,$h,$m,$s) = (0, 0, 0, 0);

$d += int($time / (60*60*24)); $time -= $d * (60*60*24);
        $h += int($time / (60*60));    $time -= $h * (60*60);
        $m += int($time / (60));       $time -= $m * (60);
        $s += int($time);

my $uptime = sprintf("%d+%02d:%02d:%02d", $d, $h, $m, $s);

## Queries per second...

my $avg_queries_per_sec  = sprintf("%.2f", $STATUS{Questions} / $STATUS{Uptime});
        my $num_queries          = $STATUS{Questions};

my @t = localtime(time);

my $current_time = sprintf "[%02d:%02d:%02d]", $t[2], $t[1], $t[0];

my $host_width = 80;
        my $up_width   = $width - $host_width - 1;
        Clear() unless $config{batchmode};
        print RESET();

printf "%-.${host_width}s %${up_width}s\n",
               "$server on $config{host} ($db_version)",
               "up $uptime $current_time";
#              "load $l up $uptime $current_time";
        $lines_left--;

printf " Queries: %-7s  qps: %4.0f Slow: %7s         Se/In/Up/De(%%):    %02.0f/%02.0f/%02.0f/%02.0f\n",
               make_short( $STATUS{Questions} ),  # q total
               $STATUS{Questions} / $STATUS{Uptime},  # qps, average
               make_short( $STATUS{Slow_queries} ),    # slow

# hmm. a Qcache hit is really a select and should be counted.
               100 * ($STATUS{Com_select} + ($STATUS{Qcache_hits}||0) )    / $STATUS{Questions},
               100 * ($STATUS{Com_insert} +  $STATUS{Com_replace} ) / $STATUS{Questions},
               100 * ($STATUS{Com_update} )  / $STATUS{Questions},
               100 * $STATUS{Com_delete} / $STATUS{Questions};

$lines_left--;

if ($t_delta)
        {
          my $q_diff = ( $STATUS{Questions} - $OLD_STATUS{Questions} );
#          print("q_diff: $STATUS{Questions} - $OLD_STATUS{Questions}  / $t_delta = $q_diff\n");

printf(" Sorts: %6.0f qps now: %4.0f Slow qps: %3.1f  Threads: %4.0f (%4.0f/%4.0f) %02.0f/%02.0f/%02.0f/%02.0f\n",
		 ( $STATUS{Sort_rows} - $OLD_STATUS{Sort_rows} ) / $t_delta,
                 ( $STATUS{Questions} - $OLD_STATUS{Questions} ) / $t_delta,
                 ( # slow now (qps)
                  ($STATUS{Slow_queries} ) ?
                  ( $STATUS{Slow_queries} - $OLD_STATUS{Slow_queries} ) / $t_delta :
                  0
                 ),
                 $STATUS{Threads_connected},
                 $STATUS{Threads_running},
                 $STATUS{Threads_cached},

(100 * ($STATUS{Com_select} - $OLD_STATUS{Com_select} +
                         ($STATUS{Qcache_hits}||0) - ($OLD_STATUS{Qcache_hits}||0)
                        ) ) / ($q_diff ),
                 (100 * ($STATUS{Com_insert} - $OLD_STATUS{Com_insert} +
                         $STATUS{Com_replace} - $OLD_STATUS{Com_replace}
                        ) ) / ($q_diff ),
                 (100 * ($STATUS{Com_update} - $OLD_STATUS{Com_update}) ) / ($q_diff ),
                 (100 * ($STATUS{Com_delete} - $OLD_STATUS{Com_delete}) ) / ($q_diff ),
                 );
        }
        else
        {
            print "\n";
        }
        $lines_left--;

if ($have_query_cache and $STATUS{Com_select} and $query_cache_hits)
        {
          printf(" Cache Hits: %-5s Hits/s: %4.1f Hits now: %5.1f  Ratio: ",
                 make_short($STATUS{Qcache_hits}),        # cache hits
                 $STATUS{Qcache_hits} / $STATUS{Uptime}, # hits / sec
                 ($t_delta) ?  ($STATUS{Qcache_hits} - $OLD_STATUS{Qcache_hits}) / $t_delta : 0,  # Hits Now
                 );

my($Ratio) =  100 * ($STATUS{Qcache_hits})  / ($STATUS{Qcache_hits} + $STATUS{Com_select} );
          if ($HAS_COLOR)
          {
                print YELLOW() if ($Ratio < 80.0);
                print RED() if ($Ratio < 50.0);
                print MAGENTA() if ($Ratio < 20.0);
          }
          printf("%4.1f%%$/",$Ratio);
          if ($HAS_COLOR)
          {
                print RESET();
          }

print " Ratio now: ";
          my($Ratio_now) = ($t_delta) ?   # ratio now
                 100 * ($STATUS{Qcache_hits} - $OLD_STATUS{Qcache_hits} ) /
                 ( ($STATUS{Com_select} + $STATUS{Qcache_hits} -
                    ($OLD_STATUS{Qcache_hits} + $OLD_STATUS{Com_select})
                   ) || 1) : 0;
          if ($HAS_COLOR)
          {
                print GREEN() if ($Ratio_now >= 80.0);
                print YELLOW() if ($Ratio_now < 80.0);
                print RED() if ($Ratio_now < 50.0);
                print MAGENTA() if ($Ratio_now < 20.0);
          }
          printf("%4.1f%% \n",$Ratio_now);
          if ($HAS_COLOR)
          {
                print RESET();
          }
	  $lines_left--;
        }

if ($t_delta)
	{
          my $rows_read;
          if (defined($STATUS{Rows_read}))
          {
            $rows_read= $STATUS{Rows_read} - $OLD_STATUS{Rows_read};
          }
          else
          {
            $rows_read=
              ($STATUS{Handler_read_first}+$STATUS{Handler_read_key}+
               $STATUS{Handler_read_next}+$STATUS{Handler_read_prev}+
               $STATUS{Handler_read_rnd}+$STATUS{Handler_read_rnd_next} -
               $OLD_STATUS{Handler_read_first}-$OLD_STATUS{Handler_read_key}-
               $OLD_STATUS{Handler_read_next}-$OLD_STATUS{Handler_read_prev}-
               $OLD_STATUS{Handler_read_rnd}-
               $OLD_STATUS{Handler_read_rnd_next});
          }
	  printf(" Handler: (R/W/U/D) %5d/%5d/%5d/%5d        Tmp: R/W/U: %5d/%5d/%5d\n",
		 $rows_read/$t_delta,
		 ($STATUS{Handler_write} - $OLD_STATUS{Handler_write}) /
		 $t_delta,
		 ($STATUS{Handler_update} - $OLD_STATUS{Handler_update}) /
		 $t_delta,
		 ($STATUS{Handler_delete} - $OLD_STATUS{Handler_delete}) /
		 $t_delta,
		 ($STATUS{Rows_tmp_read} - $OLD_STATUS{Rows_tmp_read}) /
		 $t_delta,
		 ($STATUS{Handler_tmp_write}
		  -$OLD_STATUS{Handler_tmp_write})/$t_delta,
		 ($STATUS{Handler_tmp_update} -
		  $OLD_STATUS{Handler_tmp_update})/$t_delta);
	}
	else
        {
            print "\n";
        }

$lines_left--;

printf(" ISAM Key Efficiency: %2.1f%%  Bps in/out: %5s/%5s   ",
               $cache_hits_percent,
               make_short($STATUS{Bytes_received} / $STATUS{Uptime} ),
               make_short($STATUS{Bytes_sent} / $STATUS{Uptime}));
        printf("Now in/out: %5s/%5s",
               make_short(($STATUS{Bytes_received} - $OLD_STATUS{Bytes_received}) / $t_delta ),
               make_short(($STATUS{Bytes_sent} - $OLD_STATUS{Bytes_sent}) / $t_delta ))
          if ($t_delta);
        print "\n";

$lines_left--;

my($read_only) = Hashes('show global variables like "read_only"');
        if ($read_only->{Value} ne "OFF")
        {
            print RED() if ($HAS_COLOR) ;
            print " ReadOnly";
	    RESET() if ($HAS_COLOR);
        }

my($data) = Hashes('SHOW SLAVE STATUS');
	if (defined($data->{Master_Host}))
        {
	    if (defined($data->{Seconds_Behind_Master}))
	    {
                if ($HAS_COLOR) {
	  	    print GREEN();
		    print YELLOW() if ($data->{Seconds_Behind_Master}  >  60);
		    print MAGENTA() if ($data->{Seconds_Behind_Master} > 360);
	        }
	    }
	    print " Replication ";
	    print "Master:$data->{Master_Host} ";
	    print "IO:$data->{Slave_IO_Running} ";
 	    print "SQL:$data->{Slave_SQL_Running} ";
	    print RESET() if ($HAS_COLOR);

if (defined($data->{Seconds_Behind_Master}))
	    {
        	if ($HAS_COLOR) {
			print GREEN();
			print YELLOW() if ($data->{Seconds_Behind_Master}  >  60);
			print MAGENTA() if ($data->{Seconds_Behind_Master} > 360);
		}
		print "Delay: $data->{Seconds_Behind_Master} sec.";
	    } else {
	        my $free = $width - 45;
		my $Err = substr $data->{Last_Error},0 ,$free;
	        printf(" ERR: %-${free}s", $Err) if ( $Err ne "" );
	    }
	    print WHITE() if ($HAS_COLOR);
	    print "\n";
	    $lines_left--;
	}
	print "\n";
    }

if (not $config{batchmode} and not $config{header})
    {
        Clear();
        print RESET();
    }

##
    ## Threads
    ##

my @sz   = (9, 8, 15, 9, 6, 5, 6, 8);
    my $used = scalar(@sz) + Sum(@sz);
    my $state= $width <= 80 ? 6 : int(min(6+($width-80)/3, 15));
    my $free = $width - $used - ($state - 6);
    my $format= "%9s %8s %15s %9s %6s %5s %6s %${state}s %-.${free}s\n";
    my $format2;
    if ($config{fullqueries})
    {
         $format2 = "%9d %8.8s %15.15s %9.9s %6d %5.1f %6.6s %${state}.${state}s %-${free}s\n";
    } else {
         $format2 = "%9d %8.8s %15.15s %9.9s %6d %5.1f %6.6s %${state}.${state}s %-${free}.${free}s\n";
    }
    print BOLD() if ($HAS_COLOR);

printf $format,
        'Id','User','Host/IP','DB','Time', '%', 'Cmd', 'State', 'Query';

print RESET() if ($HAS_COLOR);

##      Id User Host DB
    printf $format,
        '--','----','-------','--','----', '-', '---', '-----', '----------';

$lines_left -= 2;

my $proc_cmd = "show full processlist";

my @data = Hashes($proc_cmd);

foreach my $thread (@data)
    {
        last if not $lines_left;

## Drop Domain Name, unless it looks like an IP address.  If
        ## it's an IP, we'll strip the port number because it's rarely
        ## interesting.

my $is_ip = 0;

if ($thread->{Host} =~ /^(\d{1,3}\.){3}(\d{1,3})(:\d+)?$/)
        {
            $thread->{Host} =~ s/:.*$//;
            $is_ip = 1;
        }
        else
        {
            $thread->{Host} =~ s/^([^.]+).*/$1/;
        }

## Otherwise, look up the IP (if resolve is set) and strip the
        ## name
        if ($is_ip and $config{resolve})
        {
            $thread->{Host} =~ s/:\d+$//;
#	    my $host = $thread->{Host};
	    my $host = gethostbyaddr(inet_aton($thread->{Host}), AF_INET);
#            $host =~ s/^([^.]+).*/$1/;
	    if ($host)
	    {
		$host =~ s/^([^.]+).*/$1/;
		$thread->{Host} = $host;
	    }
            $thread->{Host} = $host;
        }

## Fix possible undefs

$thread->{db}      ||= '';
        $thread->{Info}    ||= '';
        $thread->{Time}    ||= 0 ;
        $thread->{Id}      ||= 0 ;
        $thread->{User}    ||= '';
        $thread->{Command} ||= '';
        $thread->{Host}    ||= '';
	$thread->{State}   ||= "";
	$thread->{Progress} ||= 0;

## alter double hyphen comments so they don't break
	## the query when newlines are removed - http://freshmeat.net/users/jerjones
	$thread->{Info} =~ s~\s--(.*)$~ /* $1 */ ~mg;

## Normalize spaces -- mostly disabled for now.  This can
        ## break EXPLAIN if you try to explain a mangled query.  It
        ## may be re-enabled later as an option.

if (1)
        {
	    ## collapse newlines and carriage returns and whitespaces
            $thread->{Info} =~ s/[\n\r\s]+/ /g;

# control symbols
	    $thread->{Info} =~ s/[[:cntrl:]]/?/g;
        }

## leading and trailing space removal
        $thread->{Info} =~ s/^\s+//;
        $thread->{Info} =~ s/\s+$//;

## stow it in the cache

$qcache{$thread->{Id}}  = $thread->{Info};
        $dbcache{$thread->{Id}} = $thread->{db};
        $ucache{$thread->{Id}}  = $thread->{User};

}

## Sort by idle time (closest thing to CPU usage I can think of).

my @sorted;

if (not $config{sort})
    {
        @sorted = sort { $a->{Time} <=> $b->{Time} } @data
    }
    else
    {
        @sorted = sort { $b->{Time} <=> $a->{Time} } @data
    }

foreach my $thread (@sorted)
    {
        # Check to see if we can skip out.  We skip out if we know the
        # given line doesn't match.

next if (($thread->{Command} eq "Sleep")
                 and
                 (not $config{idle}));

next if (($thread->{Command} eq "Binlog Dump")
                 and
                 (not $config{idle}));

next if (($thread->{Command} eq "Daemon")
                 and
                 (not $config{idle}));

next if ($thread->{User}  !~ $config{filter_user});
        next if ($thread->{db}    !~ $config{filter_db});
        next if ($thread->{Host}  !~ $config{filter_host});
        next if ($thread->{State} !~ $config{filter_state});

# Otherwise, print.

my $smInfo;

if ($thread->{Info})
        {
            if ($config{fullqueries})
            {
                $smInfo = $thread->{Info};
            } else {
                $smInfo = substr $thread->{Info}, 0, $free;
            }
        }
#        if ($thread->{State})
#        {
#            $smInfo = substr $thread->{State}, 0, $free;
#        }
        else
        {
            $smInfo = "";
        }

if ($HAS_COLOR)
        {
            print YELLOW() if $thread->{Command} eq 'Query';
            print WHITE()  if $thread->{Command} eq 'Sleep';
            print GREEN()  if $thread->{Command} eq 'Connect';
            print BOLD() if $thread->{Time} > $config{slow};
	    print MAGENTA() if $thread->{Time} > $config{long};
        }

printf $format2,
            $thread->{Id}, $thread->{User}, $thread->{Host}, $thread->{db},
            $thread->{Time}, $thread->{Progress}, $thread->{Command}, $thread->{State}, $smInfo;

print RESET() if $HAS_COLOR;

$lines_left--;

last if $lines_left == 0;

}

###########################################################################

my $questions;

sub GetQPS()
{
    my($data) = Hashes('SHOW STATUS LIKE "Questions"');
    my $num   = $data->{Value};

if (not defined $questions) ## first time?
    {
        $questions = $num;
        return;
    }

my $qps = $num - $questions;
    $questions = $num;
    print "$qps\n";
}

###########################################################################

sub GetQcacheSummary()
{
}

###########################################################################

sub GetInnoDBStatus()
{
    if (not $config{pager})
    {
        if (not $config{pager} = my_which('less'))
        {
            $config{pager} = my_which('more');
        }
    }

my @data = Hashes("SHOW ENGINE INNODB STATUS");

open P, "|$config{pager}" or die "$!";
    print keys %{$data[0]};
    print $data[0]->{Status},"\n";
    close P;
}

###########################################################################

my %prev_data;

sub GetCmdSummary()
{
    my ($width, $height, $wpx, $hpx, $lines_left);

if (not $config{batchmode})
    {
        ($width, $height, $wpx, $hpx) = GetTerminalSize();

$lines_left = $height - 2;
    }
    else
    {
        $height = 999_999;     ## I hope you don't have more than that!
        $lines_left = 999_999;
        $width = 80;
    }

# Variable_name and Value pairs come back...
    my @data = Hashes("SHOW STATUS LIKE 'Com_%'");
    my %cmd_data;
    my %cmd_delta;
    my %cmd_pct;
    my %cmd_delta_pct;
    my $total;
    my $delta_total;

for my $item (@data)
    {
        next unless $item->{Value};
        $item->{Variable_name} =~ s/^Com_//;
        $item->{Variable_name} =~ s/_/ /g;
        $cmd_data{$item->{Variable_name}} = $item->{Value};
        $total += $item->{Value};
    }

## Populate other stats

for my $item (keys %cmd_data)
    {
        $cmd_delta{$item} = $cmd_data{$item} -
            ($prev_data{$item} || $cmd_data{$item} - 1);

$delta_total += $cmd_delta{$item};

$cmd_pct{$item}  = int(($cmd_data{$item} / $total) * 100);
    }

for my $item (keys %cmd_data)
    {
        $cmd_delta_pct{$item}  = int(($cmd_delta{$item} / $delta_total) * 100);
    }

## Display

Clear() unless $config{batchmode};
    print RESET();
    printf "%18s %10s %4s  | %5s %4s\n", 'Command', 'Total', 'Pct', 'Last', 'Pct';
    printf "%18s %10s %4s  | %5s %4s\n", '-------', '-----', '---', '----', '---';
    $lines_left -= 2;

for my $item (sort { $cmd_data{$b} <=> $cmd_data{$a} } keys %cmd_data)
    {
        printf "%18s %10d %4s  | %5d %4s\n",
            $item,
            $cmd_data{$item},
            $cmd_pct{$item} . "%",
            $cmd_delta{$item},
            $cmd_delta_pct{$item} . "%";

last if not $lines_left;
        $lines_left -= 1;
    }

%prev_data = %cmd_data;
}

###########################################################################

sub GetShowVariables()
{
    if (not $config{pager})
    {
        if (not $config{pager} = my_which('less'))
        {
            $config{pager} = my_which('more');
        }
    }

my @rows = Hashes("SHOW VARIABLES");

open P, "|$config{pager}" or die "$!";

for my $row (@rows)
    {
        my $name  = $row->{Variable_name};
        my $value = $row->{Value};
        printf P "%32s: %s\n", $name, $value;
    }

close P;
}

###########################################################################

sub GetShowStatus()
{
    Clear() unless $config{batchmode};
    my @rows = Hashes("SHOW STATUS");

printf "%32s  %10s %10s   Toggle idle with 'i'\n", 'Counter', 'Total', 'Change';
    printf "%32s  %10s %10s\n", '-------', '-----', '------';

for my $row (@rows)
    {
        my $name  = $row->{Variable_name};
        my $value = $row->{Value};
        my $old   = $statcache{$name};
        my $delta = 0;

next if $name  =~ m/^Com_/;      ## skip Com_ stats
        next if $value =~ m/^[^0-9]*$/;  ## skip non-numeric

## TODO: if Qcache is off, we should skip Qcache_ values

if ($HAS_COLOR and defined $old and $old =~ /^\d/)
        {
            if ($value > $old)
            {
                print YELLOW();
                $delta = $value - $old;
            }
            elsif ($value < $old)
            {
                print RED();
                $delta = $value - $old;
            }

if (not $config{idle} and $value == $old)
            {
                # filter unchanging stats, maybe
                print RESET();
                next;
            }
        }

printf "%32s: %10s %10s\n", $name, $value, $delta;
        print RESET() if $HAS_COLOR;

$statcache{$name} = $value;
    }

}

###########################################################################

sub FullQueryInfo($)
{
    my $id = shift;

if (not exists $qcache{$id} or not defined $qcache{$id})
    {
        print "*** Invalid id. ***\n";
        return;
    }

my $sql = $qcache{$id};
    print $CLEAR;
    print "Thread $id was executing following query:\n\n";
    print YELLOW(), $sql,"\n\n", RESET();
}

###########################################################################

sub Explain($)
{
    my $id  = shift;

if (not exists $qcache{$id} or not defined $qcache{$id})
    {
        print "*** Invalid id. ***\n";
        return;
    }

my $sql = $qcache{$id};
    my $db  = $dbcache{$id};

Execute("USE $db");
    my @info = Hashes("EXPLAIN $sql");
    print $CLEAR;
    print "EXPLAIN $sql:\n\n";
    PrintTable(@info);
}

###########################################################################

sub PrintTable(@)
{
    my $cnt = 1;
    my @cols = qw(table type possible_keys key key_len ref rows Extra);

for my $row (@_)
    {
        print "*** row $cnt ***\n";
        for my $key (@cols)
        {
            my $val = $row->{$key} || 'NULL';
            printf "%15s:  %s\n", $key, $val;
        }
        $cnt++;
    }
}

###########################################################################

sub StringOrRegex($)
{
    my $input = shift;
    chomp $input;
    if (defined $input)
    {
        # regex, strip /.../ and use via qr//
        if ($input =~ m{^/} and $input =~ m{/$})
        {
            $input =~ s{^/}{} if $config{filter_user};
            $input =~ s{/$}{} if $config{filter_user};
            $input =  qr/$input/;
        }

# reset to match anything
        elsif ($input eq '')
        {
            $input = qr/.*/;
        }

# string, build a simple regex
        else
        {
            $input =  '^' . $input . '$';
            $input = qr/$input/;
        }
    }

# reset to match anything
    else
    {
        $input = qr/.*/;
    }
    return $input;
}

###########################################################################

sub cmd_l
{
    ReadMode($RM_RESET);

print RED(), "Seconds for long queries: ", RESET();
    my $secs = ReadLine(0);

if ($secs =~ /^\s*(\d+)/)
    {
        $config{long} = $1;
        if ($config{long} < 1)
        {
            $config{long} = 1;
        }
    }
    ReadMode($RM_NOBLKRD);
}

sub cmd_s
{
    ReadMode($RM_RESET);

print RED(), "Seconds of Delay: ", RESET();
    my $secs = ReadLine(0);

if ($secs =~ /^\s*(\d+)/)
    {
        $config{delay} = $1;
        if ($config{delay} < 1)
        {
            $config{delay} = 1;
        }
    }
    ReadMode($RM_NOBLKRD);
}

sub cmd_S
{
    ReadMode($RM_RESET);

print RED(), "Seconds for Slow queries: ", RESET();
    my $secs = ReadLine(0);

if ($secs =~ /^\s*(\d+)/)
    {
        $config{slow} = $1;
        if ($config{slow} < 1)
        {
            $config{slow} = 1;
        }
    }
    ReadMode($RM_NOBLKRD);
}

sub cmd_q
{
    ReadMode($RM_RESET);
    print "\n";
    exit;
}

sub trim($)
{
	my $string = shift;
	$string =~ s/^\s+//;
	$string =~ s/\s+$//;
	return $string;
}

###########################################################################

sub PrintHelp()
{
    my $help = qq[
Help for mytop version $main::VERSION by Jeremy D. Zawodny <${YELLOW}Jeremy\@Zawodny.com${RESET}>
 with updates by Mark Grennan <${YELLOW}mark\@grennan.com${RESET}>

? - display this screen
  # - toggle short/long numbers (not yet implemented)
  c - command summary view (based on Com_* counters)
  C - turn color on and off
  d - show only a specific database
  e - explain the query that a thread is running
  E - display current replication error
  f - show full query info for a given thread
  F - unfilter the display
  h - show only a specifc host's connections
  H - toggle the mytop header
  i - toggle the display of idle (sleeping) threads
  I - show innodb status
  k - kill a thread
  p - pause the display
  l - change long running queries hightlighing
  m - switch [mode] to qps (queries/sec) scrolling view
  M - switch [mode] to status
  o - reverse the sort order (toggle)
  q - quit
  r - reset the status counters (via FLUSH STATUS on your server)
  R - change reverse IP lookup
  s - change the delay between screen updates
  S - change slow query hightlighting
  t - switch to thread view (default)
  u - show only a specific user
  V - show variables
  : - enter a command (not yet implemented)
  ! - Skip an error that has stopped replications (at your own risk)
  L - show full queries (do not strip to terminal width)

Base version from ${GREEN}http://www.mysqlfanboy.com/mytop-3/${RESET}
This version comes as part of the ${GREEN}MariaDB${RESET} distribution.
];

print $help;
}

sub Sum(@)
{
    my $sum;
    while (my $val = shift @_) { $sum += $val; }
    return $sum;
}

## A useful routine from perlfaq

sub commify($)
{
    local $_  = shift;
    return 0 unless defined $_;
    1 while s/^([-+]?\d+)(\d{3})/$1,$2/;
    return $_;
}

## Compact numeric representation (10,000 -> 10.0k)

sub make_short($)
{
    my $number = shift;
    return commify($number) if $config{long_nums};
    my $n = 0;
    while ($number > 1_025) { $number /= 1024; $n++; };
    return sprintf "%.1f%s", $number, ('','k','M','G', 'T')[$n];
}

## Run a query and return the records has an array of hashes.

sub Hashes($)
{
    my $sql = shift;
    my @records;

if (my $sth = Execute($sql))
    {
	while (my $ref = $sth->fetchrow_hashref)
        {
            print "record\n" if $debug;
	    push @records, $ref;
	}
    }
    return @records;
}

## Execute an SQL query and return the statement handle.

sub Execute($)
{
    my $sql = shift;

$sql and $sql =~ s/\n/ /sg;

my $sth = $dbh->prepare($sql);

if (not $sth) { ReadMode($RM_RESET); die $DBI::errstr; }

my $ReturnCode = $sth->execute;

if (not $ReturnCode)
    {
        if ($debug)
        {
            print "query failed\n";
            sleep 10;
        }
        return undef;
    }

return $sth;
}

####
#### my_which is used, because we can't assume that every system has the
#### which -command. my_which can take only one argument at a time.
#### Return values: requested system command with the first found path,
#### or undefined, if not found.
####

sub my_which
{
  my ($command) = @_;
  my (@paths, $path);

return $command if (-f $command && -x $command);

# Check first if this is a source distribution, then if this binary
  # distribution and last in the path

push @paths, "./extra";
  push @paths, $path_for_script;
  push @paths, split(':', $ENV{'PATH'});

foreach $path (@paths)
  {
    $path .= "/$command";
    return $path if (-f $path && -x $path);
  }
  return undef();
}

=pod

=head1 SYNOPSIS

B<mytop> [options]

=head1 AVAILABILITY

Base version from B<http://www.mysqlfanboy.com/mytop-3/>.

This version comes as part of the B<MariaDB> distribution. See B<http://mariadb.org/>.

And older (the original) version B<mytop> is available from
http://jeremy.zawodny.com/mysql/mytop/ it B<might> also be on CPAN as
well.

=head1 REQUIREMENTS

In order for B<mytop> to function properly, you must have the
following:

* Perl 5.005 or newer
  * Config::IniFiles;
  * Getopt::Long
  * DBI and DBD::mysql
  * Term::ReadKey from CPAN

Most systems are likely to have all of those installed--except for
Term::ReadKey. You will need to pick that up from the CPAN. You can
pick up Term::ReadKey here:

http://search.cpan.org/search?dist=TermReadKey

And you obviously need access to a MariaDB server with the necessary
security to run the I<SHOW PROCESSLIST> and I<SHOW STATUS> commands.

If you are a Windows user, using ActiveState's Perl, you can use PPM
(the Perl Package Manager) to install the MariaDB/MySQL and Term::ReadKey
modules.

=head2 Optional Color Support

In additon, if you want a color B<mytop> (recommended), install
Term::ANSIColor from the CPAN:

http://search.cpan.org/search?dist=ANSIColor

Once you do, B<mytop> will automatically use it. However, color is not
yet working on Windows. Patches welcome. :-)

=head2 Optional Hi-Res Timing

If you want B<mytop> to provide more accurate real-time
queries-per-second statistics, install the Time::HiRes module from
CPAN.  B<mytop> will automatically notice that you have it and use it
rather than the standard timing mechanism.

=head2 Platforms

B<mytop> is known to work on:

* Linux (2.2.x, 2.4.x)
  * FreeBSD (2.2, 3.x, 4.x)
  * Mac OS X
  * BSDI 4.x
  * Solaris 2.x
  * Windows NT 4.x (ActivePerl)

If you find that it works on another platform, please let me
know. Given that it is all Perl code, I expect it to be rather
portable to Unix and Unix-like systems. Heck, it I<might> even work on
Win32 systems.

=head1 DESCRIPTION

Help is always welcome in improving this software. Feel free to
contact the author (see L<"AUTHOR"> below) with bug reports, fixes,
suggestions, and comments. Additionally L<"BUGS"> will provide a list
of things this software is not able to do yet.

Having said that, here are the details on how it works and what you can
do with it.

=head2 The Basics

B<mytop> was inspired by the system monitoring tool B<top>. I
routinely use B<top> on Linux, FreeBSD, and Solaris. You are likely to
notice features from each of them here.

B<mytop> will connect to a MariaDB server and periodically run the
I<SHOW PROCESSLIST> and I<SHOW STATUS> commands and attempt to
summarize the information from them in a useful format.

=head2 The Display

The B<mytop> display screen is really broken into two parts. The top 4
lines (header) contain summary information about your MariaDB
server. For example, you might see something like:

MariaDB on localhost (10.0.13-log)                     up 1+11:13:00 [23:29:11]
 Queries: 19.3M  qps:  160 Slow:     1.0         Se/In/Up/De(%):    00/80/03/17
             qps now:  219 Slow qps: 0.0  Threads:    1 (   1/  16) 00/74/00/25
 Key Efficiency: 99.3%  Bps in/out: 30.5k/162.8   Now in/out: 32.7k/ 3.3k

The first line identifies the hostname of the server (localhost) and
the version of MariaDB it is running. The right had side shows the
uptime of the MariaDB server process in days+hours:minutes:seconds
format (much like FreeBSD's top) as well as the current time.

The second line displays the total number of queries the server has
processed, the average number of queries per second, the number of
slow queries, and the percentage of Select, Insert, Update, and Delete
queries.

The third real-time values. First is the number of queries per second,
then the number of slow queries, followed by query precentages (like
on the previous line).

And the fourth line displays key buffer efficiency (how often keys are
read from the buffer rather than disk) and the number of bytes that
MariaDB has sent and received, both over all and in the last cycle.

You can toggle the header by hitting B<h> when running B<mytop>.

The second part of the display lists as many threads as can fit on
screen. By default they are sorted according to their idle time (least
idle first). The display looks like:

Id     User       Host      Dbase   Time      Cmd Query or State
    --     ----       ----      -----   ----      --- --------------
    61  jzawodn  localhost      music      0    Query show processlist

As you can see, the thread id, username, host from which the user is
connecting, database to which the user is connected, number of seconds
of idle time, the command the thread is executing, and the query info
are all displayed.

Often times the query info is what you are really interested in, so it
is good to run B<mytop> in an xterm that is wider than the normal 80
columns if possible.

The thread display color-codes the threads if you have installed color
support. The current color scheme only works well in a window with a
dark (like black) background. The colors are selected according to the
C<Command> column of the display:

Query   -  Yellow
    Sleep   -  White
    Connect -  Green
    Slow    -  Bright
    Long    -  Magenta

Those are purely arbitrary and will be customizable in a future
release. If they annoy you just start B<mytop> with the B<--nocolor>
flag or adjust your config file appropriately.

=head2 Arguments

B<mytop> handles long and short command-line arguments. Not all
options have both long and short formats, however. The long arguments
have two dashes `--'. Short arguments only have one '-'.

=over

=item B<-u> or B<--user> username

Username to use when logging in to the MariaDB server. Default: ``B<root>''.

=item B<-p> or B<--pass> or B<--password> I<password>

Password to use when logging in to the MariaDB server. Default: none.

WARNING: This is insecure as the password is visible for anyone.
See B<--prompt> instead!

=item B<-h> or B<--host> I<hostname>[B<:>I<port>]

Hostname of the MariaDB server. The hostname may be followed by an
option port number. Note that the port is specified separate from the
host when using a config file. Default: ``B<localhost>''.

=item B<--port> or B<-P> I<port>

If you're running MariaDB on a non-standard port, use this to specify
the port number. Default: B<3306>.

=item B<-s> or B<--delay> I<seconds>

How long between display refreshes. Default: 5

=item B<-d> or B<--db> or B<--database> I<database>

Use if you'd like B<mytop> to connect to a specific database by
default. Default: none.

=item B<-b> or B<--batch> or B<--batchmode>

In batch mode, mytop runs only once, does not clear the screen, and
places no limit on the number of lines it will print. This is suitable
for running periodically (perhaps from B<cron>) to capture the
information into a file for later viewing. You might use batch mode in
a CGI script to occasionally display your MariaDB server status on the
web.

Default: unset.

=item B<-S> or B<--socket> I</path/to/socket>

If you're running B<mytop> on the same host as MariaDB, you may wish to
have it use the MariaDB socket directly rather than a standard TCP/IP
connection. If you do,just specify one.

Note that specifying a socket will make B<mytop> ignore any host
and/or port that you might have specified. If the socket does not
exist (or the file specified is not a socket), this option will be
ignored and B<mytop> will use the hostname and port number instead.

Default: none.

=item B<--header> or B<--noheader>

Specify if you want the header to display or not. You can toggle this
with the B<h> key while B<mytop> is running.

Default: header.

=item B<--color> or B<--nocolor>

Specify if you want a color display. This has no effect if you don't
have color support available.

Default: If you have color support, B<mytop> will try color unless you
tell it not to.

=item B<-i> or B<--idle> or B<--noi> or B<--noidle>

Specify if you want idle (sleeping) threads to appear in the list. If
sleeping threads are omitted, the default sorting order is reversed so
that the longest running queries appear at the top of the list.

Default: idle.

=item B<--prompt> or B<--noprompt>

Specify if you want to be prompted to type in your database password.
This provides a little bit more security since it not only prevents
the password from viewable in a process list, but also doesn't require
the password to be stored in plain text in your C<~/.mytop> config file.
You will B<only> be prompted if a password has not been specified in
your config file or through another command line option.

Default: noprompt.

=item B<--resolve>

If you have skip-resolve set on MariaDB (to keep it from doing a reverse
DNS lookup on each inbound connection), mytop can replace IP addresses
with hostnames but toggling this option.

Default: noresolve

=item B<--long> or B<--nolong>

For large numbers print all digits (e.g. 10.000) instead of using a more
compact approximation (e.g. 10.0k).

Default: nolong.

=item B<-m> or B<--mode> I<mode>

Specify initial mode B<qps>(queries/second), B<top>(overview),
B<cmd>(command summary), B<innodb>(InnoDB status) or B<status>().

Default: B<top>

=item B<--sort> or B<--nosort>

Reverse sort order from ascending to descending using Idle time.

Default: nosort.

=back

Command-line arguments will always take precedence over config file
options. That happens because the config file is read I<BEFORE> the
command-line arguments are applied.

=head2 Config File

Instead of always using bulky command-line parameters, you can also
use a config files for the default value of your options.

mytop will first read the [client] and [mytop] sections from your
my.cnf files. After that it will read the (C<~/.mytop>) file from your
home directory (if present). These are read I<before> any of your
command-line arguments are processed, so your command-line arguments
will override directives in the config file.

Here is a sample config file C<~/.mytop> which implements the defaults
described above.

user=root
  pass=
  host=localhost
  db=test
  delay=5
  port=3306
  slow=10
  socket=
  batchmode=0
  header=1
  color=1
  idle=1
  long=120

Using a config file will help to ensure that your database password
isn't visible to users on the command-line. Just make sure that the
permissions on C<~/.mytop> are such that others cannot read it (unless
you want them to, of course).

You may have white space on either side of the C<=> in lines of the
config file.

If present, mytop will also read mysql's default config file C<~/.my.cnf>.
Values from both the [client] and [mytop] section are read, in this order.
The long options I<database> and I<password> are preferred over the short
versions I<db> and I<pass> to match mysql's syntax.
These settings take lowest precedence and will be overwritten by either
values in C<~/.mytop> or command-line options.

=head2 Shortcut Keys

The following keys perform various actions while B<mytop> is
running. Those which have not been implemented are listed as
such. They are included to give the user idea of what is coming.

=over

=item B<?>

Display help.

=item B<c>

Show "command counters" based on the Com_* values in SHOW STATUS.
This is a new feature.  Feedback welcome.

=item B<C>

Turn display color on and off. Default is on.

=item B<d>

Show only threads connected to a particular database.

=item B<f>

Given a thread id, display the entire query that thread was (and still
may be) running.

=item B<F>

Disable all filtering (host, user, and db).

=item B<h>

Only show queries from a particular host.

=item B<H>

Toggle the header display. You can also specify either C<header=0> or
C<header=1> in your config file to set the default behavior.

=item B<i>

Toggle the display of idle (sleeping) threads. If sleeping threads are
filtered, the default sorting order is reversed so that the longest
running queries appear at the top of the list.

=item B<I>

Switch to InnoDB Status mode. The output of "SHOW ENGINE INNODB STATUS"
will be displayed every cycle. In a future version, this may actually
summarize that data rather than producing raw output.

=item B<k>

Kill a thread.

=item B<m>

Toggle modes. Currently this switches from `top' mode to `qps'
(Queries Per Second Mode). In this mode, mytop will write out one
integer per second. The number written reflects the number of queries
executed by the server in the previous one second interval.

More modes may be added in the future.

=item B<o>

Reverse the default sort order.

=item B<p>

Pause display.

=item B<q>

Quit B<mytop>

=item B<r>

Reset the server's status counters via a I<FLUSH STATUS> command.

=item B<R>

Togle IP reverse lookup. Default is on.

=item B<s>

Change the sleep time (number of seconds between display refreshes).

=item B<S>

Set the number of seconds a query will need to run before it is
considered old and will be highlighted.

=item B<u>

Show only threads owned by a giver user.

=back

The B<s> key has a command-line counterpart: B<-s>.

The B<h> key has two command-line counterparts: B<--header> and
B<--noheader>.

=head1 BUGS

This is more of a BUGS + WishList.

Some performance information is not available when talking to a
version 3.22.x MySQL server. Additional information (about threads
mostly) was added to the output of I<SHOW STATUS> in MySQL 3.23.x and
B<mytop> makes use of it. If the information is not available, you
will simply see zeros where the real numbers should be.

Simply running this program will increase your overall counters (such
as the number of queries run). But you may or may not view that as a
bug.

B<mytop> consumes too much CPU time when running (verified on older
versions of Linux and FreeBSD). It's likely a problem related to
Term::ReadKey. I haven't had time to investigate yet, so B<mytop> now
automatically lowers its priority when you run it. You may also think
about running B<mytop> on another workstation instead of your database
server. However, C<mytop> on Solaris does B<not> have this problem.
Newer versions of Linux and FreeBSD seem to have fixed this.

You can't specify the maximum number of threads to list. If you have
many threads and a tall xterm, B<mytop> will always try to display as
many as it can fit.

The size of most of the columns in the display has a small maximum
width. If you have fairly long database/user/host names the display
may appear odd. I have no good idea as to how best to deal with that
yet. Suggestions are welcome.

You should be able to specify the columns you'd like to see in the
display and the order in which they appear. If you only have one
username that connects to your database, it's probably not worth
having the User column appear, for example.

=head1 AUTHOR

mytop was developed and is maintained by Jeremy D. Zawodny
(Jeremy@Zawodny.com).

If you wish to e-mail me regarding this software, B<PLEASE> subscribe
to the B<mytop> mailing list.  See the B<mytop> homepage for details.

=head1 DISCLAIMER

While I use this software in my job at Yahoo!, I am solely responsible
for it. Yahoo! does not necessarily support this software in any
way. It is merely a personal idea which happened to be very useful in
my job.

=head1 SEE ALSO

Please check the MySQL manual if you're not sure where some of the
output of B<mytop> is coming from.

=head1 COPYRIGHT

=head1 CREDITS

Fix a bug. Add a feature. See your name here!

Many thanks go to these fine folks:

=over

=Item Jean Weisbuch

Added --fullqueries and reading of .my.cnf

=item Mark Grennan (mark@grennan.com) www.linuxfangoy.com

Added updates for MySQL 5.x. Added 'S' (slow) highlighting.
Added 'C' to turn on and off Color. Added 'l' command to change
color for long running queries. Fixed a few documentation issues.
Monitors Slave status. Added color to Queue hit ratio.
Added number of rows sorted per second.
Created release 1.7.

=item Sami Ahlroos (sami@avis-net.de)

Suggested the idle/noidle stuff.

=item Jan Willamowius (jan@janhh.shnet.org)

Mirnor bug report. Documentation fixes.

=item Alex Osipov (alex@acky.net)

Long command-line options, Unix socket support.

=item Stephane Enten (tuf@grolier.fr)

Suggested batch mode.

=item Richard Ellerbrock (richarde@eskom.co.za)

Bug reports and usability suggestions.

=item William R. Mattil (wrm@newton.irngtx.tel.gte.com)

Bug report about empty passwords not working.

=item Benjamin Pflugmann (philemon@spin.de)

Suggested -P command-line flag as well as other changes.

=item Justin Mecham <justin@aspect.net>

Suggested setting $0 to `mytop'.

=item Thorsten Kunz <thorsten.kunz@de.tiscali.com>

Provided a fix for cases when we try remove the domain name from the
display even if it is actually an IP address.

=item Sasha Pachev <sasha@mysql.com>

Provided the idea of real-time queries per second in the main display.

=item Paul DuBois <paul@snake.net>

Pointed out some option-handling bugs.

=item Mike Wexler <mwexler@tias.com>

Suggested that we don't mangle (normalize) whitespace in query info by
default.

=item Mark Zweifel <markez@yahoo-inc.com>

Make the --idle command-line argument negatable.

=item Axel Schwenke <schwenke@jobpilot.de>

Noticed the inccorect formula for query cache hit percentages in
version 1.2.

=item Steven Roussey <sroussey@network54.com>

Supplied a patch to help filter binary junk in queries so that
terminals don't freak out.

=item jon r. luini <falcon@chime.com>

Supplied a patch that formed the basis for C<--prompt> support.  Sean
Leach <sleach@wiggum.com> submitted a similar patch.

=item Yogish Baliga <baliga@yahoo-inc.com>

Supplied a patch that formed the basis for C<--resolve> support.

=item Per Andreas Buer <perbu@linpro.no>

Supplied an excellent patch to tidy up the top display.  This includes
showing most values in short form, such as 10k rather than 10000.

=item Michael "Monty" Widenius <monty@askmonty.org>

Fixed a couple of minor bugs that gave warnings on startup.
Added support for MariaDB (show MariaDB at top and % done).
Cut long server version names to display width.
Made 'State' length dynamic.

=back

See the Changes file on the B<mytop> distribution page for more
details on what has changed.

=head1 LICENSE

B<mytop> is licensed under the GNU General Public License version
2. For the full license information, please visit
http://www.gnu.org/copyleft/gpl.html

=cut

__END__

${this.title}

Code Editor : mytop