Linux vmi2545633.contaboserver.net 6.1.0-32-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.129-1 (2025-03-06) x86_64
Apache/2.4.62 (Debian)
Server IP : 127.0.0.1 & Your IP : 127.0.0.1
Domains :
Cant Read [ /etc/named.conf ]
User : www-data
Terminal
Auto Root
Create File
Create Folder
Localroot Suggester
Backdoor Destroyer
Readme
/
usr /
bin /
Delete
Unzip
Name
Size
Permission
Date
Action
X11
[ DIR ]
drwxr-xr-x
2025-10-09 10:16
[
66.89
KB
-rwxr-xr-x
2022-09-20 15:27
aa-enabled
18.23
KB
-rwxr-xr-x
2023-02-14 11:49
aa-exec
18.23
KB
-rwxr-xr-x
2023-02-14 11:49
aa-features-abi
18.23
KB
-rwxr-xr-x
2023-02-14 11:49
ab
58.42
KB
-rwxr-xr-x
2024-10-04 15:21
aclocal
35.18
KB
-rwxr-xr-x
2022-03-18 13:09
aclocal-1.16
35.18
KB
-rwxr-xr-x
2022-03-18 13:09
add-apt-repository
14.1
KB
-rwxr-xr-x
2024-05-17 12:23
addpart
30.31
KB
-rwxr-xr-x
2024-11-21 20:01
addr2line
23.14
KB
-rwxr-xr-x
2023-01-14 17:24
appstreamcli
128.12
KB
-rwxr-xr-x
2023-05-28 15:10
apropos
51.29
KB
-rwxr-xr-x
2023-03-12 22:23
apt
18.31
KB
-rwxr-xr-x
2023-05-25 14:11
apt-add-repository
14.1
KB
-rwxr-xr-x
2024-05-17 12:23
apt-cache
86.38
KB
-rwxr-xr-x
2023-05-25 14:11
apt-cdrom
22.38
KB
-rwxr-xr-x
2023-05-25 14:11
apt-config
26.31
KB
-rwxr-xr-x
2023-05-25 14:11
apt-extracttemplates
22.39
KB
-rwxr-xr-x
2023-05-25 14:11
apt-ftparchive
270.39
KB
-rwxr-xr-x
2023-05-25 14:11
apt-get
50.38
KB
-rwxr-xr-x
2023-05-25 14:11
apt-key
27.32
KB
-rwxr-xr-x
2023-05-25 14:11
apt-listchanges
11.96
KB
-rwxr-xr-x
2021-03-28 11:06
apt-mark
58.38
KB
-rwxr-xr-x
2023-05-25 14:11
apt-sortpkgs
38.32
KB
-rwxr-xr-x
2023-05-25 14:11
ar
51.17
KB
-rwxr-xr-x
2023-01-14 17:24
arch
42.86
KB
-rwxr-xr-x
2022-09-20 15:27
aria_chk
5.49
MB
-rwxr-xr-x
2025-02-19 00:56
aria_dump_log
5.29
MB
-rwxr-xr-x
2025-02-19 00:56
aria_ftdump
5.3
MB
-rwxr-xr-x
2025-02-19 00:56
aria_pack
5.33
MB
-rwxr-xr-x
2025-02-19 00:56
aria_read_log
5.44
MB
-rwxr-xr-x
2025-02-19 00:56
as
897.41
KB
-rwxr-xr-x
2023-01-14 17:24
autoconf
14.85
KB
-rwxr-xr-x
2023-01-14 17:42
autoheader
8.82
KB
-rwxr-xr-x
2023-01-14 17:42
autom4te
32.69
KB
-rwxr-xr-x
2023-01-14 17:42
automake
255.91
KB
-rwxr-xr-x
2022-03-18 13:09
automake-1.16
255.91
KB
-rwxr-xr-x
2022-03-18 13:09
autopoint
26.38
KB
-rwxr-xr-x
2023-02-26 15:20
autoreconf
26.3
KB
-rwxr-xr-x
2023-01-14 17:42
autoscan
16.77
KB
-rwxr-xr-x
2023-01-14 17:42
autoupdate
33.22
KB
-rwxr-xr-x
2023-01-14 17:42
awk
696.44
KB
-rwxr-xr-x
2023-02-19 13:30
b2sum
58.98
KB
-rwxr-xr-x
2022-09-20 15:27
base32
46.89
KB
-rwxr-xr-x
2022-09-20 15:27
base64
46.89
KB
-rwxr-xr-x
2022-09-20 15:27
basename
42.83
KB
-rwxr-xr-x
2022-09-20 15:27
basenc
54.89
KB
-rwxr-xr-x
2022-09-20 15:27
bash
1.21
MB
-rwxr-xr-x
2024-03-29 19:40
bashbug
6.7
KB
-rwxr-xr-x
2024-03-29 19:40
bsondump
11.03
MB
-rwxr-xr-x
2025-04-01 15:22
buildhash
46.63
KB
-rwxr-xr-x
2022-03-29 18:19
bunzip2
38.3
KB
-rwxr-xr-x
2022-09-19 02:54
busctl
90.5
KB
-rwxr-xr-x
2025-03-06 14:56
busybox
754.77
KB
-rwxr-xr-x
2023-04-23 21:24
bzcat
38.3
KB
-rwxr-xr-x
2022-09-19 02:54
bzcmp
2.17
KB
-rwxr-xr-x
2022-09-19 02:54
bzdiff
2.17
KB
-rwxr-xr-x
2022-09-19 02:54
bzegrep
3.69
KB
-rwxr-xr-x
2022-09-19 02:54
bzexe
4.78
KB
-rwxr-xr-x
2021-11-27 12:25
bzfgrep
3.69
KB
-rwxr-xr-x
2022-09-19 02:54
bzgrep
3.69
KB
-rwxr-xr-x
2022-09-19 02:54
bzip2
38.3
KB
-rwxr-xr-x
2022-09-19 02:54
bzip2recover
14.23
KB
-rwxr-xr-x
2022-09-19 02:54
bzless
1.27
KB
-rwxr-xr-x
2022-09-19 02:54
bzmore
1.27
KB
-rwxr-xr-x
2022-09-19 02:54
c++
1.25
MB
-rwxr-xr-x
2023-01-08 09:12
c++filt
18.51
KB
-rwxr-xr-x
2023-01-14 17:24
c89
428
B
-rwxr-xr-x
2020-11-17 18:53
c89-gcc
428
B
-rwxr-xr-x
2020-11-17 18:53
c99
454
B
-rwxr-xr-x
2020-11-17 18:53
c99-gcc
454
B
-rwxr-xr-x
2020-11-17 18:53
c_rehash
6.68
KB
-rwxr-xr-x
2024-10-27 14:16
captoinfo
90.34
KB
-rwxr-xr-x
2023-05-07 14:33
cat
42.98
KB
-rwxr-xr-x
2022-09-20 15:27
catman
42.77
KB
-rwxr-xr-x
2023-03-12 22:23
cc
1.24
MB
-rwxr-xr-x
2023-01-08 09:12
certbot
958
B
-rwxr-xr-x
2023-04-16 05:22
cgi-fcgi
18
KB
-rwxr-xr-x
2021-01-11 05:57
chage
78.49
KB
-rwxr-sr-x
2023-03-23 12:40
chardet
221
B
-rwxr-xr-x
2022-12-26 14:42
chardetect
221
B
-rwxr-xr-x
2022-12-26 14:42
chattr
14.24
KB
-rwxr-xr-x
2023-03-05 03:16
chcon
67.11
KB
-rwxr-xr-x
2022-09-20 15:27
checkgid
14.23
KB
-rwxr-xr-x
2024-10-04 15:21
chfn
61.2
KB
-rwsr-xr-x
2023-03-23 12:40
chgrp
67.05
KB
-rwxr-xr-x
2022-09-20 15:27
chmod
62.98
KB
-rwxr-xr-x
2022-09-20 15:27
choom
54.31
KB
-rwxr-xr-x
2024-11-21 20:01
chown
71.05
KB
-rwxr-xr-x
2022-09-20 15:27
chrt
66.31
KB
-rwxr-xr-x
2024-11-21 20:01
chsh
51.64
KB
-rwsr-xr-x
2023-03-23 12:40
chvt
14.57
KB
-rwxr-xr-x
2023-03-23 09:34
ckbcomp
147.14
KB
-rwxr-xr-x
2023-05-21 21:30
cksum
139.05
KB
-rwxr-xr-x
2022-09-20 15:27
clear
14.24
KB
-rwxr-xr-x
2023-05-07 14:33
clear_console
14.15
KB
-rwxr-xr-x
2024-03-29 19:40
cmp
50.95
KB
-rwxr-xr-x
2023-02-03 19:00
codepage
14.41
KB
-rwxr-xr-x
2023-03-23 09:34
col
34.31
KB
-rwxr-xr-x
2024-11-21 20:01
colcrt
14.31
KB
-rwxr-xr-x
2024-11-21 20:01
colrm
30.31
KB
-rwxr-xr-x
2024-11-21 20:01
column
54.31
KB
-rwxr-xr-x
2024-11-21 20:01
comm
46.92
KB
-rwxr-xr-x
2022-09-20 15:27
compose
18.06
KB
-rwxr-xr-x
2021-11-29 13:07
corelist
15.01
KB
-rwxr-xr-x
2023-11-25 20:59
corepack
132
B
-rwxr-xr-x
2024-02-26 06:00
cp
147.61
KB
-rwxr-xr-x
2022-09-20 15:27
cpan
8.16
KB
-rwxr-xr-x
2023-11-25 20:59
cpan5.36-x86_64-linux-gnu
8.18
KB
-rwxr-xr-x
2023-11-25 20:59
cpio
158.56
KB
-rwxr-xr-x
2022-09-14 19:45
cpio-filter
1.22
KB
-rwxr-xr-x
2022-11-19 21:25
cpp
1.24
MB
-rwxr-xr-x
2023-01-08 09:12
cpp-12
1.24
MB
-rwxr-xr-x
2023-01-08 09:12
crc32
1.04
KB
-rwxr-xr-x
2020-03-14 12:52
crontab
42.63
KB
-rwxr-sr-x
2023-03-02 07:33
csplit
119.17
KB
-rwxr-xr-x
2022-09-20 15:27
ctstat
26.59
KB
-rwxr-xr-x
2023-05-22 13:19
curl
274.22
KB
-rwxr-xr-x
2025-03-09 10:45
cut
46.98
KB
-rwxr-xr-x
2022-09-20 15:27
cvtsudoers
337.19
KB
-rwxr-xr-x
2023-06-27 11:45
dash
122.7
KB
-rwxr-xr-x
2023-01-05 13:20
date
119.05
KB
-rwxr-xr-x
2022-09-20 15:27
dbilogstrip
1.35
KB
-rwxr-xr-x
2022-11-19 21:14
dbiprof
6.06
KB
-rwxr-xr-x
2022-11-19 21:14
dbiproxy
5.27
KB
-rwxr-xr-x
2022-11-19 21:14
dbus-cleanup-sockets
14.22
KB
-rwxr-xr-x
2023-09-16 10:03
dbus-daemon
238.56
KB
-rwxr-xr-x
2023-09-16 10:03
dbus-monitor
26.23
KB
-rwxr-xr-x
2023-09-16 10:03
dbus-run-session
14.23
KB
-rwxr-xr-x
2023-09-16 10:03
dbus-send
30.22
KB
-rwxr-xr-x
2023-09-16 10:03
dbus-update-activation-environment
14.22
KB
-rwxr-xr-x
2023-09-16 10:03
dbus-uuidgen
14.22
KB
-rwxr-xr-x
2023-09-16 10:03
dd
87.15
KB
-rwxr-xr-x
2022-09-20 15:27
deallocvt
14.53
KB
-rwxr-xr-x
2023-03-23 09:34
deb-systemd-helper
23.79
KB
-rwxr-xr-x
2022-07-09 00:05
deb-systemd-invoke
6.09
KB
-rwxr-xr-x
2022-07-02 15:23
debconf
2.79
KB
-rwxr-xr-x
2023-01-08 21:50
debconf-apt-progress
11.27
KB
-rwxr-xr-x
2023-01-08 21:50
debconf-communicate
608
B
-rwxr-xr-x
2023-01-08 21:50
debconf-copydb
1.68
KB
-rwxr-xr-x
2023-01-08 21:50
debconf-escape
647
B
-rwxr-xr-x
2023-01-08 21:50
debconf-gettextize
15.97
KB
-rwxr-xr-x
2020-12-30 01:09
debconf-set-selections
2.92
KB
-rwxr-xr-x
2023-01-08 21:50
debconf-show
1.78
KB
-rwxr-xr-x
2023-01-08 21:50
debconf-updatepo
4.46
KB
-rwxr-xr-x
2020-12-30 01:09
debianbts
217
B
-rwxr-xr-x
2022-12-08 11:34
defmt-c
14.23
KB
-rwxr-xr-x
2022-03-29 18:19
defmt-sh
14.23
KB
-rwxr-xr-x
2022-03-29 18:19
delpart
30.31
KB
-rwxr-xr-x
2024-11-21 20:01
delv
41.3
KB
-rwxr-xr-x
2025-01-25 10:14
df
99.8
KB
-rwxr-xr-x
2022-09-20 15:27
dh
28.85
KB
-rwxr-xr-x
2023-01-02 14:54
dh_assistant
20.34
KB
-rwxr-xr-x
2023-01-02 14:54
dh_auto_build
1.37
KB
-rwxr-xr-x
2023-01-02 14:54
dh_auto_clean
1.51
KB
-rwxr-xr-x
2023-01-02 14:54
dh_auto_configure
1.63
KB
-rwxr-xr-x
2023-01-02 14:54
dh_auto_install
3.22
KB
-rwxr-xr-x
2023-01-02 14:54
dh_auto_test
1.65
KB
-rwxr-xr-x
2023-01-02 14:54
dh_autoreconf
6.46
KB
-rwxr-xr-x
2021-02-04 11:26
dh_autoreconf_clean
2.1
KB
-rwxr-xr-x
2021-02-04 11:26
dh_autotools-dev_restoreconfig
1.79
KB
-rwxr-xr-x
2022-01-31 14:43
dh_autotools-dev_updateconfig
1.81
KB
-rwxr-xr-x
2022-01-31 14:43
dh_bash-completion
4.31
KB
-rwxr-xr-x
2021-08-28 15:26
dh_bugfiles
3.58
KB
-rwxr-xr-x
2023-01-02 14:54
dh_builddeb
4.79
KB
-rwxr-xr-x
2023-01-02 14:54
dh_clean
5.03
KB
-rwxr-xr-x
2023-01-02 14:54
dh_compress
7.67
KB
-rwxr-xr-x
2023-01-02 14:54
dh_dwz
4.99
KB
-rwxr-xr-x
2023-01-02 14:54
dh_fixperms
5.29
KB
-rwxr-xr-x
2023-01-02 14:54
dh_gencontrol
5.88
KB
-rwxr-xr-x
2023-01-02 14:54
dh_icons
2.04
KB
-rwxr-xr-x
2023-01-02 14:54
dh_install
12.16
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installalternatives
6.61
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installcatalogs
3.33
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installchangelogs
11.57
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installcron
1.65
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installdeb
12.71
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installdebconf
6.69
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installdirs
3.09
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installdocs
14.65
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installemacsen
3.74
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installexamples
5.65
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installgsettings
2.24
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installifupdown
1.47
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installinfo
3.38
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installinit
13.96
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installinitramfs
2.5
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installlogcheck
1.94
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installlogrotate
1.14
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installman
13.37
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installmanpages
4.89
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installmenu
2.15
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installmime
1.3
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installmodules
2.66
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installpam
1.42
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installppp
1.38
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installsystemd
14.06
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installsystemduser
8.36
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installsysusers
2.98
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installtmpfiles
3.24
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installudev
2.1
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installwm
3.3
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installxfonts
2.8
KB
-rwxr-xr-x
2023-01-02 14:54
dh_installxmlcatalogs
9.22
KB
-rwxr-xr-x
2019-02-27 00:18
dh_link
4.32
KB
-rwxr-xr-x
2023-01-02 14:54
dh_lintian
1.29
KB
-rwxr-xr-x
2023-01-02 14:54
dh_listpackages
825
B
-rwxr-xr-x
2023-01-02 14:54
dh_makeshlibs
15.12
KB
-rwxr-xr-x
2023-01-02 14:54
dh_md5sums
3.46
KB
-rwxr-xr-x
2023-01-02 14:54
dh_missing
8.75
KB
-rwxr-xr-x
2023-01-02 14:54
dh_movefiles
4.69
KB
-rwxr-xr-x
2023-01-02 14:54
dh_perl
5.03
KB
-rwxr-xr-x
2023-01-02 14:54
dh_perl_dbi
1.17
KB
-rwxr-xr-x
2022-11-19 21:14
dh_phpcomposer
3.01
KB
-rwxr-xr-x
2023-01-28 15:13
dh_phppear
5.63
KB
-rwxr-xr-x
2023-01-28 15:13
dh_prep
1.87
KB
-rwxr-xr-x
2023-01-02 14:54
dh_shlibdeps
6.24
KB
-rwxr-xr-x
2023-01-02 14:54
dh_strip
14.85
KB
-rwxr-xr-x
2023-01-02 14:54
dh_strip_nondeterminism
3.12
KB
-rwxr-xr-x
2023-01-15 19:53
dh_systemd_enable
8.98
KB
-rwxr-xr-x
2023-01-02 14:54
dh_systemd_start
8.57
KB
-rwxr-xr-x
2023-01-02 14:54
dh_testdir
1.31
KB
-rwxr-xr-x
2023-01-02 14:54
dh_testroot
2.91
KB
-rwxr-xr-x
2023-01-02 14:54
dh_ucf
2.38
KB
-rwxr-xr-x
2023-01-02 14:54
dh_update_autotools_config
1.84
KB
-rwxr-xr-x
2023-01-02 14:54
dh_usrlocal
4.2
KB
-rwxr-xr-x
2023-01-02 14:54
diff
151.58
KB
-rwxr-xr-x
2023-02-03 19:00
diff3
67.14
KB
-rwxr-xr-x
2023-02-03 19:00
dig
138.77
KB
-rwxr-xr-x
2025-01-25 10:14
dir
147.8
KB
-rwxr-xr-x
2022-09-20 15:27
dircolors
50.92
KB
-rwxr-xr-x
2022-09-20 15:27
dirmngr
586.13
KB
-rwxr-xr-x
2023-03-26 13:03
dirmngr-client
106.87
KB
-rwxr-xr-x
2023-03-26 13:03
dirname
38.83
KB
-rwxr-xr-x
2022-09-20 15:27
discover-config
2.87
KB
-rwxr-xr-x
2022-01-09 07:48
dmesg
86.58
KB
-rwxr-xr-x
2024-11-21 20:01
dnsdomainname
22.15
KB
-rwxr-xr-x
2022-12-19 13:33
dnstap-read
18.33
KB
-rwxr-xr-x
2025-01-25 10:14
domainname
22.15
KB
-rwxr-xr-x
2022-12-19 13:33
dotlockfile
22.5
KB
-rwxr-sr-x
2021-02-04 15:18
dpkg
310.64
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-architecture
14.85
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-buildflags
8.14
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-buildpackage
32.63
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-checkbuilddeps
7.45
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-deb
166.52
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-distaddfile
2.72
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-divert
154.55
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-genbuildinfo
18.48
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-genchanges
17.39
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-gencontrol
14.2
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-gensymbols
10.65
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-maintscript-helper
20.71
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-mergechangelogs
8.88
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-name
6.62
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-parsechangelog
4.83
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-query
158.58
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-realpath
4.09
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-scanpackages
8.47
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-scansources
8.98
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-shlibdeps
31.17
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-source
22.91
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-split
126.48
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-statoverride
62.33
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-trigger
86.48
KB
-rwxr-xr-x
2023-05-11 02:04
dpkg-vendor
3.18
KB
-rwxr-xr-x
2023-05-11 02:04
du
171.33
KB
-rwxr-xr-x
2022-09-20 15:27
dumpkeys
175.13
KB
-rwxr-xr-x
2023-03-23 09:34
dwp
1.79
MB
-rwxr-xr-x
2023-01-14 17:24
dwz
237.66
KB
-rwxr-xr-x
2022-12-26 10:45
echo
42.83
KB
-rwxr-xr-x
2022-09-20 15:27
edit
18.06
KB
-rwxr-xr-x
2021-11-29 13:07
editor
280.74
KB
-rwxr-xr-x
2024-05-06 06:10
egrep
41
B
-rwxr-xr-x
2023-01-24 14:43
eject
82.16
KB
-rwxr-xr-x
2024-11-21 20:01
elfedit
35.03
KB
-rwxr-xr-x
2023-01-14 17:24
enc2xs
40.96
KB
-rwxr-xr-x
2023-11-25 20:59
encguess
3
KB
-rwxr-xr-x
2023-11-25 20:59
env
47.4
KB
-rwxr-xr-x
2022-09-20 15:27
envsubst
34.31
KB
-rwxr-xr-x
2023-02-26 15:20
eqn
205.42
KB
-rwxr-xr-x
2023-03-07 09:38
ex
1.55
MB
-rwxr-xr-x
2025-02-16 05:23
expand
42.92
KB
-rwxr-xr-x
2022-09-20 15:27
expiry
30.45
KB
-rwxr-sr-x
2023-03-23 12:40
expr
115.05
KB
-rwxr-xr-x
2022-09-20 15:27
factor
83.2
KB
-rwxr-xr-x
2022-09-20 15:27
faillog
22.53
KB
-rwxr-xr-x
2023-03-23 12:40
faked-sysv
34.76
KB
-rwxr-xr-x
2023-03-18 09:22
faked-tcp
34.78
KB
-rwxr-xr-x
2023-03-18 09:22
fakeroot
3.9
KB
-rwxr-xr-x
2023-03-18 09:22
fakeroot-sysv
3.9
KB
-rwxr-xr-x
2023-03-18 09:22
fakeroot-tcp
3.9
KB
-rwxr-xr-x
2023-03-18 09:22
fallocate
34.31
KB
-rwxr-xr-x
2024-11-21 20:01
false
34.83
KB
-rwxr-xr-x
2022-09-20 15:27
fc-cache
18.59
KB
-rwxr-xr-x
2023-01-31 22:24
fc-cat
18.52
KB
-rwxr-xr-x
2023-01-31 22:24
fc-conflist
14.34
KB
-rwxr-xr-x
2023-01-31 22:24
fc-list
14.4
KB
-rwxr-xr-x
2023-01-31 22:24
fc-match
14.47
KB
-rwxr-xr-x
2023-01-31 22:24
fc-pattern
14.39
KB
-rwxr-xr-x
2023-01-31 22:24
fc-query
14.36
KB
-rwxr-xr-x
2023-01-31 22:24
fc-scan
14.42
KB
-rwxr-xr-x
2023-01-31 22:24
fc-validate
14.41
KB
-rwxr-xr-x
2023-01-31 22:24
fcgistarter
14.23
KB
-rwxr-xr-x
2024-10-04 15:21
fgconsole
14.52
KB
-rwxr-xr-x
2023-03-23 09:34
fgrep
41
B
-rwxr-xr-x
2023-01-24 14:43
filan
96.02
KB
-rwxr-xr-x
2022-11-06 08:15
file
26.48
KB
-rwxr-xr-x
2023-01-28 18:17
fincore
34.36
KB
-rwxr-xr-x
2024-11-21 20:01
find
219.58
KB
-rwxr-xr-x
2023-01-08 18:07
findaffix
11.74
KB
-rwxr-xr-x
2022-03-29 18:19
findmnt
83.59
KB
-rwxr-xr-x
2024-11-21 20:01
flock
34.39
KB
-rwxr-xr-x
2024-11-21 20:01
fmt
46.89
KB
-rwxr-xr-x
2022-09-20 15:27
fold
42.89
KB
-rwxr-xr-x
2022-09-20 15:27
free
26.3
KB
-rwxr-xr-x
2022-12-19 06:06
funzip
22.46
KB
-rwxr-xr-x
2023-02-19 18:02
fuser
39.83
KB
-rwxr-xr-x
2022-12-13 05:27
g++
1.25
MB
-rwxr-xr-x
2023-01-08 09:12
g++-12
1.25
MB
-rwxr-xr-x
2023-01-08 09:12
galera_new_cluster
917
B
-rwxr-xr-x
2025-02-19 00:56
galera_recovery
3.29
KB
-rwxr-xr-x
2025-02-19 00:56
gapplication
22.31
KB
-rwxr-xr-x
2024-11-14 09:42
gawk
696.44
KB
-rwxr-xr-x
2023-02-19 13:30
gawkbug
6.54
KB
-rwxr-xr-x
2023-02-19 13:30
gcc
1.24
MB
-rwxr-xr-x
2023-01-08 09:12
gcc-12
1.24
MB
-rwxr-xr-x
2023-01-08 09:12
gcc-ar
34.54
KB
-rwxr-xr-x
2023-01-08 09:12
gcc-ar-12
34.54
KB
-rwxr-xr-x
2023-01-08 09:12
gcc-nm
34.54
KB
-rwxr-xr-x
2023-01-08 09:12
gcc-nm-12
34.54
KB
-rwxr-xr-x
2023-01-08 09:12
gcc-ranlib
34.54
KB
-rwxr-xr-x
2023-01-08 09:12
gcc-ranlib-12
34.54
KB
-rwxr-xr-x
2023-01-08 09:12
gcov
720.16
KB
-rwxr-xr-x
2023-01-08 09:12
gcov-12
720.16
KB
-rwxr-xr-x
2023-01-08 09:12
gcov-dump
568.02
KB
-rwxr-xr-x
2023-01-08 09:12
gcov-dump-12
568.02
KB
-rwxr-xr-x
2023-01-08 09:12
gcov-tool
588.09
KB
-rwxr-xr-x
2023-01-08 09:12
gcov-tool-12
588.09
KB
-rwxr-xr-x
2023-01-08 09:12
gdbus
50.31
KB
-rwxr-xr-x
2024-11-14 09:42
gencat
26.75
KB
-rwxr-xr-x
2025-03-06 22:46
geqn
205.42
KB
-rwxr-xr-x
2023-03-07 09:38
getconf
26.5
KB
-rwxr-xr-x
2025-03-06 22:46
getent
35.47
KB
-rwxr-xr-x
2025-03-06 22:46
getkeycodes
14.53
KB
-rwxr-xr-x
2023-03-23 09:34
getopt
34.31
KB
-rwxr-xr-x
2024-11-21 20:01
gettext
34.31
KB
-rwxr-xr-x
2023-02-26 15:20
gettext.sh
5.07
KB
-rwxr-xr-x
2023-02-26 15:20
gettextize
41.28
KB
-rwxr-xr-x
2023-02-26 15:20
gio
90.33
KB
-rwxr-xr-x
2024-11-14 09:42
gio-querymodules
14.23
KB
-rwxr-xr-x
2024-11-14 09:42
glib-compile-schemas
62.3
KB
-rwxr-xr-x
2024-11-14 09:42
gmake
234.65
KB
-rwxr-xr-x
2021-04-10 13:55
gold
2.99
MB
-rwxr-xr-x
2023-01-14 17:24
gp-archive
159.06
KB
-rwxr-xr-x
2023-01-14 17:24
gp-collect-app
175.27
KB
-rwxr-xr-x
2023-01-14 17:24
gp-display-html
578.29
KB
-rwxr-xr-x
2023-01-14 17:24
gp-display-src
150.81
KB
-rwxr-xr-x
2023-01-14 17:24
gp-display-text
257.3
KB
-rwxr-xr-x
2023-01-14 17:24
gpasswd
86.42
KB
-rwsr-xr-x
2023-03-23 12:40
gpg
1.06
MB
-rwxr-xr-x
2023-03-26 13:03
gpg-agent
425.22
KB
-rwxr-xr-x
2023-03-26 13:03
gpg-connect-agent
154.96
KB
-rwxr-xr-x
2023-03-26 13:03
gpg-wks-server
203
KB
-rwxr-xr-x
2023-03-26 13:03
gpg-zip
3.43
KB
-rwxr-xr-x
2023-03-26 13:03
gpgcompose
910.27
KB
-rwxr-xr-x
2023-03-26 13:03
gpgconf
174.73
KB
-rwxr-xr-x
2023-03-26 13:03
gpgparsemail
34.3
KB
-rwxr-xr-x
2023-03-26 13:03
gpgsm
527.66
KB
-rwxr-xr-x
2023-03-26 13:03
gpgsplit
74.56
KB
-rwxr-xr-x
2023-03-26 13:03
gpgtar
147.52
KB
-rwxr-xr-x
2023-03-26 13:03
gpgv
463
KB
-rwxr-xr-x
2023-03-26 13:03
gpic
220.27
KB
-rwxr-xr-x
2023-03-07 09:38
gprof
108.35
KB
-rwxr-xr-x
2023-01-14 17:24
gprofng
146.59
KB
-rwxr-xr-x
2023-01-14 17:24
grep
198.39
KB
-rwxr-xr-x
2023-01-24 14:43
gresource
22.23
KB
-rwxr-xr-x
2024-11-14 09:42
groff
125.45
KB
-rwxr-xr-x
2023-03-07 09:38
grog
2.71
KB
-rwxr-xr-x
2023-03-07 09:38
grops
185.86
KB
-rwxr-xr-x
2023-03-07 09:38
grotty
137.48
KB
-rwxr-xr-x
2023-03-07 09:38
groups
42.89
KB
-rwxr-xr-x
2022-09-20 15:27
grub-editenv
374.16
KB
-rwxr-xr-x
2023-10-02 14:11
grub-file
809.41
KB
-rwxr-xr-x
2023-10-02 14:11
grub-fstest
931.13
KB
-rwxr-xr-x
2023-10-02 14:11
grub-glue-efi
245.01
KB
-rwxr-xr-x
2023-10-02 14:11
grub-kbdcomp
1.64
KB
-rwxr-xr-x
2023-10-02 14:11
grub-menulst2cfg
229.05
KB
-rwxr-xr-x
2023-10-02 14:11
grub-mkfont
273.66
KB
-rwxr-xr-x
2023-10-02 14:11
grub-mkimage
354.2
KB
-rwxr-xr-x
2023-10-02 14:11
grub-mklayout
249.29
KB
-rwxr-xr-x
2023-10-02 14:11
grub-mknetdir
410.99
KB
-rwxr-xr-x
2023-10-02 14:11
grub-mkpasswd-pbkdf2
257.35
KB
-rwxr-xr-x
2023-10-02 14:11
grub-mkrelpath
244.7
KB
-rwxr-xr-x
2023-10-02 14:11
grub-mkrescue
987.84
KB
-rwxr-xr-x
2023-10-02 14:11
grub-mkstandalone
487.32
KB
-rwxr-xr-x
2023-10-02 14:11
grub-mount
754.05
KB
-rwxr-xr-x
2023-10-02 14:11
grub-ntldr-img
34.58
KB
-rwxr-xr-x
2023-10-02 14:11
grub-render-label
822.01
KB
-rwxr-xr-x
2023-10-02 14:11
grub-script-check
272.82
KB
-rwxr-xr-x
2023-10-02 14:11
grub-syslinux2cfg
770.52
KB
-rwxr-xr-x
2023-10-02 14:11
gsettings
26.31
KB
-rwxr-xr-x
2024-11-14 09:42
gtbl
146.43
KB
-rwxr-xr-x
2023-03-07 09:38
gunzip
2.29
KB
-rwxr-xr-x
2022-04-10 02:22
gzexe
6.3
KB
-rwxr-xr-x
2022-04-10 02:22
gzip
95.84
KB
-rwxr-xr-x
2022-04-10 02:22
h2ph
28.54
KB
-rwxr-xr-x
2023-11-25 20:59
h2xs
59.51
KB
-rwxr-xr-x
2023-11-25 20:59
hardlink
50.39
KB
-rwxr-xr-x
2024-11-21 20:01
hd
58.32
KB
-rwxr-xr-x
2024-11-21 20:01
head
46.95
KB
-rwxr-xr-x
2022-09-20 15:27
helpztags
2.46
KB
-rwxr-xr-x
2025-02-16 05:23
hexdump
58.32
KB
-rwxr-xr-x
2024-11-21 20:01
host
114.7
KB
-rwxr-xr-x
2025-01-25 10:14
hostid
38.83
KB
-rwxr-xr-x
2022-09-20 15:27
hostname
22.15
KB
-rwxr-xr-x
2022-12-19 13:33
hostnamectl
30.38
KB
-rwxr-xr-x
2025-03-06 14:56
htcacheclean
34.24
KB
-rwxr-xr-x
2024-10-04 15:21
htdbm
26.23
KB
-rwxr-xr-x
2024-10-04 15:21
htdigest
14.23
KB
-rwxr-xr-x
2024-10-04 15:21
htpasswd
26.23
KB
-rwxr-xr-x
2024-10-04 15:21
i386
26.58
KB
-rwxr-xr-x
2024-11-21 20:01
icombine
38.63
KB
-rwxr-xr-x
2022-03-29 18:19
iconv
63.13
KB
-rwxr-xr-x
2025-03-06 22:46
id
47.02
KB
-rwxr-xr-x
2022-09-20 15:27
ifnames
4.08
KB
-rwxr-xr-x
2023-01-14 17:42
ijoin
18.26
KB
-rwxr-xr-x
2022-03-29 18:19
inetutils-telnet
186.2
KB
-rwxr-xr-x
2023-08-23 10:01
infocmp
62.31
KB
-rwxr-xr-x
2023-05-07 14:33
infotocap
90.34
KB
-rwxr-xr-x
2023-05-07 14:33
innochecksum
4.56
MB
-rwxr-xr-x
2025-02-19 00:56
innotop
445.44
KB
-rwxr-xr-x
2025-02-19 00:56
install
155.8
KB
-rwxr-xr-x
2022-09-20 15:27
install_compass
14.85
KB
-rwxr-xr-x
2013-12-19 05:41
instmodsh
4.27
KB
-rwxr-xr-x
2023-11-25 20:59
ionice
34.31
KB
-rwxr-xr-x
2024-11-21 20:01
ip
674.82
KB
-rwxr-xr-x
2023-05-22 13:19
ipcmk
34.38
KB
-rwxr-xr-x
2024-11-21 20:01
ipcrm
34.31
KB
-rwxr-xr-x
2024-11-21 20:01
ipcs
74.31
KB
-rwxr-xr-x
2024-11-21 20:01
iptables-xml
88.98
KB
-rwxr-xr-x
2023-01-16 13:44
ischroot
14.32
KB
-rwxr-xr-x
2023-07-28 23:46
ispell
102.73
KB
-rwxr-xr-x
2022-03-29 18:19
ispell-wrapper
7.05
KB
-rwxr-xr-x
2023-03-14 21:17
join
54.98
KB
-rwxr-xr-x
2022-09-20 15:27
journalctl
74.64
KB
-rwxr-xr-x
2025-03-06 14:56
json_pp
4.88
KB
-rwxr-xr-x
2023-11-25 20:59
kbd_mode
14.82
KB
-rwxr-xr-x
2023-03-23 09:34
kbdinfo
14.53
KB
-rwxr-xr-x
2023-03-23 09:34
kbxutil
162.77
KB
-rwxr-xr-x
2023-03-26 13:03
kernel-install
12.75
KB
-rwxr-xr-x
2025-03-06 14:56
kill
22.3
KB
-rwxr-xr-x
2022-12-19 06:06
killall
31.95
KB
-rwxr-xr-x
2022-12-13 05:27
kmod
174.27
KB
-rwxr-xr-x
2022-12-10 00:02
laptop-detect
3.73
KB
-rwxr-xr-x
2017-08-12 15:24
last
50.31
KB
-rwxr-xr-x
2024-11-21 20:01
lastb
50.31
KB
-rwxr-xr-x
2024-11-21 20:01
lastlog
31.75
KB
-rwxr-xr-x
2023-03-23 12:40
lcf
7.6
KB
-rwxr-xr-x
2024-12-20 07:39
ld
1.27
MB
-rwxr-xr-x
2023-01-14 17:24
ld.bfd
1.27
MB
-rwxr-xr-x
2023-01-14 17:24
ld.gold
2.99
MB
-rwxr-xr-x
2023-01-14 17:24
ld.so
209.96
KB
-rwxr-xr-x
2025-03-06 22:46
ldd
5.28
KB
-rwxr-xr-x
2025-03-06 22:46
less
194.3
KB
-rwxr-xr-x
2024-05-02 18:30
lessecho
14.24
KB
-rwxr-xr-x
2024-05-02 18:30
lessfile
8.83
KB
-rwxr-xr-x
2024-05-02 18:30
lesskey
23.63
KB
-rwxr-xr-x
2024-05-02 18:30
lesspipe
8.83
KB
-rwxr-xr-x
2024-05-02 18:30
letsencrypt
958
B
-rwxr-xr-x
2023-04-16 05:22
lexgrog
107.48
KB
-rwxr-xr-x
2023-03-12 22:23
lft
2.43
KB
-rwxr-xr-x
2023-02-25 12:24
lft.db
2.43
KB
-rwxr-xr-x
2023-02-25 12:24
libnetcfg
15.41
KB
-rwxr-xr-x
2023-11-25 20:59
libtoolize
133.12
KB
-rwxr-xr-x
2024-04-09 20:04
link
38.83
KB
-rwxr-xr-x
2022-09-20 15:27
linux-boot-prober
1.54
KB
-rwxr-xr-x
2018-08-10 19:23
linux-check-removal
4.56
KB
-rwxr-xr-x
2018-09-05 17:52
linux-update-symlinks
6.17
KB
-rwxr-xr-x
2016-06-05 01:13
linux-version
2.63
KB
-rwxr-xr-x
2022-02-11 02:17
linux32
26.58
KB
-rwxr-xr-x
2024-11-21 20:01
linux64
26.58
KB
-rwxr-xr-x
2024-11-21 20:01
ln
71.12
KB
-rwxr-xr-x
2022-09-20 15:27
lnstat
26.59
KB
-rwxr-xr-x
2023-05-22 13:19
loadkeys
215.34
KB
-rwxr-xr-x
2023-03-23 09:34
loadunimap
38.87
KB
-rwxr-xr-x
2023-03-23 09:34
locale
46.16
KB
-rwxr-xr-x
2025-03-06 22:46
localectl
26.38
KB
-rwxr-xr-x
2025-03-06 14:56
localedef
291.91
KB
-rwxr-xr-x
2025-03-06 22:46
logger
54.9
KB
-rwxr-xr-x
2024-11-21 20:01
login
51.78
KB
-rwxr-xr-x
2023-03-23 12:40
loginctl
58.48
KB
-rwxr-xr-x
2025-03-06 14:56
logname
38.83
KB
-rwxr-xr-x
2022-09-20 15:27
logresolve
14.24
KB
-rwxr-xr-x
2024-10-04 15:21
look
18.31
KB
-rwxr-xr-x
2024-11-21 20:01
ls
147.8
KB
-rwxr-xr-x
2022-09-20 15:27
lsattr
14.24
KB
-rwxr-xr-x
2023-03-05 03:16
lsb_release
2.59
KB
-rwxr-xr-x
2022-09-26 20:06
lsblk
202.31
KB
-rwxr-xr-x
2024-11-21 20:01
lscpu
126.31
KB
-rwxr-xr-x
2024-11-21 20:01
lsfd
120.3
KB
-rwxr-xr-x
2024-11-21 20:01
lsinitramfs
735
B
-rwxr-xr-x
2024-08-22 19:30
lsipc
98.31
KB
-rwxr-xr-x
2024-11-21 20:01
lsirq
34.48
KB
-rwxr-xr-x
2024-11-21 20:01
lslocks
70.7
KB
-rwxr-xr-x
2024-11-21 20:01
lslogins
94.31
KB
-rwxr-xr-x
2024-11-21 20:01
lsmem
66.31
KB
-rwxr-xr-x
2024-11-21 20:01
lsmod
174.27
KB
-rwxr-xr-x
2022-12-10 00:02
lsns
82.31
KB
-rwxr-xr-x
2024-11-21 20:01
lsof
175.61
KB
-rwxr-xr-x
2022-04-28 04:08
lspci
104.04
KB
-rwxr-xr-x
2023-01-17 23:50
lspgpot
1.06
KB
-rwxr-xr-x
2017-08-28 10:22
lsusb
247.07
KB
-rwxr-xr-x
2024-01-24 21:32
lto-dump
30.47
MB
-rwxr-xr-x
2023-01-08 09:12
lto-dump-12
30.47
MB
-rwxr-xr-x
2023-01-08 09:12
lzcat
82.7
KB
-rwxr-xr-x
2025-04-03 19:55
lzcmp
7.25
KB
-rwxr-xr-x
2025-04-03 19:55
lzdiff
7.25
KB
-rwxr-xr-x
2025-04-03 19:55
lzegrep
10.09
KB
-rwxr-xr-x
2025-04-03 19:55
lzfgrep
10.09
KB
-rwxr-xr-x
2025-04-03 19:55
lzgrep
10.09
KB
-rwxr-xr-x
2025-04-03 19:55
lzless
1.77
KB
-rwxr-xr-x
2025-04-03 19:55
lzma
82.7
KB
-rwxr-xr-x
2025-04-03 19:55
lzmainfo
14.3
KB
-rwxr-xr-x
2025-04-03 19:55
lzmore
2.14
KB
-rwxr-xr-x
2025-04-03 19:55
m4
271.52
KB
-rwxr-xr-x
2023-02-03 13:00
make
234.65
KB
-rwxr-xr-x
2021-04-10 13:55
make-first-existing-target
4.79
KB
-rwxr-xr-x
2021-04-10 13:55
man
121.36
KB
-rwxr-xr-x
2023-03-12 22:23
man-recode
35.38
KB
-rwxr-xr-x
2023-03-12 22:23
mandb
147.61
KB
-rwxr-xr-x
2023-03-12 22:23
manpath
34.78
KB
-rwxr-xr-x
2023-03-12 22:23
mapscrn
34.84
KB
-rwxr-xr-x
2023-03-23 09:34
mariadb
5.06
MB
-rwxr-xr-x
2025-02-19 00:56
mariadb-access
109.31
KB
-rwxr-xr-x
2025-02-19 00:56
mariadb-admin
4.83
MB
-rwxr-xr-x
2025-02-19 00:56
mariadb-analyze
4.83
MB
-rwxr-xr-x
2025-02-19 00:56
mariadb-binlog
5.11
MB
-rwxr-xr-x
2025-02-19 00:56
mariadb-check
4.83
MB
-rwxr-xr-x
2025-02-19 00:56
mariadb-conv
4.55
MB
-rwxr-xr-x
2025-02-19 00:56
mariadb-convert-table-format
4.12
KB
-rwxr-xr-x
2025-02-19 00:56
mariadb-dump
4.92
MB
-rwxr-xr-x
2025-02-19 00:56
mariadb-dumpslow
8.05
KB
-rwxr-xr-x
2025-02-19 00:56
mariadb-find-rows
3.21
KB
-rwxr-xr-x
2025-02-19 00:56
mariadb-fix-extensions
1.22
KB
-rwxr-xr-x
2025-02-19 00:56
mariadb-hotcopy
34.52
KB
-rwxr-xr-x
2025-02-19 00:56
mariadb-import
4.82
MB
-rwxr-xr-x
2025-02-19 00:56
mariadb-install-db
22.13
KB
-rwxr-xr-x
2025-02-19 00:56
mariadb-optimize
4.83
MB
-rwxr-xr-x
2025-02-19 00:56
mariadb-plugin
4.52
MB
-rwxr-xr-x
2025-02-19 00:56
mariadb-repair
4.83
MB
-rwxr-xr-x
2025-02-19 00:56
mariadb-report
49.02
KB
-rwxr-xr-x
2025-02-19 00:56
mariadb-secure-installation
13.49
KB
-rwxr-xr-x
2025-02-19 00:56
mariadb-service-convert
2.45
KB
-rwxr-xr-x
2025-02-19 00:56
mariadb-setpermission
17.56
KB
-rwxr-xr-x
2025-02-19 00:56
mariadb-show
4.82
MB
-rwxr-xr-x
2025-02-19 00:56
mariadb-slap
4.84
MB
-rwxr-xr-x
2025-02-19 00:56
mariadb-tzinfo-to-sql
4.53
MB
-rwxr-xr-x
2025-02-19 00:56
mariadb-upgrade
4.96
MB
-rwxr-xr-x
2025-02-19 00:56
mariadb-waitpid
4.51
MB
-rwxr-xr-x
2025-02-19 00:56
mariadbcheck
4.83
MB
-rwxr-xr-x
2025-02-19 00:56
mariadbd-multi
26.69
KB
-rwxr-xr-x
2025-02-19 00:56
mariadbd-safe
30.42
KB
-rwxr-xr-x
2025-02-19 00:56
mariadbd-safe-helper
4.49
MB
-rwxr-xr-x
2025-02-19 00:56
mawk
154.66
KB
-rwxr-xr-x
2022-06-17 15:35
mcookie
34.38
KB
-rwxr-xr-x
2024-11-21 20:01
md5sum
50.95
KB
-rwxr-xr-x
2022-09-20 15:27
md5sum.textutils
50.95
KB
-rwxr-xr-x
2022-09-20 15:27
mdig
50.33
KB
-rwxr-xr-x
2025-01-25 10:14
memusage
7.29
KB
-rwxr-xr-x
2025-03-06 22:46
memusagestat
22.69
KB
-rwxr-xr-x
2025-03-06 22:46
mesg
18.3
KB
-rwxr-xr-x
2024-11-21 20:01
migrate-pubring-from-classic-gpg
2.99
KB
-rwxr-xr-x
2022-09-01 22:08
mk_modmap
15.78
KB
-rwxr-xr-x
2023-03-23 09:34
mkdir
95.27
KB
-rwxr-xr-x
2022-09-20 15:27
mkfifo
67.17
KB
-rwxr-xr-x
2022-09-20 15:27
mknod
71.2
KB
-rwxr-xr-x
2022-09-20 15:27
mktemp
42.92
KB
-rwxr-xr-x
2022-09-20 15:27
mongod
207.63
MB
-rwxr-xr-x
2013-12-19 05:41
mongodump
17.53
MB
-rwxr-xr-x
2025-04-01 15:22
mongoexport
17.26
MB
-rwxr-xr-x
2025-04-01 15:22
mongofiles
17.25
MB
-rwxr-xr-x
2025-04-01 15:22
mongoimport
17.44
MB
-rwxr-xr-x
2025-04-01 15:22
mongorestore
17.9
MB
-rwxr-xr-x
2025-04-01 15:22
mongos
160.52
MB
-rwxr-xr-x
2013-12-19 05:41
mongosh
142.35
MB
-rwxr-xr-x
2025-03-06 15:39
mongostat
17.05
MB
-rwxr-xr-x
2025-04-01 15:22
mongotop
16.67
MB
-rwxr-xr-x
2025-04-01 15:22
more
58.31
KB
-rwxr-xr-x
2024-11-21 20:01
mount
58.3
KB
-rwsr-xr-x
2024-11-21 20:01
mountpoint
18.3
KB
-rwxr-xr-x
2024-11-21 20:01
msgattrib
26.3
KB
-rwxr-xr-x
2023-02-26 15:20
msgcat
22.3
KB
-rwxr-xr-x
2023-02-26 15:20
msgcmp
26.3
KB
-rwxr-xr-x
2023-02-26 15:20
msgcomm
22.3
KB
-rwxr-xr-x
2023-02-26 15:20
msgconv
22.3
KB
-rwxr-xr-x
2023-02-26 15:20
msgen
22.3
KB
-rwxr-xr-x
2023-02-26 15:20
msgexec
18.3
KB
-rwxr-xr-x
2023-02-26 15:20
msgfilter
30.3
KB
-rwxr-xr-x
2023-02-26 15:20
msgfmt
86.5
KB
-rwxr-xr-x
2023-02-26 15:20
msggrep
114.42
KB
-rwxr-xr-x
2023-02-26 15:20
msginit
66.65
KB
-rwxr-xr-x
2023-02-26 15:20
msgmerge
70.68
KB
-rwxr-xr-x
2023-02-26 15:20
msgunfmt
34.32
KB
-rwxr-xr-x
2023-02-26 15:20
msguniq
22.3
KB
-rwxr-xr-x
2023-02-26 15:20
msql2mysql
1.41
KB
-rwxr-xr-x
2025-02-19 00:56
mt
83.38
KB
-rwxr-xr-x
2022-09-14 19:45
mt-gnu
83.38
KB
-rwxr-xr-x
2022-09-14 19:45
mtrace
6.35
KB
-rwxr-xr-x
2025-03-06 22:46
munchlist
31.23
KB
-rwxr-xr-x
2022-03-29 18:19
mv
139.62
KB
-rwxr-xr-x
2022-09-20 15:27
my_print_defaults
4.52
MB
-rwxr-xr-x
2025-02-19 00:56
myisam_ftdump
4.85
MB
-rwxr-xr-x
2025-02-19 00:56
myisamchk
4.97
MB
-rwxr-xr-x
2025-02-19 00:56
myisamlog
4.83
MB
-rwxr-xr-x
2025-02-19 00:56
myisampack
4.88
MB
-rwxr-xr-x
2025-02-19 00:56
mysql
5.06
MB
-rwxr-xr-x
2025-02-19 00:56
mysql_convert_table_format
4.12
KB
-rwxr-xr-x
2025-02-19 00:56
mysql_find_rows
3.21
KB
-rwxr-xr-x
2025-02-19 00:56
mysql_fix_extensions
1.22
KB
-rwxr-xr-x
2025-02-19 00:56
mysql_install_db
22.13
KB
-rwxr-xr-x
2025-02-19 00:56
mysql_plugin
4.52
MB
-rwxr-xr-x
2025-02-19 00:56
mysql_secure_installation
13.49
KB
-rwxr-xr-x
2025-02-19 00:56
mysql_setpermission
17.56
KB
-rwxr-xr-x
2025-02-19 00:56
mysql_tzinfo_to_sql
4.53
MB
-rwxr-xr-x
2025-02-19 00:56
mysql_upgrade
4.96
MB
-rwxr-xr-x
2025-02-19 00:56
mysql_waitpid
4.51
MB
-rwxr-xr-x
2025-02-19 00:56
mysqlaccess
109.31
KB
-rwxr-xr-x
2025-02-19 00:56
mysqladmin
4.83
MB
-rwxr-xr-x
2025-02-19 00:56
mysqlanalyze
4.83
MB
-rwxr-xr-x
2025-02-19 00:56
mysqlbinlog
5.11
MB
-rwxr-xr-x
2025-02-19 00:56
mysqlcheck
4.83
MB
-rwxr-xr-x
2025-02-19 00:56
mysqld_multi
26.69
KB
-rwxr-xr-x
2025-02-19 00:56
mysqld_safe
30.42
KB
-rwxr-xr-x
2025-02-19 00:56
mysqld_safe_helper
4.49
MB
-rwxr-xr-x
2025-02-19 00:56
mysqldump
4.92
MB
-rwxr-xr-x
2025-02-19 00:56
mysqldumpslow
8.05
KB
-rwxr-xr-x
2025-02-19 00:56
mysqlhotcopy
34.52
KB
-rwxr-xr-x
2025-02-19 00:56
mysqlimport
4.82
MB
-rwxr-xr-x
2025-02-19 00:56
mysqloptimize
4.83
MB
-rwxr-xr-x
2025-02-19 00:56
mysqlrepair
4.83
MB
-rwxr-xr-x
2025-02-19 00:56
mysqlreport
49.02
KB
-rwxr-xr-x
2025-02-19 00:56
mysqlshow
4.82
MB
-rwxr-xr-x
2025-02-19 00:56
mysqlslap
4.84
MB
-rwxr-xr-x
2025-02-19 00:56
mytop
71.95
KB
-rwxr-xr-x
2025-02-19 00:56
namei
34.31
KB
-rwxr-xr-x
2024-11-21 20:01
nano
280.74
KB
-rwxr-xr-x
2024-05-06 06:10
nawk
696.44
KB
-rwxr-xr-x
2023-02-19 13:30
nc
34.13
KB
-rwxr-xr-x
2021-08-20 11:41
nc.traditional
34.13
KB
-rwxr-xr-x
2021-08-20 11:41
neqn
913
B
-rwxr-xr-x
2023-03-07 09:38
netcat
34.13
KB
-rwxr-xr-x
2021-08-20 11:41
networkctl
106.38
KB
-rwxr-xr-x
2025-03-06 14:56
newgrp
47.75
KB
-rwsr-xr-x
2023-03-23 12:40
ngettext
34.31
KB
-rwxr-xr-x
2023-02-26 15:20
nice
42.86
KB
-rwxr-xr-x
2022-09-20 15:27
nisdomainname
22.15
KB
-rwxr-xr-x
2022-12-19 13:33
nl
111.11
KB
-rwxr-xr-x
2022-09-20 15:27
nm
44.03
KB
-rwxr-xr-x
2023-01-14 17:24
node
97.47
MB
-rwxr-xr-x
2024-04-10 12:32
nodejs
97.47
MB
-rwxr-xr-x
2024-04-10 12:32
nohup
42.89
KB
-rwxr-xr-x
2022-09-20 15:27
normalizer
244
B
-rwxr-xr-x
2022-11-27 08:00
npm
54
B
-rwxr-xr-x
2022-10-11 10:59
nproc
42.89
KB
-rwxr-xr-x
2022-09-20 15:27
npx
2.86
KB
-rwxr-xr-x
2023-08-09 13:29
nroff
3.22
KB
-rwxr-xr-x
2023-03-07 09:38
nsenter
34.54
KB
-rwxr-xr-x
2024-11-21 20:01
nslookup
114.74
KB
-rwxr-xr-x
2025-01-25 10:14
nstat
104.45
KB
-rwxr-xr-x
2023-05-22 13:19
nsupdate
74.55
KB
-rwxr-xr-x
2025-01-25 10:14
numfmt
67.02
KB
-rwxr-xr-x
2022-09-20 15:27
objcopy
155.66
KB
-rwxr-xr-x
2023-01-14 17:24
objdump
362.56
KB
-rwxr-xr-x
2023-01-14 17:24
od
79.02
KB
-rwxr-xr-x
2022-09-20 15:27
open
18.06
KB
-rwxr-xr-x
2021-11-29 13:07
openssl
953.26
KB
-rwxr-xr-x
2024-10-27 14:16
openvt
23.13
KB
-rwxr-xr-x
2023-03-23 09:34
os-prober
4.42
KB
-rwxr-xr-x
2021-09-22 18:07
pager
194.3
KB
-rwxr-xr-x
2024-05-02 18:30
partx
118.31
KB
-rwxr-xr-x
2024-11-21 20:01
passwd
66.65
KB
-rwsr-xr-x
2023-03-23 12:40
paste
42.89
KB
-rwxr-xr-x
2022-09-20 15:27
patch
187.44
KB
-rwxr-xr-x
2021-01-09 08:58
pathchk
42.86
KB
-rwxr-xr-x
2022-09-20 15:27
pcre2-config
1.93
KB
-rwxr-xr-x
2023-01-01 15:44
pdb3
62.4
KB
-rwxr-xr-x
2024-11-30 21:22
pdb3.11
62.4
KB
-rwxr-xr-x
2024-11-30 21:22
pear
793
B
-rwxr-xr-x
2023-06-12 06:24
peardev
814
B
-rwxr-xr-x
2023-06-12 06:24
pecl
727
B
-rwxr-xr-x
2023-06-12 06:24
peekfd
14.5
KB
-rwxr-xr-x
2022-12-13 05:27
perl
3.63
MB
-rwxr-xr-x
2023-11-25 20:59
perl5.36-x86_64-linux-gnu
14.41
KB
-rwxr-xr-x
2023-11-25 20:59
perl5.36.0
3.63
MB
-rwxr-xr-x
2023-11-25 20:59
perlbug
44.12
KB
-rwxr-xr-x
2023-11-25 20:59
perldoc
125
B
-rwxr-xr-x
2023-07-05 08:56
perlivp
10.61
KB
-rwxr-xr-x
2023-11-25 20:59
perlthanks
44.12
KB
-rwxr-xr-x
2023-11-25 20:59
perror
4.71
MB
-rwxr-xr-x
2025-02-19 00:56
pgrep
34.42
KB
-rwxr-xr-x
2022-12-19 06:06
phar
14.88
KB
-rwxr-xr-x
2025-10-01 20:26
phar.default
14.88
KB
-rwxr-xr-x
2025-10-01 20:26
phar.phar
14.88
KB
-rwxr-xr-x
2025-10-01 20:26
phar.phar.default
14.88
KB
-rwxr-xr-x
2025-10-01 20:26
phar.phar8.2
14.88
KB
-rwxr-xr-x
2025-03-13 18:10
phar.phar8.4
14.88
KB
-rwxr-xr-x
2025-10-01 20:26
phar8.2
14.88
KB
-rwxr-xr-x
2025-03-13 18:10
phar8.2.phar
14.88
KB
-rwxr-xr-x
2025-03-13 18:10
phar8.4
14.88
KB
-rwxr-xr-x
2025-10-01 20:26
phar8.4.phar
14.88
KB
-rwxr-xr-x
2025-10-01 20:26
php
5.72
MB
-rwxr-xr-x
2025-10-01 20:26
php-config
4.24
KB
-rwxr-xr-x
2025-03-13 18:10
php-config8.2
4.24
KB
-rwxr-xr-x
2025-03-13 18:10
php.default
5.72
MB
-rwxr-xr-x
2025-10-01 20:26
php8.2
5.4
MB
-rwxr-xr-x
2025-03-13 18:10
php8.4
5.72
MB
-rwxr-xr-x
2025-10-01 20:26
phpabtpl
8.47
KB
-rwxr-xr-x
2023-01-28 15:13
phpize
4.83
KB
-rwxr-xr-x
2025-03-13 18:10
phpize8.2
4.83
KB
-rwxr-xr-x
2025-03-13 18:10
pic
220.27
KB
-rwxr-xr-x
2023-03-07 09:38
pico
280.74
KB
-rwxr-xr-x
2024-05-06 06:10
piconv
8.16
KB
-rwxr-xr-x
2023-11-25 20:59
pidof
26.31
KB
-rwxr-xr-x
2023-04-03 06:25
pidwait
34.42
KB
-rwxr-xr-x
2022-12-19 06:06
pinentry
70.57
KB
-rwxr-xr-x
2022-10-18 14:52
pinentry-curses
70.57
KB
-rwxr-xr-x
2022-10-18 14:52
ping
88.45
KB
-rwxr-xr-x
2024-09-24 17:00
ping4
88.45
KB
-rwxr-xr-x
2024-09-24 17:00
ping6
88.45
KB
-rwxr-xr-x
2024-09-24 17:00
pinky
47.05
KB
-rwxr-xr-x
2022-09-20 15:27
pip
221
B
-rwxr-xr-x
2023-02-19 14:19
pip3
221
B
-rwxr-xr-x
2023-02-19 14:19
pip3.11
221
B
-rwxr-xr-x
2023-02-19 14:19
pkaction
18.23
KB
-rwxr-xr-x
2023-01-31 22:05
pkcheck
22.3
KB
-rwxr-xr-x
2023-01-31 22:05
pkcon
55.61
KB
-rwxr-xr-x
2023-05-28 17:00
pkg-config
44.04
KB
-rwxr-xr-x
2023-01-22 11:06
pkgconf
44.04
KB
-rwxr-xr-x
2023-01-22 11:06
pkgtools
1.34
KB
-rwxr-xr-x
2023-01-28 15:13
pkill
34.42
KB
-rwxr-xr-x
2022-12-19 06:06
pkmon
22.79
KB
-rwxr-xr-x
2023-05-28 17:00
pkttyagent
18.23
KB
-rwxr-xr-x
2023-01-31 22:05
pl2pm
4.43
KB
-rwxr-xr-x
2023-11-25 20:59
pldd
22.69
KB
-rwxr-xr-x
2025-03-06 22:46
pm2
56
B
-rwxr-xr-x
2025-04-08 13:05
pm2-dev
59
B
-rwxr-xr-x
2025-04-08 13:05
pm2-docker
67
B
-rwxr-xr-x
2025-04-08 13:05
pm2-runtime
67
B
-rwxr-xr-x
2025-04-08 13:05
pmap
34.34
KB
-rwxr-xr-x
2022-12-19 06:06
po2debconf
8.47
KB
-rwxr-xr-x
2020-12-30 01:09
pod2html
4.04
KB
-rwxr-xr-x
2023-11-25 20:59
pod2man
14.68
KB
-rwxr-xr-x
2023-11-25 20:59
pod2text
10.55
KB
-rwxr-xr-x
2023-11-25 20:59
pod2usage
4.01
KB
-rwxr-xr-x
2023-11-25 20:59
podchecker
3.57
KB
-rwxr-xr-x
2023-11-25 20:59
podebconf-display-po
12.67
KB
-rwxr-xr-x
2015-01-10 14:10
podebconf-report-po
31.76
KB
-rwxr-xr-x
2015-01-10 15:44
pr
79.11
KB
-rwxr-xr-x
2022-09-20 15:27
preconv
66.43
KB
-rwxr-xr-x
2023-03-07 09:38
print
18.06
KB
-rwxr-xr-x
2021-11-29 13:07
printenv
34.83
KB
-rwxr-xr-x
2022-09-20 15:27
printf
62.92
KB
-rwxr-xr-x
2022-09-20 15:27
prlimit
38.83
KB
-rwxr-xr-x
2024-11-21 20:01
procan
79.91
KB
-rwxr-xr-x
2022-11-06 08:15
prove
13.34
KB
-rwxr-xr-x
2023-11-25 20:59
prtstat
18.57
KB
-rwxr-xr-x
2022-12-13 05:27
ps
142.93
KB
-rwxr-xr-x
2022-12-19 06:06
psfaddtable
30.62
KB
-rwxr-xr-x
2023-03-23 09:34
psfgettable
30.62
KB
-rwxr-xr-x
2023-03-23 09:34
psfstriptable
30.62
KB
-rwxr-xr-x
2023-03-23 09:34
psfxtable
30.62
KB
-rwxr-xr-x
2023-03-23 09:34
pslog
14.45
KB
-rwxr-xr-x
2022-12-13 05:27
pstree
35.78
KB
-rwxr-xr-x
2022-12-13 05:27
pstree.x11
35.78
KB
-rwxr-xr-x
2022-12-13 05:27
ptar
3.48
KB
-rwxr-xr-x
2023-11-25 20:59
ptardiff
2.58
KB
-rwxr-xr-x
2023-11-25 20:59
ptargrep
4.29
KB
-rwxr-xr-x
2023-11-25 20:59
ptx
135.23
KB
-rwxr-xr-x
2022-09-20 15:27
pv
63.98
KB
-rwxr-xr-x
2022-04-12 00:55
pwd
42.92
KB
-rwxr-xr-x
2022-09-20 15:27
pwdx
14.3
KB
-rwxr-xr-x
2022-12-19 06:06
py3clean
7.63
KB
-rwxr-xr-x
2023-04-09 10:22
py3compile
13
KB
-rwxr-xr-x
2023-04-09 10:22
py3versions
12.52
KB
-rwxr-xr-x
2023-04-09 10:22
pydoc3
79
B
-rwxr-xr-x
2024-11-30 21:22
pydoc3.11
79
B
-rwxr-xr-x
2024-11-30 21:22
pygettext3
23.67
KB
-rwxr-xr-x
2023-02-07 13:37
pygettext3.11
23.67
KB
-rwxr-xr-x
2023-02-07 13:37
python3
6.52
MB
-rwxr-xr-x
2024-11-30 21:22
python3-config
3
KB
-rwxr-xr-x
2024-11-30 21:22
python3.11
6.52
MB
-rwxr-xr-x
2024-11-30 21:22
python3.11-config
3
KB
-rwxr-xr-x
2024-11-30 21:22
pzstd
742.38
KB
-rwxr-xr-x
2023-03-18 20:58
querybts
10.64
KB
-rwxr-xr-x
2023-04-29 06:38
ranlib
51.17
KB
-rwxr-xr-x
2023-01-14 17:24
rbash
1.21
MB
-rwxr-xr-x
2024-03-29 19:40
rdma
180.6
KB
-rwxr-xr-x
2023-05-22 13:19
readelf
751.38
KB
-rwxr-xr-x
2023-01-14 17:24
readlink
50.89
KB
-rwxr-xr-x
2022-09-20 15:27
realpath
50.92
KB
-rwxr-xr-x
2022-09-20 15:27
recode-sr-latin
14.3
KB
-rwxr-xr-x
2023-02-26 15:20
redis-benchmark
738.63
KB
-rwxr-xr-x
2025-01-19 10:41
redis-check-aof
2.28
MB
-rwxr-xr-x
2025-01-19 10:41
redis-check-rdb
2.28
MB
-rwxr-xr-x
2025-01-19 10:41
redis-cli
366.27
KB
-rwxr-xr-x
2025-01-19 10:41
redis-server
2.28
MB
-rwxr-xr-x
2025-01-19 10:41
rename.ul
22.3
KB
-rwxr-xr-x
2024-11-21 20:01
renice
14.3
KB
-rwxr-xr-x
2024-11-21 20:01
replace
4.5
MB
-rwxr-xr-x
2025-02-19 00:56
report-hw
2.06
KB
-rwxr-xr-x
2021-09-22 18:06
reportbug
110.11
KB
-rwxr-xr-x
2023-04-29 06:38
reset
30.24
KB
-rwxr-xr-x
2023-05-07 14:33
resizecons
26.8
KB
-rwxr-xr-x
2023-03-23 09:34
resizepart
70.31
KB
-rwxr-xr-x
2024-11-21 20:01
resolve_stack_dump
4.52
MB
-rwxr-xr-x
2025-02-19 00:56
resolveip
4.52
MB
-rwxr-xr-x
2025-02-19 00:56
rev
14.3
KB
-rwxr-xr-x
2024-11-21 20:01
rgrep
30
B
-rwxr-xr-x
2020-01-29 12:09
rm
71.05
KB
-rwxr-xr-x
2022-09-20 15:27
rmdir
54.92
KB
-rwxr-xr-x
2022-09-20 15:27
rnano
280.74
KB
-rwxr-xr-x
2024-05-06 06:10
rotatelogs
26.31
KB
-rwxr-xr-x
2024-10-04 15:21
routel
1.62
KB
-rwxr-xr-x
2023-05-22 13:19
rpcgen
95
KB
-rwxr-xr-x
2022-12-02 21:30
rrsync
12.34
KB
-rwxr-xr-x
2025-01-15 18:47
rsync
502.38
KB
-rwxr-xr-x
2025-01-15 18:47
rsync-ssl
5.02
KB
-rwxr-xr-x
2025-01-15 18:47
rtstat
26.59
KB
-rwxr-xr-x
2023-05-22 13:19
run-mailcap
18.06
KB
-rwxr-xr-x
2021-11-29 13:07
run-parts
26.91
KB
-rwxr-xr-x
2023-07-28 23:46
runcon
42.95
KB
-rwxr-xr-x
2022-09-20 15:27
rview
1.55
MB
-rwxr-xr-x
2025-02-16 05:23
savelog
10.24
KB
-rwxr-xr-x
2023-07-28 23:46
scp
266.63
KB
-rwxr-xr-x
2025-02-14 13:06
screendump
14.47
KB
-rwxr-xr-x
2023-03-23 09:34
script
70.3
KB
-rwxr-xr-x
2024-11-21 20:01
scriptlive
54.3
KB
-rwxr-xr-x
2024-11-21 20:01
scriptreplay
46.3
KB
-rwxr-xr-x
2024-11-21 20:01
sdiff
55.08
KB
-rwxr-xr-x
2023-02-03 19:00
sed
123.46
KB
-rwxr-xr-x
2023-01-05 19:55
see
18.06
KB
-rwxr-xr-x
2021-11-29 13:07
select-default-iwrap
474
B
-rwxr-xr-x
2023-03-14 21:17
select-editor
2.39
KB
-rwxr-xr-x
2023-01-14 16:28
sensible-browser
1.26
KB
-rwxr-xr-x
2023-01-14 16:28
sensible-editor
1.24
KB
-rwxr-xr-x
2023-01-14 16:28
sensible-pager
565
B
-rwxr-xr-x
2023-01-14 16:28
seq
58.92
KB
-rwxr-xr-x
2022-09-20 15:27
setarch
26.58
KB
-rwxr-xr-x
2024-11-21 20:01
setfont
58.9
KB
-rwxr-xr-x
2023-03-23 09:34
setkeycodes
14.52
KB
-rwxr-xr-x
2023-03-23 09:34
setleds
18.55
KB
-rwxr-xr-x
2023-03-23 09:34
setlogcons
14.52
KB
-rwxr-xr-x
2023-03-23 09:34
setmetamode
14.66
KB
-rwxr-xr-x
2023-03-23 09:34
setpci
30.31
KB
-rwxr-xr-x
2023-01-17 23:50
setpriv
78.31
KB
-rwxr-xr-x
2024-11-21 20:01
setsid
14.3
KB
-rwxr-xr-x
2024-11-21 20:01
setterm
46.31
KB
-rwxr-xr-x
2024-11-21 20:01
setupcon
39.35
KB
-rwxr-xr-x
2023-05-21 21:30
setvtrgb
14.65
KB
-rwxr-xr-x
2023-03-23 09:34
sftp
282.59
KB
-rwxr-xr-x
2025-02-14 13:06
sg
47.75
KB
-rwsr-xr-x
2023-03-23 12:40
sh
122.7
KB
-rwxr-xr-x
2023-01-05 13:20
sha1sum
54.95
KB
-rwxr-xr-x
2022-09-20 15:27
sha224sum
58.95
KB
-rwxr-xr-x
2022-09-20 15:27
sha256sum
58.95
KB
-rwxr-xr-x
2022-09-20 15:27
sha384sum
62.95
KB
-rwxr-xr-x
2022-09-20 15:27
sha512sum
62.95
KB
-rwxr-xr-x
2022-09-20 15:27
shasum
9.75
KB
-rwxr-xr-x
2023-11-25 20:59
showconsolefont
22.57
KB
-rwxr-xr-x
2023-03-23 09:34
showkey
18.56
KB
-rwxr-xr-x
2023-03-23 09:34
shred
63.14
KB
-rwxr-xr-x
2022-09-20 15:27
shtool
138.76
KB
-rwxr-xr-x
2019-12-23 21:26
shtoolize
15.16
KB
-rwxr-xr-x
2019-12-23 21:26
shuf
58.98
KB
-rwxr-xr-x
2022-09-20 15:27
size
26.86
KB
-rwxr-xr-x
2023-01-14 17:24
skill
30.33
KB
-rwxr-xr-x
2022-12-19 06:06
slabtop
22.37
KB
-rwxr-xr-x
2022-12-19 06:06
sleep
42.86
KB
-rwxr-xr-x
2022-09-20 15:27
slogin
1.07
MB
-rwxr-xr-x
2025-02-14 13:06
snice
30.33
KB
-rwxr-xr-x
2022-12-19 06:06
socat
401.98
KB
-rwxr-xr-x
2022-11-06 08:15
soelim
50.43
KB
-rwxr-xr-x
2023-03-07 09:38
sort
115.68
KB
-rwxr-xr-x
2022-09-20 15:27
sotruss
4.18
KB
-rwxr-xr-x
2025-03-06 22:46
splain
18.99
KB
-rwxr-xr-x
2023-11-25 20:59
split
59.55
KB
-rwxr-xr-x
2022-09-20 15:27
splitfont
14.39
KB
-rwxr-xr-x
2023-03-23 09:34
sprof
26.81
KB
-rwxr-xr-x
2025-03-06 22:46
ss
189.14
KB
-rwxr-xr-x
2023-05-22 13:19
ssh
1.07
MB
-rwxr-xr-x
2025-02-14 13:06
ssh-add
518.44
KB
-rwxr-xr-x
2025-02-14 13:06
ssh-agent
474.38
KB
-rwxr-sr-x
2025-02-14 13:06
ssh-argv0
1.42
KB
-rwxr-xr-x
2025-02-14 11:18
ssh-copy-id
12.38
KB
-rwxr-xr-x
2023-02-02 12:21
ssh-keygen
646.44
KB
-rwxr-xr-x
2025-02-14 13:06
ssh-keyscan
622.47
KB
-rwxr-xr-x
2025-02-14 13:06
stat
95.2
KB
-rwxr-xr-x
2022-09-20 15:27
stdbuf
58.92
KB
-rwxr-xr-x
2022-09-20 15:27
streamzip
7.75
KB
-rwxr-xr-x
2023-11-25 20:59
strings
30.98
KB
-rwxr-xr-x
2023-01-14 17:24
strip
155.7
KB
-rwxr-xr-x
2023-01-14 17:24
stty
83.02
KB
-rwxr-xr-x
2022-09-20 15:27
su
70.31
KB
-rwsr-xr-x
2024-11-21 20:01
sudo
275.02
KB
-rwsr-xr-x
2023-06-27 11:45
sudoedit
275.02
KB
-rwsr-xr-x
2023-06-27 11:45
sudoreplay
115.7
KB
-rwxr-xr-x
2023-06-27 11:45
sum
50.96
KB
-rwxr-xr-x
2022-09-20 15:27
sync
38.89
KB
-rwxr-xr-x
2022-09-20 15:27
systemctl
1.29
MB
-rwxr-xr-x
2025-03-06 14:56
systemd
90.38
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-analyze
182.61
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-ask-password
18.48
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-cat
18.38
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-cgls
22.48
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-cgtop
38.4
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-creds
42.61
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-cryptenroll
58.6
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-delta
26.38
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-detect-virt
18.37
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-escape
18.37
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-firstboot
50.59
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-hwdb
126.66
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-id128
22.37
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-inhibit
22.39
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-machine-id-setup
18.48
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-mount
50.59
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-notify
18.38
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-path
18.37
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-repart
150.69
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-run
58.57
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-socket-activate
26.38
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-stdio-bridge
18.38
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-sysext
42.49
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-sysusers
62.68
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-tmpfiles
110.57
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-tty-ask-password-agent
34.38
KB
-rwxr-xr-x
2025-03-06 14:56
systemd-umount
50.59
KB
-rwxr-xr-x
2025-03-06 14:56
tabs
18.23
KB
-rwxr-xr-x
2023-05-07 14:33
tac
111.05
KB
-rwxr-xr-x
2022-09-20 15:27
tail
75.14
KB
-rwxr-xr-x
2022-09-20 15:27
tar
519.52
KB
-rwxr-xr-x
2024-01-20 09:27
tasksel
26.82
KB
-rwxr-xr-x
2023-05-25 06:27
taskset
62.31
KB
-rwxr-xr-x
2024-11-21 20:01
tbl
146.43
KB
-rwxr-xr-x
2023-03-07 09:38
tee
42.95
KB
-rwxr-xr-x
2022-09-20 15:27
telnet
186.2
KB
-rwxr-xr-x
2023-08-23 10:01
tempfile
14.18
KB
-rwxr-xr-x
2023-07-28 23:46
test
58.89
KB
-rwxr-xr-x
2022-09-20 15:27
tic
90.34
KB
-rwxr-xr-x
2023-05-07 14:33
timedatectl
42.37
KB
-rwxr-xr-x
2025-03-06 14:56
timeout
47.49
KB
-rwxr-xr-x
2022-09-20 15:27
tload
18.32
KB
-rwxr-xr-x
2022-12-19 06:06
toe
22.23
KB
-rwxr-xr-x
2023-05-07 14:33
top
131.58
KB
-rwxr-xr-x
2022-12-19 06:06
touch
107.05
KB
-rwxr-xr-x
2022-09-20 15:27
tput
26.27
KB
-rwxr-xr-x
2023-05-07 14:33
tr
54.89
KB
-rwxr-xr-x
2022-09-20 15:27
traceproto
2.82
KB
-rwxr-xr-x
2023-02-25 12:24
traceproto.db
2.82
KB
-rwxr-xr-x
2023-02-25 12:24
traceroute
71.23
KB
-rwxr-xr-x
2023-02-25 12:24
traceroute-nanog
1.58
KB
-rwxr-xr-x
2023-02-25 12:24
traceroute.db
71.23
KB
-rwxr-xr-x
2023-02-25 12:24
traceroute6
71.23
KB
-rwxr-xr-x
2023-02-25 12:24
traceroute6.db
71.23
KB
-rwxr-xr-x
2023-02-25 12:24
troff
755.83
KB
-rwxr-xr-x
2023-03-07 09:38
true
34.83
KB
-rwxr-xr-x
2022-09-20 15:27
truncate
42.89
KB
-rwxr-xr-x
2022-09-20 15:27
tryaffix
4.8
KB
-rwxr-xr-x
2022-03-29 18:19
tset
30.24
KB
-rwxr-xr-x
2023-05-07 14:33
tsort
54.89
KB
-rwxr-xr-x
2022-09-20 15:27
tty
34.86
KB
-rwxr-xr-x
2022-09-20 15:27
tzselect
14.99
KB
-rwxr-xr-x
2025-03-06 22:46
ucf
40.69
KB
-rwxr-xr-x
2024-12-20 07:39
ucfq
18.91
KB
-rwxr-xr-x
2024-12-20 07:39
ucfr
10.85
KB
-rwxr-xr-x
2024-12-20 07:39
uclampset
62.31
KB
-rwxr-xr-x
2024-11-21 20:01
udevadm
1.29
MB
-rwxr-xr-x
2025-03-06 14:56
ul
22.31
KB
-rwxr-xr-x
2024-11-21 20:01
umount
34.3
KB
-rwsr-xr-x
2024-11-21 20:01
uname
42.86
KB
-rwxr-xr-x
2022-09-20 15:27
uncompress
2.29
KB
-rwxr-xr-x
2022-04-10 02:22
unexpand
42.92
KB
-rwxr-xr-x
2022-09-20 15:27
unicode_start
2.71
KB
-rwxr-xr-x
2023-03-23 09:34
unicode_stop
528
B
-rwxr-xr-x
2023-03-23 09:34
uniq
46.95
KB
-rwxr-xr-x
2022-09-20 15:27
unlink
38.83
KB
-rwxr-xr-x
2022-09-20 15:27
unlzma
82.7
KB
-rwxr-xr-x
2025-04-03 19:55
unmkinitramfs
3.59
KB
-rwxr-xr-x
2024-08-22 19:30
unshare
82.54
KB
-rwxr-xr-x
2024-11-21 20:01
unxz
82.7
KB
-rwxr-xr-x
2025-04-03 19:55
unzip
175.05
KB
-rwxr-xr-x
2023-02-19 18:02
unzipsfx
82.86
KB
-rwxr-xr-x
2023-02-19 18:02
unzstd
1.22
MB
-rwxr-xr-x
2023-03-18 20:58
update-alternatives
58.31
KB
-rwxr-xr-x
2023-05-11 02:04
update-mime-database
59.27
KB
-rwxr-xr-x
2022-04-29 17:19
uptime
14.3
KB
-rwxr-xr-x
2022-12-19 06:06
usb-devices
4.35
KB
-rwxr-xr-x
2024-01-24 21:32
usbhid-dump
30.76
KB
-rwxr-xr-x
2024-01-24 21:32
usbreset
14.46
KB
-rwxr-xr-x
2024-01-24 21:32
users
38.89
KB
-rwxr-xr-x
2022-09-20 15:27
utmpdump
30.3
KB
-rwxr-xr-x
2024-11-21 20:01
vdir
147.8
KB
-rwxr-xr-x
2022-09-20 15:27
vi
1.55
MB
-rwxr-xr-x
2025-02-16 05:23
view
1.55
MB
-rwxr-xr-x
2025-02-16 05:23
vim.tiny
1.55
MB
-rwxr-xr-x
2025-02-16 05:23
vmstat
34.72
KB
-rwxr-xr-x
2022-12-19 06:06
w
22.3
KB
-rwxr-xr-x
2022-12-19 06:06
wall
38.3
KB
-rwxr-xr-x
2024-11-21 20:01
watch
26.71
KB
-rwxr-xr-x
2022-12-19 06:06
watchgnupg
18.23
KB
-rwxr-xr-x
2023-03-26 13:03
wc
51.05
KB
-rwxr-xr-x
2022-09-20 15:27
wdctl
70.34
KB
-rwxr-xr-x
2024-11-21 20:01
wget
459.36
KB
-rwxr-xr-x
2025-03-03 13:32
whatis
51.29
KB
-rwxr-xr-x
2023-03-12 22:23
whereis
30.77
KB
-rwxr-xr-x
2024-11-21 20:01
which
946
B
-rwxr-xr-x
2023-07-28 23:46
which.debianutils
946
B
-rwxr-xr-x
2023-07-28 23:46
whiptail
26.75
KB
-rwxr-xr-x
2023-01-31 14:53
who
59.02
KB
-rwxr-xr-x
2022-09-20 15:27
whoami
38.86
KB
-rwxr-xr-x
2022-09-20 15:27
write
22.31
KB
-rwxr-xr-x
2024-11-21 20:01
wsrep_sst_backup
2.39
KB
-rwxr-xr-x
2025-02-19 00:56
wsrep_sst_common
66.5
KB
-rwxr-xr-x
2025-02-19 00:56
wsrep_sst_mariabackup
49.21
KB
-rwxr-xr-x
2025-02-19 00:56
wsrep_sst_mysqldump
8.04
KB
-rwxr-xr-x
2025-02-19 00:56
wsrep_sst_rsync
29.7
KB
-rwxr-xr-x
2025-02-19 00:56
wsrep_sst_rsync_wan
29.7
KB
-rwxr-xr-x
2025-02-19 00:56
x86_64
26.58
KB
-rwxr-xr-x
2024-11-21 20:01
x86_64-linux-gnu-addr2line
23.14
KB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-ar
51.17
KB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-as
897.41
KB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-c++filt
18.51
KB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-cpp
1.24
MB
-rwxr-xr-x
2023-01-08 09:12
x86_64-linux-gnu-cpp-12
1.24
MB
-rwxr-xr-x
2023-01-08 09:12
x86_64-linux-gnu-dwp
1.79
MB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-elfedit
35.03
KB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-g++
1.25
MB
-rwxr-xr-x
2023-01-08 09:12
x86_64-linux-gnu-g++-12
1.25
MB
-rwxr-xr-x
2023-01-08 09:12
x86_64-linux-gnu-gcc
1.24
MB
-rwxr-xr-x
2023-01-08 09:12
x86_64-linux-gnu-gcc-12
1.24
MB
-rwxr-xr-x
2023-01-08 09:12
x86_64-linux-gnu-gcc-ar
34.54
KB
-rwxr-xr-x
2023-01-08 09:12
x86_64-linux-gnu-gcc-ar-12
34.54
KB
-rwxr-xr-x
2023-01-08 09:12
x86_64-linux-gnu-gcc-nm
34.54
KB
-rwxr-xr-x
2023-01-08 09:12
x86_64-linux-gnu-gcc-nm-12
34.54
KB
-rwxr-xr-x
2023-01-08 09:12
x86_64-linux-gnu-gcc-ranlib
34.54
KB
-rwxr-xr-x
2023-01-08 09:12
x86_64-linux-gnu-gcc-ranlib-12
34.54
KB
-rwxr-xr-x
2023-01-08 09:12
x86_64-linux-gnu-gcov
720.16
KB
-rwxr-xr-x
2023-01-08 09:12
x86_64-linux-gnu-gcov-12
720.16
KB
-rwxr-xr-x
2023-01-08 09:12
x86_64-linux-gnu-gcov-dump
568.02
KB
-rwxr-xr-x
2023-01-08 09:12
x86_64-linux-gnu-gcov-dump-12
568.02
KB
-rwxr-xr-x
2023-01-08 09:12
x86_64-linux-gnu-gcov-tool
588.09
KB
-rwxr-xr-x
2023-01-08 09:12
x86_64-linux-gnu-gcov-tool-12
588.09
KB
-rwxr-xr-x
2023-01-08 09:12
x86_64-linux-gnu-gold
2.99
MB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-gp-archive
159.06
KB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-gp-collect-app
175.27
KB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-gp-display-html
578.29
KB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-gp-display-src
150.81
KB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-gp-display-text
257.3
KB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-gprof
108.35
KB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-gprofng
146.59
KB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-ld
1.27
MB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-ld.bfd
1.27
MB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-ld.gold
2.99
MB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-lto-dump
30.47
MB
-rwxr-xr-x
2023-01-08 09:12
x86_64-linux-gnu-lto-dump-12
30.47
MB
-rwxr-xr-x
2023-01-08 09:12
x86_64-linux-gnu-nm
44.03
KB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-objcopy
155.66
KB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-objdump
362.56
KB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-pkg-config
44.04
KB
-rwxr-xr-x
2023-01-22 11:06
x86_64-linux-gnu-pkgconf
44.04
KB
-rwxr-xr-x
2023-01-22 11:06
x86_64-linux-gnu-python3-config
3
KB
-rwxr-xr-x
2024-11-30 21:22
x86_64-linux-gnu-python3.11-config
3
KB
-rwxr-xr-x
2024-11-30 21:22
x86_64-linux-gnu-ranlib
51.17
KB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-readelf
751.38
KB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-size
26.86
KB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-strings
30.98
KB
-rwxr-xr-x
2023-01-14 17:24
x86_64-linux-gnu-strip
155.7
KB
-rwxr-xr-x
2023-01-14 17:24
xargs
70.45
KB
-rwxr-xr-x
2023-01-08 18:07
xauth
51.5
KB
-rwxr-xr-x
2023-01-24 16:29
xdg-user-dir
234
B
-rwxr-xr-x
2022-09-26 14:37
xdg-user-dirs-update
26.16
KB
-rwxr-xr-x
2022-09-26 14:37
xgettext
292.78
KB
-rwxr-xr-x
2023-02-26 15:20
xsubpp
5.05
KB
-rwxr-xr-x
2023-11-25 20:59
xz
82.7
KB
-rwxr-xr-x
2025-04-03 19:55
xzcat
82.7
KB
-rwxr-xr-x
2025-04-03 19:55
xzcmp
7.25
KB
-rwxr-xr-x
2025-04-03 19:55
xzdiff
7.25
KB
-rwxr-xr-x
2025-04-03 19:55
xzegrep
10.09
KB
-rwxr-xr-x
2025-04-03 19:55
xzfgrep
10.09
KB
-rwxr-xr-x
2025-04-03 19:55
xzgrep
10.09
KB
-rwxr-xr-x
2025-04-03 19:55
xzless
1.77
KB
-rwxr-xr-x
2025-04-03 19:55
xzmore
2.14
KB
-rwxr-xr-x
2025-04-03 19:55
yes
38.83
KB
-rwxr-xr-x
2022-09-20 15:27
ypdomainname
22.15
KB
-rwxr-xr-x
2022-12-19 13:33
zcat
1.94
KB
-rwxr-xr-x
2022-04-10 02:22
zcmp
1.64
KB
-rwxr-xr-x
2022-04-10 02:22
zdiff
6.31
KB
-rwxr-xr-x
2022-04-10 02:22
zdump
22.52
KB
-rwxr-xr-x
2025-03-06 22:46
zegrep
29
B
-rwxr-xr-x
2022-04-10 02:22
zfgrep
29
B
-rwxr-xr-x
2022-04-10 02:22
zforce
2.03
KB
-rwxr-xr-x
2022-04-10 02:22
zgrep
7.91
KB
-rwxr-xr-x
2022-04-10 02:22
zip
212.27
KB
-rwxr-xr-x
2023-02-19 18:00
zipcloak
92.48
KB
-rwxr-xr-x
2023-02-19 18:00
zipdetails
68.55
KB
-rwxr-xr-x
2023-11-25 20:59
zipgrep
2.89
KB
-rwxr-xr-x
2023-02-19 18:02
zipinfo
175.05
KB
-rwxr-xr-x
2023-02-19 18:02
zipnote
84.16
KB
-rwxr-xr-x
2023-02-19 18:00
zipsplit
88.19
KB
-rwxr-xr-x
2023-02-19 18:00
zless
2.15
KB
-rwxr-xr-x
2022-04-10 02:22
zmore
1.8
KB
-rwxr-xr-x
2022-04-10 02:22
znew
4.47
KB
-rwxr-xr-x
2022-04-10 02:22
zstd
1.22
MB
-rwxr-xr-x
2023-03-18 20:58
zstdcat
1.22
MB
-rwxr-xr-x
2023-03-18 20:58
zstdgrep
3.78
KB
-rwxr-xr-x
2023-03-18 20:58
zstdless
197
B
-rwxr-xr-x
2023-03-18 20:58
zstdmt
1.22
MB
-rwxr-xr-x
2023-03-18 20:58
Save
Rename
#!/usr/bin/perl # # $Id: mytop,v 1.99-maria6 2019/10/22 14:53:51 jweisbuch Exp $ =pod =head1 NAME mytop - display MariaDB/MySQL server performance info like `top' =cut ## most of the POD is at the bottom of the file use 5.005; use strict; use warnings; use DBI; use Getopt::Long; use Socket; use List::Util qw(min max); use File::Basename; $main::VERSION = "1.99-maria6"; 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, ## shows untruncated queries usercol_width => 8, ## User column width dbcol_width => 9, ## DB column width hide_progress => 0 ## hide the "%" column when available ); 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`; ## 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 and comments chomp; if (/(\S+)\s*=\s*(.*\S)/) { my ($k, $v) = ($1, $2); if ($k =~ /^filter_/i) { $config{lc $k} = StringOrRegex($v) if exists $config{lc $k}; } else { $config{lc $k} = $v if exists $config{lc $k}; } } } 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}, "usercol_width=i" => \$config{usercol_width}, "dbcol_width=i" => \$config{dbcol_width}, "hide_progress|a!" => \$config{hide_progress} ); ## 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. my $prefix= 'mysql'; if (eval {DBI->install_driver("MariaDB")}) { $dsn = "DBI:MariaDB:database=$config{db};mariadb_read_default_group=mytop;"; $prefix= 'mariadb' } else { $dsn = "DBI:mysql:database=$config{db};mysql_read_default_group=mytop;"; } if ($config{socket} and -S $config{socket}) { $dsn .= "${prefix}_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/MySQL 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") { $db_version = $_->{Value}; $db_version =~ /^(\d+)/; $db_release = $1; $server = "MariaDB" if ($db_version =~ /maria/i); # Get the version number only $db_version = $1 if($db_version =~ m/(.*?)-/); next; } if ($_->{Variable_name} eq "have_query_cache") { if ($_->{Value} ne 'NO') { $have_query_cache = 1; } else { $have_query_cache = 0; } next; } } my ($has_is_processlist, $has_time_ms, $has_progress); $has_is_processlist = $has_time_ms = $has_progress = 0; ## Check if the server has the INFORMATION_SCHEMA.PROCESSLIST table ## for backward compatibility $has_is_processlist = Execute("SELECT /*mytop*/ 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'information_schema' AND TABLE_NAME = 'PROCESSLIST';")->rows; if ($has_is_processlist == 1) { ## Check if the server has the TIME_MS column on the I_S.PROCESSLIST table ## If it is the case, it will fetch the query time with decimal precision ## for queries that has been running for less than 10k seconds $has_time_ms = Execute("SELECT /*mytop*/ 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'information_schema' AND TABLE_NAME = 'PROCESSLIST' AND COLUMN_NAME = 'TIME_MS';")->rows; if ($has_time_ms == 1) { ## Check if the server has the STAGE column on the I_S.PROCESSLIST ## table (MariaDB) to retreive query completion information $has_progress = Execute("SELECT /*mytop*/ 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'information_schema' AND TABLE_NAME = 'PROCESSLIST' AND COLUMN_NAME = 'STAGE';")->rows; } } ######################################################################### ## ## 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}; print "InnoDB Status [hit t to exit this mode or q to exit the application]\n"; $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 /*mytop*/ SLAVE;"); Execute("SET /*mytop*/ GLOBAL sql_slave_skip_counter=1"); Execute("START /*mytop*/ 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 [hit t to exit this mode or q to exit the application]\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 /*mytop*/ 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 /*mytop*/ $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 /*mytop*/ $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 /*mytop*/ 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); } ## M - 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; } } ## w - change columns width for the "User" and "Database" columns if ($key eq 'w') { ReadMode($RM_RESET); print RED(), "Width for the 'User' column (the actual value is ". $config{usercol_width}."): "; my $readWidth = ReadLine(0); chomp($readWidth); if (defined($readWidth) && $readWidth ne "") { if ($readWidth > 4 && $readWidth < 60) { $config{usercol_width} = $readWidth; } else { print RED(), "-- Invalid value ($readWidth), the previous value". "has been kept, press a key to resume --"; ReadKey(0); } } print RESET(), RED(), "Width for the 'DB' column (the actual value is ". $config{dbcol_width}."): ", RESET(); $readWidth = ReadLine(0); chomp($readWidth); if (defined($readWidth) && $readWidth ne "") { if ($readWidth > 2 && $readWidth < 60) { $config{dbcol_width} = $readWidth } else { print RED(), "-- Invalid value ($readWidth), the previous value". "has been kept, press a key to resume --", RESET(); ReadKey(0); } } undef $readWidth; ReadMode($RM_NOBLKRD); next; } ## a - progress column toggle (the column is only displayed ## if progress information are available from the processlist) if ($key eq 'a') { if ($config{hide_progress}) { $config{hide_progress} = 0; print RED(), "-- progress display ON --", RESET(); sleep 1; } else { $config{hide_progress} = 1; print RED(), "-- progress display OFF --", 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 /*mytop*/ GLOBAL STATUS"); } else { @recs = Hashes("SHOW /*mytop*/ 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; } } my $l; if (-e "/proc/loadavg") { ## To avoid warnings if the OS is not Linux open (my $fh, "<", "/proc/loadavg"); ## Only the first 3 values are interresting $l = join(" ", (split /\s+/, <$fh>)[0..2]); close $fh; } $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 = length("$server $db_version on $config{host}"); my $up_width = $width - $host_width - 1; Clear() unless $config{batchmode}; print RESET(); printf "%-.${host_width}s %${up_width}s\n", "$server $db_version on $config{host}", defined($l) ? "load ($l) up $uptime $current_time" : "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(" MyISAM Key Cache 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 ($data) = Hashes('SHOW /*mytop*/ GLOBAL VARIABLES LIKE "read_only"'); if ($data->{Value} ne "OFF") { print RED() if ($HAS_COLOR) ; print " ReadOnly"; RESET() if ($HAS_COLOR); } ($data) = Hashes('SHOW /*mytop*/ 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 "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 $proc_cmd; ## Query used to fetch the processlist my $time_format = "6d"; if ($has_is_processlist == 1) { if ($has_time_ms == 1) { $time_format = "6.6s"; if ($has_progress == 1) { ## To have a computed value of "Progress" like the ## "SHOW PROCESSLIST" one, the Progress column of the query ## must be replaced by : ## "CASE WHEN Max_Stage < 2 THEN Progress ELSE ## (Stage-1)/Max_Stage*100+Progress/Max_Stage END AS Progress" $proc_cmd = "SELECT /*mytop*/ Id, User, Host, db, Command, CASE WHEN TIME > 10000 THEN Time ELSE ROUND(TIME_MS/1000, 1) END AS Time, State, Info, Progress, Stage, Max_Stage FROM INFORMATION_SCHEMA.PROCESSLIST WHERE ID != CONNECTION_ID();"; } else { $proc_cmd = "SELECT /*mytop*/ Id, User, Host, db, Command, CASE WHEN TIME > 10000 THEN Time ELSE ROUND(TIME_MS/1000, 1) END AS Time, State, Info FROM INFORMATION_SCHEMA.PROCESSLIST WHERE ID != CONNECTION_ID();"; } } else { $proc_cmd = "SELECT /*mytop*/ Id, User, Host, db, Command, Time, State, Info FROM INFORMATION_SCHEMA.PROCESSLIST WHERE ID != CONNECTION_ID();"; } } else { $proc_cmd = "SHOW /*mytop*/ FULL PROCESSLIST;"; } ## Minimal width values for columns with a dynamic width if ($config{usercol_width} < 4) { $config{usercol_width} = 4; } if ($config{dbcol_width} < 2) { $config{dbcol_width} = 2; } my @sz = (9, $config{usercol_width}, 15, $config{dbcol_width}, 6, 6, 8); if ($has_progress == 1 && !$config{hide_progress}) { push @sz, 5; }; my $used = scalar(@sz) + Sum(@sz); undef(@sz); ## If the terminal width <= 80, the state column will have a width of 6 ## chars else it will be between 6 and 15 depending on the terminal width my $state = $width <= 80 ? 6 : int(min(6+($width-80)/3, 15)); ## $free = The number of chars between the beginning of the "Query" ## column and the end of the line my $free = $width - $used - ($state - 6); my $format= "%9s %$config{usercol_width}s %15s %$config{dbcol_width}s %6s "; if ($has_progress == 1 && !$config{hide_progress}) { $format .= "%5s "; } $format .= "%6s %${state}s %-.${free}s\n"; my $format2 = "%9d %$config{usercol_width}.$config{usercol_width}s %15.15s %$config{dbcol_width}.$config{dbcol_width}s %${time_format} "; if ($has_progress == 1 && !$config{hide_progress}) { $format2 .= "%5.1f "; } $format2 .= "%6.6s %${state}.${state}s "; if ($config{fullqueries}) { $format2 .= "%-${free}s\n"; } else { $format2 .= "%-${free}.${free}s\n"; } print BOLD() if ($HAS_COLOR); if ($has_progress == 1 && !$config{hide_progress}) { printf $format, 'Id','User','Host/IP','DB','Time', '%', 'Cmd', 'State', 'Query'; } else { printf $format, 'Id','User','Host/IP','DB','Time', 'Cmd', 'State', 'Query'; } print RESET() if ($HAS_COLOR); ## Id User Host DB if ($has_progress == 1 && !$config{hide_progress}) { printf $format, '--','----','-------','--','----', '-', '---', '-----', '----------'; } else { printf $format, '--','----','-------','--','----', '---', '-----', '----------'; } $lines_left -= 2; 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 = gethostbyaddr(inet_aton($thread->{Host}), AF_INET); if ($host) { ## Only the hostname part of the DNS is kept $host =~ s/^([^.]+).*/$1/; } $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. ## Replace newlines and carriage returns with a space $thread->{Info} =~ tr/\n\r/ /; ## Leading space removal $thread->{Info} =~ s/^\s*//; ## Strip non printing control symbols $thread->{Info} =~ tr/[[:cntrl:]]//; ## Collpase whitespace $thread->{Info} =~ s/\s+/ /g; ## Trailing space removal $thread->{Info} =~ s/\s$//; ## Put the first letter of the query uppercase for a better readability ## with long State strings $thread->{Info} = ucfirst $thread->{Info}; ## Stow it in the cache $qcache{$thread->{Id}} = $thread->{Info}; $dbcache{$thread->{Id}} = $thread->{db}; $ucache{$thread->{Id}} = $thread->{User}; ## If Progress information is available and a multi-stage query is ## running, the actual stage and the total number of stages of the ## thread are shown at the beginning of the State column if ($has_progress == 1 && $thread->{Max_Stage} && $thread->{Max_Stage} > 1) { $thread->{State} = $thread->{Stage}."/". $thread->{Max_Stage}." ".$thread->{State}; } } ## 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}; if (length($smInfo) > $free) { $lines_left -= int((length($smInfo) - $free)/$width) + 1; } } else { $smInfo = substr $thread->{Info}, 0, $free; } } # if ($thread->{State}) # { # $smInfo = substr $thread->{State}, 0, $free; # } else { $smInfo = ""; } $lines_left--; if ($lines_left < 0) { print WHITE(), "-- Truncated query list -- "; last; } 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}; } if ($has_progress == 1 && !$config{hide_progress}) { printf $format2, $thread->{Id}, $thread->{User}, $thread->{Host}, $thread->{db}, $thread->{Time}, $thread->{Progress}, $thread->{Command}, $thread->{State}, $smInfo; } else { printf $format2, $thread->{Id}, $thread->{User}, $thread->{Host}, $thread->{db}, $thread->{Time}, $thread->{Command}, $thread->{State}, $smInfo; } print RESET() if $HAS_COLOR; } } ########################################################################### my $questions; sub GetQPS() { my ($data) = Hashes('SHOW /*mytop*/ 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 GetInnoDBStatus() { if (not $config{pager}) { if (not $config{pager} = my_which('less')) { $config{pager} = my_which('more'); } } my @data = Hashes("SHOW /*mytop*/ 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 /*mytop*/ 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 /*mytop*/ 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 /*mytop*/ 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 /*mytop*/ $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}> and Jean Weisbuch <${YELLOW}jean\@phpnet.org${RESET}> ? - display this screen # - debug mode (toggle) 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) w - adjust the User and DB columns width a - toggle the progress column 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 =~ 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<https://mariadb.org/>. And older (the original) version B<mytop> is available from http://www.mysqlfanboy.com/mytop-3/ 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 * Getopt::Long * DBI and DBD::MariaDB or 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 10.5.0 on localhost load (3.89 3.86 3.91) up 7+23:56:31 [16:33:01] Queries: 353.4M qps: 531 Slow: 4.5k Se/In/Up/De(%): 87/02/02/00 Sorts: 2390 qps now: 651 Slow qps: 0.0 Threads: 11 ( 1/ 13) 88/01/03/00 Handler: (R/W/U/D) 82138/ 5884/ 20/ 1 Tmp: R/W/U: 13623/29501/ 79 MyISAM Key Cache Efficiency: 99.9% Bps in/out: 157.4k/ 2.2M Now in/out: 554.8k/ 2.6M The first line identifies the hostname of the server (localhost) and the version of MariaDB it is running. The right hand 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: B<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/MySQL, you may wish to have it use the MariaDB/MySQL 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. =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. It'd be nice if you could just add B<mytop> configuration directives in your C<my.cnf> file instead of having a separate config file. 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 MariaDB manual if you're not sure where some of the output of B<mytop> is coming from. =head1 COPYRIGHT Copyright (C) 2000-2010, Jeremy D. Zawodny. =head1 CREDITS Fix a bug. Add a feature. See your name here! Many thanks go to these fine folks: =over =item Jean Weisbuch (jean@phpnet.org) Added --fullqueries and --sort options, dynamic user and database columns width, reading of .my.cnf, state/progress column that can be disabled dynamically (when available) and various small fixes. =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. =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) Minor 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 incorrect 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. =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__