Linux server19.dn-server.com 3.10.0-962.3.2.lve1.5.88.el7.x86_64 #1 SMP Fri Sep 26 14:06:42 UTC 2025 x86_64
LiteSpeed
Server IP : 46.209.20.154 & Your IP : 216.73.217.55
Domains :
Cant Read [ /etc/named.conf ]
User : emadteam
Terminal
Auto Root
Create File
Create Folder
Localroot Suggester
Backdoor Destroyer
Readme
/
usr /
bin /
Delete
Unzip
Name
Size
Permission
Date
Action
GET
14.71
KB
-rwxr-xr-x
2014-06-10 05:49
Mail
383.67
KB
-rwxr-xr-x
2018-04-11 11:37
[
40.52
KB
-rwxr-xr-x
2020-11-17 01:54
a2p
105.32
KB
-rwxr-xr-x
2021-02-02 20:03
aclocal
35.87
KB
-rwxr-xr-x
2014-06-10 12:33
aclocal-1.13
35.87
KB
-rwxr-xr-x
2014-06-10 12:33
addr2line
28.42
KB
-rwxr-xr-x
2025-03-10 23:10
agentxtrap
19.16
KB
-rwxr-xr-x
2024-01-29 10:30
animate
7.05
KB
-rwxr-xr-x
2023-10-25 10:53
ar
61.21
KB
-rwxr-xr-x
2025-03-10 23:10
arch
32.3
KB
-rwxr-xr-x
2020-11-17 01:54
as
377.28
KB
-rwxr-xr-x
2025-03-10 23:10
aspell
163.35
KB
-rwxr-xr-x
2014-09-11 18:09
at
1.01
KB
-rwxr-xr-x
2022-05-19 11:25
atq
1.01
KB
-rwxr-xr-x
2022-05-19 11:25
atrm
1.02
KB
-rwxr-xr-x
2022-05-19 11:25
autoconf
14.42
KB
-rwxr-xr-x
2014-06-10 10:11
autoheader
8.33
KB
-rwxr-xr-x
2014-06-10 10:11
autom4te
31.43
KB
-rwxr-xr-x
2014-06-10 10:11
automake
246.44
KB
-rwxr-xr-x
2014-06-10 12:33
automake-1.13
246.44
KB
-rwxr-xr-x
2014-06-10 12:33
autoreconf
20.57
KB
-rwxr-xr-x
2014-06-10 10:11
autoscan
16.72
KB
-rwxr-xr-x
2014-06-10 10:11
autoupdate
33.08
KB
-rwxr-xr-x
2014-06-10 10:11
awk
418.54
KB
-rwxr-xr-x
2017-06-29 02:22
base64
36.48
KB
-rwxr-xr-x
2020-11-17 01:54
basename
28.35
KB
-rwxr-xr-x
2020-11-17 01:54
bash
941.93
KB
-rwxr-xr-x
2021-11-24 10:36
bashbug-64
6.8
KB
-rwxr-xr-x
2021-11-24 10:36
batch
137
B
-rwxr-xr-x
2022-05-19 11:25
bison
393.34
KB
-rwxr-xr-x
2018-10-31 00:04
bunzip2
31.89
KB
-rwxr-xr-x
2015-11-20 08:34
bzcat
31.89
KB
-rwxr-xr-x
2015-11-20 08:34
bzcmp
2.08
KB
-rwxr-xr-x
2015-11-20 08:34
bzdiff
2.08
KB
-rwxr-xr-x
2015-11-20 08:34
bzgrep
1.64
KB
-rwxr-xr-x
2015-11-20 08:34
bzip2
31.89
KB
-rwxr-xr-x
2015-11-20 08:34
bzip2recover
15.24
KB
-rwxr-xr-x
2015-11-20 08:34
bzless
1.23
KB
-rwxr-xr-x
2015-11-20 08:34
bzmore
1.23
KB
-rwxr-xr-x
2015-11-20 08:34
c++
754.59
KB
-rwxr-x---
2025-06-09 20:35
c++filt
27.92
KB
-rwxr-xr-x
2025-03-10 23:10
c2ph
35.75
KB
-rwxr-xr-x
2021-02-02 20:02
c89
224
B
-rwxr-x---
2025-06-09 20:35
c99
215
B
-rwxr-x---
2025-06-09 20:35
cagefs_enter.proxied
1.03
KB
-rwxr-xr-x
2025-05-26 14:41
cal
36.8
KB
-rwxr-xr-x
2021-02-02 20:01
captoinfo
64.26
KB
-rwxr-xr-x
2017-09-07 02:38
cat
52.81
KB
-rwxr-xr-x
2020-11-17 01:54
catchsegv
3.26
KB
-rwxr-xr-x
2025-09-18 12:58
cc
750.58
KB
-rwxr-x---
2025-06-09 20:35
chcon
61.46
KB
-rwxr-xr-x
2020-11-17 01:54
chgrp
61.32
KB
-rwxr-xr-x
2020-11-17 01:54
chmod
57.21
KB
-rwxr-xr-x
2020-11-17 01:54
chown
61.36
KB
-rwxr-xr-x
2020-11-17 01:54
chrt
32.17
KB
-rwxr-xr-x
2021-02-02 20:01
cksum
32.38
KB
-rwxr-xr-x
2020-11-17 01:54
cldetect
10.34
KB
-rwxr-xr-x
2025-11-13 13:22
clear
7.02
KB
-rwxr-xr-x
2017-09-07 02:38
cloudlinux-awp-user
1.78
KB
-rwxr-xr-x
2025-12-22 18:29
clwpos-user
1.78
KB
-rwxr-xr-x
2025-12-22 18:29
cmp
44.14
KB
-rwxr-xr-x
2023-03-08 10:44
col
23.88
KB
-rwxr-xr-x
2021-02-02 20:01
colcrt
11.29
KB
-rwxr-xr-x
2021-02-02 20:01
colrm
23.77
KB
-rwxr-xr-x
2021-02-02 20:01
column
27.99
KB
-rwxr-xr-x
2021-02-02 20:01
comm
36.55
KB
-rwxr-xr-x
2020-11-17 01:54
compare
11.09
KB
-rwxr-xr-x
2023-10-25 10:53
composite
7.05
KB
-rwxr-xr-x
2023-10-25 10:53
conjure
7.05
KB
-rwxr-xr-x
2023-10-25 10:53
convert
7.05
KB
-rwxr-xr-x
2023-10-25 10:53
cp
151.55
KB
-rwxr-xr-x
2020-11-17 01:54
cpan
8.15
KB
-r-xr-xr-x
2021-08-18 16:17
cpp
754.58
KB
-rwxr-xr-x
2025-06-09 20:35
crontab
1.49
KB
-rwxr-xr-x
2023-04-26 10:28
crontab.cagefs
49.12
KB
-rwxr-xr-x
2025-11-05 12:59
csplit
48.82
KB
-rwxr-xr-x
2020-11-17 01:54
curl
152.99
KB
-rwxr-xr-x
2023-12-20 15:05
cut
40.61
KB
-rwxr-xr-x
2020-11-17 01:54
date
60.74
KB
-rwxr-xr-x
2020-11-17 01:54
dbiprof
6.15
KB
-rwxr-xr-x
2014-06-10 05:36
dbiproxy
5.35
KB
-rwxr-xr-x
2014-06-10 05:36
dd
73.14
KB
-rwxr-xr-x
2020-11-17 01:54
delv
39.98
KB
-rwxr-xr-x
2025-03-04 13:54
df
102.55
KB
-rwxr-xr-x
2020-11-17 01:54
diff
195.46
KB
-rwxr-xr-x
2023-03-08 10:44
diff3
60.65
KB
-rwxr-xr-x
2023-03-08 10:44
dig
146.96
KB
-rwxr-xr-x
2025-03-04 13:54
dir
114.85
KB
-rwxr-xr-x
2020-11-17 01:54
dircolors
40.44
KB
-rwxr-xr-x
2020-11-17 01:54
dirname
28.31
KB
-rwxr-xr-x
2020-11-17 01:54
display
7.05
KB
-rwxr-xr-x
2023-10-25 10:53
dltest
11.05
KB
-rwxr-xr-x
2019-08-09 07:42
du
110.34
KB
-rwxr-xr-x
2020-11-17 01:54
dvipdf
1
KB
-rwxr-xr-x
2020-09-30 19:50
echo
32.31
KB
-rwxr-xr-x
2020-11-17 01:54
egrep
290
B
-rwxr-xr-x
2017-08-03 11:28
enchant
15.29
KB
-rwxr-xr-x
2014-06-09 23:16
enchant-lsmod
11.13
KB
-rwxr-xr-x
2014-06-09 23:16
env
28.33
KB
-rwxr-xr-x
2020-11-17 01:54
eps2eps
639
B
-rwxr-xr-x
2020-09-30 19:50
eqn
144.41
KB
-rwxr-xr-x
2014-06-10 00:47
ex
906.45
KB
-rwxr-xr-x
2020-12-15 20:14
expand
32.48
KB
-rwxr-xr-x
2020-11-17 01:54
expr
36.53
KB
-rwxr-xr-x
2020-11-17 01:54
factor
93.29
KB
-rwxr-xr-x
2020-11-17 01:54
false
28.25
KB
-rwxr-xr-x
2020-11-17 01:54
fc-cache
132
B
-rwxr-xr-x
2018-10-30 18:43
fc-cache-64
15.45
KB
-rwxr-xr-x
2018-10-30 22:04
fc-cat
15.4
KB
-rwxr-xr-x
2018-10-30 22:04
fc-conflist
11.2
KB
-rwxr-xr-x
2018-10-30 22:04
fc-list
11.26
KB
-rwxr-xr-x
2018-10-30 22:04
fc-match
11.32
KB
-rwxr-xr-x
2018-10-30 22:04
fc-pattern
11.26
KB
-rwxr-xr-x
2018-10-30 22:04
fc-query
11.23
KB
-rwxr-xr-x
2018-10-30 22:04
fc-scan
11.27
KB
-rwxr-xr-x
2018-10-30 22:04
fc-validate
11.27
KB
-rwxr-xr-x
2018-10-30 22:04
fgrep
290
B
-rwxr-xr-x
2017-08-03 11:28
file
19.3
KB
-rwxr-xr-x
2020-09-30 19:38
find
194.63
KB
-rwxr-xr-x
2018-10-30 20:12
find2perl
23.06
KB
-rwxr-xr-x
2021-02-02 20:02
flex
318.07
KB
-rwxr-xr-x
2018-10-31 00:00
flex++
318.07
KB
-rwxr-xr-x
2018-10-31 00:00
flock
23.88
KB
-rwxr-xr-x
2021-02-02 20:01
fmt
36.48
KB
-rwxr-xr-x
2020-11-17 01:54
fold
36.46
KB
-rwxr-xr-x
2020-11-17 01:54
free
19.33
KB
-rwxr-xr-x
2020-09-30 20:51
freetype-config
4.39
KB
-rwxr-xr-x
2020-11-06 17:41
funzip
31.38
KB
-rwxr-xr-x
2022-01-12 11:06
g++
754.59
KB
-rwxr-x---
2025-06-09 20:35
gawk
418.54
KB
-rwxr-xr-x
2017-06-29 02:22
gcc
750.58
KB
-rwxr-x---
2025-06-09 20:35
gcc-ar
26.45
KB
-rwxr-xr-x
2025-06-09 20:35
gcc-nm
26.45
KB
-rwxr-xr-x
2025-06-09 20:35
gcc-ranlib
26.45
KB
-rwxr-xr-x
2025-06-09 20:35
gcov
311.45
KB
-rwxr-xr-x
2025-06-09 20:35
gem
542
B
-rwxr-xr-x
2022-04-06 12:08
gencat
22.11
KB
-rwxr-xr-x
2025-09-18 13:51
geoiplookup
15.28
KB
-rwxr-xr-x
2019-08-09 04:04
geoiplookup6
11.16
KB
-rwxr-xr-x
2019-08-09 04:04
geqn
144.41
KB
-rwxr-xr-x
2014-06-10 00:47
getconf
22.02
KB
-rwxr-xr-x
2025-09-18 13:51
getent
26.39
KB
-rwxr-xr-x
2025-09-18 13:51
getopt
15.38
KB
-rwxr-xr-x
2021-02-02 20:01
ghostscript
10.97
KB
-rwxr-xr-x
2020-09-30 19:51
git
1.46
MB
-rwxr-xr-x
2025-09-29 16:47
git-receive-pack
1.46
MB
-rwxr-xr-x
2025-09-29 16:47
git-shell
722.02
KB
-rwxr-xr-x
2025-09-29 16:47
git-upload-archive
1.46
MB
-rwxr-xr-x
2025-09-29 16:47
git-upload-pack
795.48
KB
-rwxr-xr-x
2025-09-29 16:47
gm
6.98
KB
-rwxr-xr-x
2022-03-28 20:20
gmake
178.47
KB
-rwxr-xr-x
2019-08-09 05:16
gneqn
271
B
-rwxr-xr-x
2014-06-10 00:47
gnroff
3.31
KB
-rwxr-xr-x
2014-06-10 00:47
gpg
732.4
KB
-rwxr-xr-x
2018-07-13 17:35
gpg-agent
289.74
KB
-rwxr-xr-x
2018-07-13 17:35
gpg-error
23.18
KB
-rwxr-xr-x
2014-06-10 13:16
gpg-zip
3.23
KB
-rwxr-xr-x
2018-07-13 17:35
gpg2
732.4
KB
-rwxr-xr-x
2018-07-13 17:35
gpgsplit
48.88
KB
-rwxr-xr-x
2018-07-13 17:35
gpgv
345.38
KB
-rwxr-xr-x
2018-07-13 17:35
gpgv2
345.38
KB
-rwxr-xr-x
2018-07-13 17:35
gpic
180.41
KB
-rwxr-xr-x
2014-06-10 00:47
gprof
98.41
KB
-rwxr-xr-x
2025-03-10 23:10
grep
155.3
KB
-rwxr-xr-x
2017-08-03 11:28
groff
81.63
KB
-rwxr-xr-x
2014-06-10 00:47
grops
140.85
KB
-rwxr-xr-x
2014-06-10 00:47
grotty
98.59
KB
-rwxr-xr-x
2014-06-10 00:47
groups
32.41
KB
-rwxr-xr-x
2020-11-17 01:54
gs
10.97
KB
-rwxr-xr-x
2020-09-30 19:51
gsbj
350
B
-rwxr-xr-x
2020-09-30 19:50
gsdj
352
B
-rwxr-xr-x
2020-09-30 19:50
gsdj500
352
B
-rwxr-xr-x
2020-09-30 19:50
gslj
353
B
-rwxr-xr-x
2020-09-30 19:50
gslp
350
B
-rwxr-xr-x
2020-09-30 19:50
gsnd
277
B
-rwxr-xr-x
2020-09-30 19:50
gsoelim
32.59
KB
-rwxr-xr-x
2014-06-10 00:47
gtar
338.02
KB
-rwxr-xr-x
2018-10-30 23:54
gtbl
115.96
KB
-rwxr-xr-x
2014-06-10 00:47
gtroff
512.96
KB
-rwxr-xr-x
2014-06-10 00:47
gunzip
2.2
KB
-rwxr-xr-x
2022-05-12 11:26
gzexe
5.79
KB
-rwxr-xr-x
2022-05-12 11:26
gzip
98.43
KB
-rwxr-xr-x
2022-05-12 11:26
h2ph
27.65
KB
-rwxr-xr-x
2021-02-02 20:02
h2xs
59.15
KB
-rwxr-xr-x
2021-02-02 20:02
head
40.51
KB
-rwxr-xr-x
2020-11-17 01:54
hexdump
32.02
KB
-rwxr-xr-x
2021-02-02 20:01
host
127.02
KB
-rwxr-xr-x
2025-03-04 13:54
hostid
28.32
KB
-rwxr-xr-x
2020-11-17 01:54
hostname
15.41
KB
-rwxr-xr-x
2019-10-18 19:32
hunspell
53.11
KB
-rwxr-xr-x
2020-09-30 20:05
iconv
58.14
KB
-rwxr-xr-x
2025-09-18 13:51
icu-config
172
B
-rwxr-xr-x
2014-08-18 23:43
icu-config-64
21.49
KB
-rwxr-xr-x
2020-03-25 19:17
icuinfo
15.6
KB
-rwxr-xr-x
2020-03-25 19:17
id
36.52
KB
-rwxr-xr-x
2020-11-17 01:54
identify
7.06
KB
-rwxr-xr-x
2023-10-25 10:53
idn
32.45
KB
-rwxr-xr-x
2015-11-21 20:30
ifnames
4.03
KB
-rwxr-xr-x
2014-06-10 10:11
igawk
3.11
KB
-rwxr-xr-x
2017-06-29 02:22
import
7.05
KB
-rwxr-xr-x
2023-10-25 10:53
infocmp
56.07
KB
-rwxr-xr-x
2017-09-07 02:38
infotocap
64.26
KB
-rwxr-xr-x
2017-09-07 02:38
install
139.59
KB
-rwxr-xr-x
2020-11-17 01:54
instmodsh
4.15
KB
-rwxr-xr-x
2014-06-10 06:28
ionice
23.86
KB
-rwxr-xr-x
2021-02-02 20:01
ipcrm
27.85
KB
-rwxr-xr-x
2021-02-02 20:01
ipcs
48.37
KB
-rwxr-xr-x
2021-02-02 20:01
isosize
23.83
KB
-rwxr-xr-x
2021-02-02 20:01
ispell
988
B
-rwxr-xr-x
2014-09-11 18:09
isql
31.69
KB
-rwxr-xr-x
2019-08-09 07:42
iusql
23.61
KB
-rwxr-xr-x
2019-08-09 07:42
join
48.75
KB
-rwxr-xr-x
2020-11-17 01:54
kill
32.82
KB
-rwxr-xr-x
2021-02-02 20:01
ld
982.59
KB
-rwxr-x---
2025-03-10 23:10
ld.bfd
982.59
KB
-rwxr-x---
2025-03-10 23:10
ldd
5.18
KB
-rwxr-xr-x
2025-09-18 12:59
less
154.57
KB
-rwxr-xr-x
2024-06-17 12:41
lessecho
11.13
KB
-rwxr-xr-x
2024-06-17 12:41
lesskey
16.67
KB
-rwxr-xr-x
2024-06-17 12:41
lesspipe.sh
2.24
KB
-rwxr-xr-x
2024-04-30 16:05
lex
318.07
KB
-rwxr-xr-x
2018-10-31 00:00
libnetcfg
15.36
KB
-rwxr-xr-x
2021-02-02 20:02
libtool
314.04
KB
-rwxr-xr-x
2017-04-12 23:27
libtoolize
76.8
KB
-rwxr-xr-x
2017-04-12 23:27
link
28.3
KB
-rwxr-xr-x
2020-11-17 01:54
ln
57.22
KB
-rwxr-xr-x
2020-11-17 01:54
locale
37.11
KB
-rwxr-xr-x
2025-09-18 13:51
localedef
318.31
KB
-rwxr-xr-x
2025-09-18 13:51
logger
28.62
KB
-rwxr-xr-x
2021-02-02 20:01
login
36.38
KB
-rwxr-xr-x
2021-02-02 20:01
logname
28.31
KB
-rwxr-xr-x
2020-11-17 01:54
look
11.27
KB
-rwxr-xr-x
2021-02-02 20:01
lprsetup.sh
5.34
KB
-rwxr-xr-x
2020-09-30 19:50
ls
114.85
KB
-rwxr-xr-x
2020-11-17 01:54
m4
151.17
KB
-rwxr-xr-x
2015-11-20 10:57
mail
383.67
KB
-rwxr-xr-x
2018-04-11 11:37
mailx
383.67
KB
-rwxr-xr-x
2018-04-11 11:37
make
178.47
KB
-rwxr-xr-x
2019-08-09 05:16
mariadb
4.33
MB
-rwxr-xr-x
2024-11-13 03:07
mariadb-access
109.33
KB
-rwxr-xr-x
2024-11-13 03:03
mariadb-admin
3.85
MB
-rwxr-xr-x
2024-11-13 03:07
mariadb-binlog
4.14
MB
-rwxr-xr-x
2024-11-13 03:07
mariadb-check
3.85
MB
-rwxr-xr-x
2024-11-13 03:07
mariadb-conv
3.59
MB
-rwxr-xr-x
2024-11-13 03:07
mariadb-convert-table-format
4.12
KB
-rwxr-xr-x
2024-11-13 03:03
mariadb-dump
3.93
MB
-rwxr-xr-x
2024-11-13 03:07
mariadb-dumpslow
8.05
KB
-rwxr-xr-x
2024-11-13 03:03
mariadb-embedded
22.87
MB
-rwxr-xr-x
2024-11-13 03:07
mariadb-find-rows
3.21
KB
-rwxr-xr-x
2024-11-13 03:03
mariadb-hotcopy
34.15
KB
-rwxr-xr-x
2024-11-13 03:03
mariadb-import
3.84
MB
-rwxr-xr-x
2024-11-13 03:07
mariadb-plugin
3.55
MB
-rwxr-xr-x
2024-11-13 03:07
mariadb-secure-installation
13.48
KB
-rwxr-xr-x
2024-11-13 03:03
mariadb-setpermission
17.56
KB
-rwxr-xr-x
2024-11-13 03:03
mariadb-show
3.84
MB
-rwxr-xr-x
2024-11-13 03:07
mariadb-slap
3.85
MB
-rwxr-xr-x
2024-11-13 03:07
mariadb-tzinfo-to-sql
3.54
MB
-rwxr-xr-x
2024-11-13 03:07
mariadb-waitpid
3.54
MB
-rwxr-xr-x
2024-11-13 03:07
mcookie
15.44
KB
-rwxr-xr-x
2021-02-02 20:01
md5sum
40.53
KB
-rwxr-xr-x
2020-11-17 01:54
mdig
44.2
KB
-rwxr-xr-x
2025-03-04 13:54
mesg
10.98
KB
-rwxr-xr-x
2014-06-10 03:46
mkdir
77.9
KB
-rwxr-xr-x
2020-11-17 01:54
mkfifo
61.59
KB
-rwxr-xr-x
2020-11-17 01:54
mknod
65.61
KB
-rwxr-xr-x
2020-11-17 01:54
mktemp
40.66
KB
-rwxr-xr-x
2020-11-17 01:54
mogrify
7.05
KB
-rwxr-xr-x
2023-10-25 10:53
montage
7.05
KB
-rwxr-xr-x
2023-10-25 10:53
more
40.15
KB
-rwxr-xr-x
2021-02-02 20:01
msql2mysql
1.41
KB
-rwxr-xr-x
2024-11-13 03:03
mv
127.3
KB
-rwxr-xr-x
2020-11-17 01:54
my_print_defaults
3.54
MB
-rwxr-xr-x
2024-11-13 03:07
mysql
4.33
MB
-rwxr-xr-x
2024-11-13 03:07
mysql_config
4.58
KB
-rwxr-xr-x
2024-11-13 03:03
mysql_find_rows
3.21
KB
-rwxr-xr-x
2024-11-13 03:03
mysql_waitpid
3.54
MB
-rwxr-xr-x
2024-11-13 03:07
mysqlaccess
109.33
KB
-rwxr-xr-x
2024-11-13 03:03
mysqladmin
3.85
MB
-rwxr-xr-x
2024-11-13 03:07
mysqlbinlog
4.14
MB
-rwxr-xr-x
2024-11-13 03:07
mysqlcheck
3.85
MB
-rwxr-xr-x
2024-11-13 03:07
mysqldump
3.93
MB
-rwxr-xr-x
2024-11-13 03:07
mysqlimport
3.84
MB
-rwxr-xr-x
2024-11-13 03:07
mysqlshow
3.84
MB
-rwxr-xr-x
2024-11-13 03:07
mytop
71.96
KB
-rwxr-xr-x
2024-11-13 03:03
namei
27.95
KB
-rwxr-xr-x
2021-02-02 20:01
nano
201.08
KB
-rwxr-xr-x
2014-06-10 09:17
neqn
271
B
-rwxr-xr-x
2014-06-10 00:47
net-snmp-create-v3-user
2.98
KB
-rwxr-xr-x
2024-01-29 10:30
nice
32.32
KB
-rwxr-xr-x
2020-11-17 01:54
nl
40.6
KB
-rwxr-xr-x
2020-11-17 01:54
nm
45.43
KB
-rwxr-xr-x
2025-03-10 23:10
nohup
32.42
KB
-rwxr-xr-x
2020-11-17 01:54
nproc
32.37
KB
-rwxr-xr-x
2020-11-17 01:54
nroff
3.31
KB
-rwxr-xr-x
2014-06-10 00:47
nslookup
130.93
KB
-rwxr-xr-x
2025-03-04 13:54
nsupdate
65.2
KB
-rwxr-xr-x
2025-03-04 13:54
numfmt
64.71
KB
-rwxr-xr-x
2020-11-17 01:54
objcopy
227.34
KB
-rwxr-xr-x
2025-03-10 23:10
objdump
357.75
KB
-rwxr-xr-x
2025-03-10 23:10
od
64.81
KB
-rwxr-xr-x
2020-11-17 01:54
odbc_config
11.04
KB
-rwxr-xr-x
2019-08-09 07:42
odbcinst
27.69
KB
-rwxr-xr-x
2019-08-09 07:42
openssl
542.27
KB
-rwxr-xr-x
2025-10-08 16:52
pango-list
11.1
KB
-rwxr-xr-x
2019-09-13 22:33
pango-querymodules-64
28.26
KB
-rwxr-xr-x
2020-11-17 01:54
pango-view
49.47
KB
-rwxr-xr-x
2019-09-13 22:33
passwd
1.02
KB
-rwxr-xr-x
2020-04-01 08:27
paste
32.34
KB
-rwxr-xr-x
2020-11-17 01:54
patch
147
KB
-rwxr-xr-x
2019-10-23 03:29
pathchk
32.31
KB
-rwxr-xr-x
2020-11-17 01:54
pdf2dsc
698
B
-rwxr-xr-x
2020-09-30 19:50
pdf2ps
909
B
-rwxr-xr-x
2020-09-30 19:50
perl
11.14
KB
-rwxr-xr-x
2021-02-02 20:03
perl5.16.3
11.14
KB
-rwxr-xr-x
2021-02-02 20:03
perlbug
43.61
KB
-rwxr-xr-x
2021-02-02 20:02
perldoc
203
B
-rwxr-xr-x
2014-06-10 12:47
perlivp
10.52
KB
-rwxr-xr-x
2021-02-02 20:02
perlml
5.98
KB
-rwxr-xr-x
2022-08-11 01:25
perlthanks
43.61
KB
-rwxr-xr-x
2021-02-02 20:02
pf2afm
498
B
-rwxr-xr-x
2020-09-30 19:50
pfbtopfa
516
B
-rwxr-xr-x
2020-09-30 19:50
pgawk
418.63
KB
-rwxr-xr-x
2017-06-29 02:22
pgrep
27.67
KB
-rwxr-xr-x
2020-09-30 20:51
php
937
B
-rwxr-xr-x
2025-04-03 14:18
pic
180.41
KB
-rwxr-xr-x
2014-06-10 00:47
piconv
7.99
KB
-rwxr-xr-x
2014-06-10 07:19
pinentry
2.54
KB
-rwxr-xr-x
2016-11-04 21:32
pinentry-curses
49.19
KB
-rwxr-xr-x
2016-11-05 19:19
ping
1.02
KB
-rwxr-xr-x
2017-08-04 12:31
pinky
36.57
KB
-rwxr-xr-x
2020-11-17 01:54
pkg-config
44.38
KB
-rwxr-xr-x
2014-06-10 02:35
pkill
27.67
KB
-rwxr-xr-x
2020-09-30 20:51
pl2pm
4.42
KB
-rwxr-xr-x
2021-02-02 20:02
pmap
27.61
KB
-rwxr-xr-x
2020-09-30 20:51
pod2html
4
KB
-rwxr-xr-x
2021-02-02 20:02
pod2latex
10.1
KB
-rwxr-xr-x
2014-06-10 12:23
pod2man
13.26
KB
-rwxr-xr-x
2014-06-10 00:26
pod2text
10.75
KB
-rwxr-xr-x
2014-06-10 00:26
pod2usage
3.67
KB
-rwxr-xr-x
2014-06-10 13:26
podchecker
3.7
KB
-rwxr-xr-x
2014-06-10 00:58
podselect
2.55
KB
-rwxr-xr-x
2014-06-10 08:34
post-grohtml
187.55
KB
-rwxr-xr-x
2014-06-10 00:47
pphs
404
B
-rwxr-xr-x
2020-09-30 19:50
pr
65.11
KB
-rwxr-xr-x
2020-11-17 01:54
pre-grohtml
86.24
KB
-rwxr-xr-x
2014-06-10 00:47
precat
5.52
KB
-rwxr-xr-x
2014-09-11 18:09
preunzip
5.52
KB
-rwxr-xr-x
2014-09-11 18:09
prezip
5.52
KB
-rwxr-xr-x
2014-09-11 18:09
prezip-bin
11.05
KB
-rwxr-xr-x
2014-09-11 18:09
printafm
395
B
-rwxr-xr-x
2020-09-30 19:50
printenv
28.28
KB
-rwxr-xr-x
2020-11-17 01:54
printf
48.61
KB
-rwxr-xr-x
2020-11-17 01:54
prove
13.13
KB
-rwxr-xr-x
2015-08-12 18:52
ps
97.77
KB
-rwxr-xr-x
2020-09-30 20:51
ps2ascii
631
B
-rwxr-xr-x
2020-09-30 19:50
ps2epsi
2.69
KB
-rwxr-xr-x
2020-09-30 19:50
ps2pdf
272
B
-rwxr-xr-x
2020-09-30 19:50
ps2pdf12
215
B
-rwxr-xr-x
2020-09-30 19:50
ps2pdf13
215
B
-rwxr-xr-x
2020-09-30 19:50
ps2pdf14
215
B
-rwxr-xr-x
2020-09-30 19:50
ps2pdfwr
1.07
KB
-rwxr-xr-x
2020-09-30 19:50
ps2ps
647
B
-rwxr-xr-x
2020-09-30 19:50
ps2ps2
669
B
-rwxr-xr-x
2020-09-30 19:50
psed
52.08
KB
-rwxr-xr-x
2021-02-02 20:02
pstruct
35.75
KB
-rwxr-xr-x
2021-02-02 20:02
ptx
65.08
KB
-rwxr-xr-x
2020-11-17 01:54
pwd
32.45
KB
-rwxr-xr-x
2020-11-17 01:54
pwdx
11.27
KB
-rwxr-xr-x
2020-09-30 20:51
pydoc
78
B
-rwxr-xr-x
2025-11-12 17:54
python
6.98
KB
-rwxr-xr-x
2025-11-12 17:55
python2
6.98
KB
-rwxr-xr-x
2025-11-12 17:55
python2.7
6.98
KB
-rwxr-xr-x
2025-11-12 17:55
ranlib
61.21
KB
-rwxr-xr-x
2025-03-10 23:10
raw
15.27
KB
-rwxr-xr-x
2021-02-02 20:01
readelf
509.84
KB
-rwxr-xr-x
2025-03-10 23:10
readlink
40.82
KB
-rwxr-xr-x
2020-11-17 01:54
realpath
61.23
KB
-rwxr-xr-x
2020-11-17 01:54
recode
39.87
KB
-rwxr-xr-x
2014-09-18 00:48
rename
11.26
KB
-rwxr-xr-x
2021-02-02 20:01
renice
11.21
KB
-rwxr-xr-x
2021-02-02 20:01
replace
3.52
MB
-rwxr-xr-x
2024-11-13 03:07
reset
19.6
KB
-rwxr-xr-x
2017-09-07 02:38
rev
11.26
KB
-rwxr-xr-x
2021-02-02 20:01
rm
61.4
KB
-rwxr-xr-x
2020-11-17 01:54
rmdir
44.46
KB
-rwxr-xr-x
2020-11-17 01:54
rnano
201.08
KB
-rwxr-xr-x
2014-06-10 09:17
rpcgen
90.45
KB
-rwxr-xr-x
2025-09-18 13:51
ruby
7.02
KB
-rwxr-xr-x
2022-04-06 12:43
run-with-aspell
85
B
-rwxr-xr-x
2014-09-11 18:09
runcon
32.47
KB
-rwxr-xr-x
2020-11-17 01:54
rvi
906.45
KB
-rwxr-xr-x
2020-12-15 20:14
rview
906.45
KB
-rwxr-xr-x
2020-12-15 20:14
s2p
52.08
KB
-rwxr-xr-x
2021-02-02 20:02
scl
19.5
KB
-rwxr-xr-x
2018-10-30 22:47
scl_enabled
258
B
-rwxr-xr-x
2018-10-30 22:47
scl_source
1.83
KB
-rwxr-xr-x
2018-10-30 22:47
scp
89.24
KB
-rwxr-xr-x
2025-06-10 10:18
screen
464.1
KB
-rwxr-xr-x
2021-03-09 18:56
script
19.61
KB
-rwxr-xr-x
2021-02-02 20:01
sdiff
48.41
KB
-rwxr-xr-x
2023-03-08 10:44
sed
74.29
KB
-rwxr-xr-x
2020-09-30 21:05
selectorctl
7.63
KB
-rwxr-xr-x
2025-11-28 18:24
seq
48.48
KB
-rwxr-xr-x
2020-11-17 01:54
setsid
11.23
KB
-rwxr-xr-x
2021-02-02 20:01
setterm
27.48
KB
-rwxr-xr-x
2021-02-02 20:01
sftp
142.02
KB
-rwxr-xr-x
2025-06-10 10:18
sh
941.93
KB
-rwxr-xr-x
2021-11-24 10:36
sha1sum
36.57
KB
-rwxr-xr-x
2020-11-17 01:54
sha224sum
40.63
KB
-rwxr-xr-x
2020-11-17 01:54
sha256sum
40.63
KB
-rwxr-xr-x
2020-11-17 01:54
sha384sum
40.65
KB
-rwxr-xr-x
2020-11-17 01:54
sha512sum
40.65
KB
-rwxr-xr-x
2020-11-17 01:54
shred
52.94
KB
-rwxr-xr-x
2020-11-17 01:54
shuf
49.13
KB
-rwxr-xr-x
2020-11-17 01:54
size
32.35
KB
-rwxr-xr-x
2025-03-10 23:10
skill
23.62
KB
-rwxr-xr-x
2020-09-30 20:51
slabtop
19.52
KB
-rwxr-xr-x
2020-09-30 20:51
sleep
32.35
KB
-rwxr-xr-x
2020-11-17 01:54
slogin
760.44
KB
-rwxr-xr-x
2025-06-10 10:18
snice
23.62
KB
-rwxr-xr-x
2020-09-30 20:51
snmpconf
25.52
KB
-rwxr-xr-x
2024-01-29 10:30
soelim
32.59
KB
-rwxr-xr-x
2014-06-10 00:47
sort
114.94
KB
-rwxr-xr-x
2020-11-17 01:54
spell
122
B
-rwxr-xr-x
2014-09-11 18:09
splain
18.03
KB
-rwxr-xr-x
2021-02-02 20:02
split
69.47
KB
-rwxr-xr-x
2020-11-17 01:54
sprof
22.1
KB
-rwxr-xr-x
2025-09-18 13:51
sqlite3
54.95
KB
-rwxr-xr-x
2025-08-04 16:57
ssh
760.44
KB
-rwxr-xr-x
2025-06-10 10:18
ssh-add
348.48
KB
-rwxr-xr-x
2025-06-10 10:18
ssh-agent
373.25
KB
---x--x--x
2025-06-10 10:18
ssh-copy-id
10.22
KB
-rwxr-xr-x
2025-06-10 10:18
ssh-keygen
409.4
KB
-rwxr-xr-x
2025-06-10 10:18
ssh-keyscan
434.7
KB
-rwxr-xr-x
2025-06-10 10:18
stat
77.19
KB
-rwxr-xr-x
2020-11-17 01:54
stdbuf
64.88
KB
-rwxr-xr-x
2020-11-17 01:54
strace
1009.19
KB
-rwxr-xr-x
2023-08-30 12:28
stream
7.05
KB
-rwxr-xr-x
2023-10-25 10:53
strings
36.53
KB
-rwxr-xr-x
2025-03-10 23:10
strip
227.32
KB
-rwxr-xr-x
2025-03-10 23:10
stty
68.61
KB
-rwxr-xr-x
2020-11-17 01:54
sum
36.55
KB
-rwxr-xr-x
2020-11-17 01:54
sync
28.33
KB
-rwxr-xr-x
2020-11-17 01:54
tabs
15.31
KB
-rwxr-xr-x
2017-09-07 02:38
tac
32.48
KB
-rwxr-xr-x
2020-11-17 01:54
tail
65.25
KB
-rwxr-xr-x
2020-11-17 01:54
tailf
23.88
KB
-rwxr-xr-x
2021-02-02 20:01
tar
338.02
KB
-rwxr-xr-x
2018-10-30 23:54
taskset
32.22
KB
-rwxr-xr-x
2021-02-02 20:01
tbl
115.96
KB
-rwxr-xr-x
2014-06-10 00:47
tclsh
7
KB
-rwxr-xr-x
2015-11-20 12:10
tclsh8.5
7
KB
-rwxr-xr-x
2015-11-20 12:10
tee
32.38
KB
-rwxr-xr-x
2020-11-17 01:54
test
36.46
KB
-rwxr-xr-x
2020-11-17 01:54
tic
64.26
KB
-rwxr-xr-x
2017-09-07 02:38
timeout
53.31
KB
-rwxr-xr-x
2020-11-17 01:54
tload
15.38
KB
-rwxr-xr-x
2020-09-30 20:51
tmpwatch
27.87
KB
-rwxr-xr-x
2019-06-09 14:12
toe
15.43
KB
-rwxr-xr-x
2017-09-07 02:38
top
104.38
KB
-rwxr-xr-x
2020-09-30 20:51
touch
61.02
KB
-rwxr-xr-x
2020-11-17 01:54
tput
15.41
KB
-rwxr-xr-x
2017-09-07 02:38
tr
44.61
KB
-rwxr-xr-x
2020-11-17 01:54
troff
512.96
KB
-rwxr-xr-x
2014-06-10 00:47
true
28.26
KB
-rwxr-xr-x
2020-11-17 01:54
truncate
52.68
KB
-rwxr-xr-x
2020-11-17 01:54
tset
19.6
KB
-rwxr-xr-x
2017-09-07 02:38
tsort
36.47
KB
-rwxr-xr-x
2020-11-17 01:54
tty
28.29
KB
-rwxr-xr-x
2020-11-17 01:54
tzselect
7.17
KB
-rwxr-xr-x
2025-09-18 12:58
uapi
1.02
KB
-rwxr-xr-x
2026-08-08 21:34
ul
19.47
KB
-rwxr-xr-x
2021-02-02 20:01
uname
32.3
KB
-rwxr-xr-x
2020-11-17 01:54
unexpand
32.45
KB
-rwxr-xr-x
2020-11-17 01:54
uniq
44.71
KB
-rwxr-xr-x
2020-11-17 01:54
unix-lpr.sh
4.07
KB
-rwxr-xr-x
2020-09-30 19:50
unlink
28.3
KB
-rwxr-xr-x
2020-11-17 01:54
unzip
185.16
KB
-rwxr-xr-x
2022-01-12 11:06
unzipsfx
88.66
KB
-rwxr-xr-x
2022-01-12 11:06
uptime
11.22
KB
-rwxr-xr-x
2020-09-30 20:51
users
32.42
KB
-rwxr-xr-x
2020-11-17 01:54
utmpdump
15.45
KB
-rwxr-xr-x
2021-02-02 20:01
vdir
114.85
KB
-rwxr-xr-x
2020-11-17 01:54
vi
906.45
KB
-rwxr-xr-x
2020-12-15 20:14
view
906.45
KB
-rwxr-xr-x
2020-12-15 20:14
vmstat
31.48
KB
-rwxr-xr-x
2020-09-30 20:51
watch
24.14
KB
-rwxr-xr-x
2020-09-30 20:51
wc
40.67
KB
-rwxr-xr-x
2020-11-17 01:54
wget
408.97
KB
-rwxr-xr-x
2024-08-15 13:50
whereis
20.2
KB
-rwxr-xr-x
2021-02-02 20:01
which
23.77
KB
-rwxr-xr-x
2014-06-10 06:55
who
48.7
KB
-rwxr-xr-x
2020-11-17 01:54
whoami
28.3
KB
-rwxr-xr-x
2020-11-17 01:54
word-list-compress
11.03
KB
-rwxr-xr-x
2014-09-11 18:09
x86_64-redhat-linux-c++
754.59
KB
-rwxr-x---
2025-06-09 20:35
x86_64-redhat-linux-g++
754.59
KB
-rwxr-x---
2025-06-09 20:35
x86_64-redhat-linux-gcc
750.58
KB
-rwxr-x---
2025-06-09 20:35
xargs
60.91
KB
-rwxr-xr-x
2018-10-30 20:12
xmlcatalog
15.3
KB
-rwxr-xr-x
2025-09-08 17:20
xmllint
61.94
KB
-rwxr-xr-x
2025-09-08 17:20
xmlwf
24
KB
-rwxr-xr-x
2024-09-16 17:45
xsltproc
23.51
KB
-rwxr-xr-x
2020-09-30 20:26
xsubpp
4.45
KB
-rwxr-xr-x
2017-08-02 10:13
yes
28.3
KB
-rwxr-xr-x
2020-11-17 01:54
zcat
1.9
KB
-rwxr-xr-x
2022-05-12 11:26
zcmp
1.72
KB
-rwxr-xr-x
2022-05-12 11:26
zdiff
5.63
KB
-rwxr-xr-x
2022-05-12 11:26
zegrep
123
B
-rwxr-xr-x
2022-05-12 11:26
zfgrep
123
B
-rwxr-xr-x
2022-05-12 11:26
zforce
2.09
KB
-rwxr-xr-x
2022-05-12 11:26
zgrep
5.98
KB
-rwxr-xr-x
2022-05-12 11:26
zip
210.78
KB
-rwxr-xr-x
2016-11-05 20:19
zipcloak
98.1
KB
-rwxr-xr-x
2016-11-05 20:19
zipgrep
2.88
KB
-rwxr-xr-x
2008-10-10 21:10
zipinfo
185.16
KB
-rwxr-xr-x
2022-01-12 11:06
zipnote
93.73
KB
-rwxr-xr-x
2016-11-05 20:19
zipsplit
97.75
KB
-rwxr-xr-x
2016-11-05 20:19
zless
1.99
KB
-rwxr-xr-x
2022-05-12 11:26
zmore
2.79
KB
-rwxr-xr-x
2022-05-12 11:26
znew
5.22
KB
-rwxr-xr-x
2022-05-12 11:26
zsoelim
32.59
KB
-rwxr-xr-x
2014-06-10 00:47
Save
Rename
#!/usr/bin/perl # Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. # # This program is free software; you can redistribute it and/or # modify it under the terms of the GNU Library General Public # License as published by the Free Software Foundation; version 2 # of the License. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU # Library General Public License for more details. # # You should have received a copy of the GNU Library General Public # License along with this library; if not, write to the Free # Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, # MA 02110-1335 USA # mysqldumpslow - parse and summarize the MySQL slow query log # Original version by Tim Bunce, sometime in 2000. # Further changes by Tim Bunce, 8th March 2001. # Handling of strings with \ and double '' by Monty 11 Aug 2001. use strict; use Getopt::Long; # t=time, l=lock time, r=rows, a=rows affected # at, al, ar and aa are the corresponding averages my %opt = ( s => 'at', h => '*', ); GetOptions(\%opt, 'v|verbose+',# verbose 'help+', # write usage info 'd|debug+', # debug 's=s', # what to sort by (aa, ae, al, ar, at, a, c, e, l, r, t) 'r!', # reverse the sort order (largest last instead of first) 't=i', # just show the top n queries 'a!', # don't abstract all numbers to N and strings to 'S' 'n=i', # abstract numbers with at least n digits within names 'g=s', # grep: only consider stmts that include this string 'h=s', # hostname/basename of db server for *-slow.log filename (can be wildcard) 'i=s', # name of server instance (if using mysql.server startup script) 'l!', # don't subtract lock time from total time ) or usage("bad option"); $opt{'help'} and usage(); unless (@ARGV) { my $defaults = `my_print_defaults --mysqld`; my $datadir = ($defaults =~ m/--datadir=(.*)/g)[-1]; if (!$datadir or $opt{i}) { # determine the datadir from the instances section of /etc/my.cnf, if any my $instances = `my_print_defaults instances`; die "Can't determine datadir from 'my_print_defaults instances' output: $defaults" unless $instances; my @instances = ($instances =~ m/^--(\w+)-/mg); die "No -i 'instance_name' specified to select among known instances: @instances.\n" unless $opt{i}; die "Instance '$opt{i}' is unknown (known instances: @instances)\n" unless grep { $_ eq $opt{i} } @instances; $datadir = ($instances =~ m/--$opt{i}-datadir=(.*)/g)[-1] or die "Can't determine --$opt{i}-datadir from 'my_print_defaults instances' output: $instances"; warn "datadir=$datadir\n" if $opt{v}; } my $slowlog = ($defaults =~ m/--log[-_]slow[-_]queries=(.*)/g)[-1]; if (!$slowlog) { $slowlog = ($defaults =~ m/--slow[-_]query[-_]log[-_]file=(.*)/g)[-1]; } if ( $slowlog ) { @ARGV = ($slowlog); die "Can't find '$slowlog'\n" unless @ARGV; } else { if (!$opt{h}) { $opt{h}= ($defaults =~ m/--log[-_]basename=(.*)/g)[-1]; } @ARGV = <$datadir/$opt{h}-slow.log>; die "Can't find '$datadir/$opt{h}-slow.log'\n" unless @ARGV; } } warn "\nReading mysql slow query log from @ARGV\n"; my @pending; my %stmt; $/ = ";\n#"; # read entire statements using paragraph mode while ( defined($_ = shift @pending) or defined($_ = <>) ) { warn "[[$_]]\n" if $opt{d}; # show raw paragraph being read my @chunks = split /^\/.*Version.*started with[\000-\377]*?Time.*Id.*Command.*Argument.*\n/m; if (@chunks > 1) { unshift @pending, map { length($_) ? $_ : () } @chunks; warn "<<".join(">>\n<<",@chunks).">>" if $opt{d}; next; } s/^#? Time: \d{6}\s+\d+:\d+:\d+.*\n//; my ($user,$host) = s/^#? User\@Host:\s+(\S+)\s+\@\s+(\S+).*\n// ? ($1,$2) : ('',''); s/^# Thread_id: [0-9]+\s+Schema: .*\s+QC_hit:.*[^\n]+\n//; s/^# Query_time: ([0-9.]+)\s+Lock_time: ([0-9.]+)\s+Rows_sent: ([0-9.]+)\s+Rows_examined: ([0-9.]+).*\n//; my ($t, $l, $r, $e) = ($1, $2, $3, $4); s/^# Rows_affected: ([0-9.]+).*\n//; my ($a) = ($1); $t -= $l unless $opt{l}; # remove fluff that mysqld writes to log when it (re)starts: s!^/.*Version.*started with:.*\n!!mg; s!^Tcp port: \d+ Unix socket: \S+\n!!mg; s!^Time.*Id.*Command.*Argument.*\n!!mg; # Remove optimizer info s!^# QC_Hit: \S+\s+Full_scan: \S+\s+Full_join: \S+\s+Tmp_table: \S+\s+Tmp_table_on_disk: \S+[^\n]+\n!!mg; s!^# Filesort: \S+\s+Filesort_on_disk: \S+[^\n]+\n!!mg; s!^# Full_scan: \S+\s+Full_join: \S+[^\n]+\n!!mg; s/^use \w+;\n//; # not consistently added s/^SET timestamp=\d+;\n//; s/^[ ]*\n//mg; # delete blank lines s/^[ ]*/ /mg; # normalize leading whitespace s/\s*;\s*(#\s*)?$//; # remove trailing semicolon(+newline-hash) next if $opt{g} and !m/$opt{g}/io; unless ($opt{a}) { s/\b\d+\b/N/g; s/\b0x[0-9A-Fa-f]+\b/N/g; s/''/'S'/g; s/""/"S"/g; s/(\\')//g; s/(\\")//g; s/'[^']+'/'S'/g; s/"[^"]+"/"S"/g; # -n=8: turn log_20001231 into log_NNNNNNNN s/([a-z_]+)(\d{$opt{n},})/$1.('N' x length($2))/ieg if $opt{n}; # abbreviate massive "in (...)" statements and similar s!(([NS],){100,})!sprintf("$2,{repeated %d times}",length($1)/2)!eg; } my $s = $stmt{$_} ||= { users=>{}, hosts=>{} }; $s->{c} += 1; $s->{t} += $t; $s->{l} += $l; $s->{r} += $r; $s->{e} += $e; $s->{a} += $a; $s->{users}->{$user}++ if $user; $s->{hosts}->{$host}++ if $host; warn "{{$_}}\n\n" if $opt{d}; # show processed statement string } foreach (keys %stmt) { my $v = $stmt{$_} || die; my ($c, $t, $l, $r, $e, $a) = @{ $v }{qw(c t l r e a)}; $v->{at} = $t / $c; $v->{al} = $l / $c; $v->{ar} = $r / $c; $v->{ae} = $e / $c; $v->{aa} = $a / $c; } my @sorted = sort { $stmt{$b}->{$opt{s}} <=> $stmt{$a}->{$opt{s}} } keys %stmt; @sorted = @sorted[0 .. $opt{t}-1] if $opt{t}; @sorted = reverse @sorted if $opt{r}; foreach (@sorted) { my $v = $stmt{$_} || die; my ($c, $t, $at, $l, $al, $r, $ar, $e, $ae, $a, $aa) = @{ $v }{qw(c t at l al r ar e ae a aa)}; my @users = keys %{$v->{users}}; my $user = (@users==1) ? $users[0] : sprintf "%dusers",scalar @users; my @hosts = keys %{$v->{hosts}}; my $host = (@hosts==1) ? $hosts[0] : sprintf "%dhosts",scalar @hosts; printf "Count: %d Time=%.2fs (%ds) Lock=%.2fs (%ds) Rows_sent=%.1f (%d), Rows_examined=%.1f (%d), Rows_affected=%.1f (%d), $user\@$host\n%s\n\n", $c, $at,$t, $al,$l, $ar,$r, $ae, $e, $aa, $a, $_; } sub usage { my $str= shift; my $text= <<HERE; Usage: mysqldumpslow [ OPTS... ] [ LOGS... ] Parse and summarize the MySQL slow query log. Options are --verbose verbose --debug debug --help write this text to standard output -v verbose -d debug -s ORDER what to sort by (aa, ae, al, ar, at, a, c, e, l, r, t), 'at' is default aa: average rows affected ae: aggregated rows examined al: average lock time ar: average rows sent at: average query time a: rows affected c: count e: rows examined l: lock time r: rows sent t: query time -r reverse the sort order (largest last instead of first) -t NUM just show the top n queries -a don't abstract all numbers to N and strings to 'S' -n NUM abstract numbers with at least n digits within names -g PATTERN grep: only consider stmts that include this string -h HOSTNAME hostname of db server for *-slow.log filename (can be wildcard), default is '*', i.e. match all -i NAME name of server instance (if using mysql.server startup script) -l don't subtract lock time from total time HERE if ($str) { print STDERR "ERROR: $str\n\n"; print STDERR $text; exit 1; } else { print $text; exit 0; } }