File Manager

003 File Manager

Current Path: /usr/local/bin

📁 ..
📄 2to3-3.8(101 B)
📄 ab(50.54 KB)
📄 addftinfo(63.84 KB)
📄 afmtodit(161.91 KB)
📄 apr-1-config(6.77 KB)
📄 apu-1-config(6.17 KB)
📄 argon2(43.3 KB)
📄 bash(918.65 KB)
📄 bashbug(6.65 KB)
📄 chardetect(972 B)
📄 chardetect-3.8(972 B)
📄 chem(28.51 KB)
📄 corelist(15.02 KB)
📄 cpan(8.17 KB)
📄 curl(163.47 KB)
📄 curl-config(7.33 KB)
📄 curve_keygen(5.88 KB)
📁 db5
📄 db_archive-5(9.28 KB)
📄 db_archive-5.3(9.28 KB)
📄 db_checkpoint-5(10.94 KB)
📄 db_checkpoint-5.3(10.94 KB)
📄 db_deadlock-5(11.12 KB)
📄 db_deadlock-5.3(11.12 KB)
📄 db_dump-5(13.95 KB)
📄 db_dump-5.3(13.95 KB)
📄 db_dump185-5(8.61 KB)
📄 db_dump185-5.3(8.61 KB)
📄 db_hotbackup-5(14.74 KB)
📄 db_hotbackup-5.3(14.74 KB)
📄 db_load-5(25.35 KB)
📄 db_load-5.3(25.35 KB)
📄 db_log_verify-5(12.36 KB)
📄 db_log_verify-5.3(12.36 KB)
📄 db_printlog-5(31.88 KB)
📄 db_printlog-5.3(31.88 KB)
📄 db_recover-5(10.81 KB)
📄 db_recover-5.3(10.81 KB)
📄 db_replicate-5(11.78 KB)
📄 db_replicate-5.3(11.78 KB)
📄 db_stat-5(11.89 KB)
📄 db_stat-5.3(11.89 KB)
📄 db_tuner-5(17.47 KB)
📄 db_tuner-5.3(17.47 KB)
📄 db_upgrade-5(9.81 KB)
📄 db_upgrade-5.3(9.81 KB)
📄 db_verify-5(10.36 KB)
📄 db_verify-5.3(10.36 KB)
📄 dehydrated(80.89 KB)
📄 distro(961 B)
📄 distro-3.8(961 B)
📄 enc2xs(40.78 KB)
📄 encguess(3.01 KB)
📄 envsubst(35.84 KB)
📄 epsffit(11.11 KB)
📄 eqn(181.15 KB)
📄 eqn2graph(3.16 KB)
📄 event_rpcgen.py(53.66 KB)
📄 extractres(2.69 KB)
📄 fixdlsrps(1.53 KB)
📄 fixfmps(605 B)
📄 fixmacps(2.11 KB)
📄 fixpsditps(700 B)
📄 fixpspps(1.28 KB)
📄 fixscribeps(485 B)
📄 fixtpps(705 B)
📄 fixwfwps(863 B)
📄 fixwpps(738 B)
📄 fixwwps(433 B)
📄 ftpasswd(37.06 KB)
📄 ftpcount(46.63 KB)
📄 ftpdctl(328.72 KB)
📄 ftpmail(13.63 KB)
📄 ftpquota(32.21 KB)
📄 ftptop(65.33 KB)
📄 ftpwho(133.71 KB)
📄 gdbm_dump(19.02 KB)
📄 gdbm_load(22.2 KB)
📄 gdbmtool(115.9 KB)
📄 gdiffmk(7.51 KB)
📄 getafm(6.18 KB)
📄 gettext(36.32 KB)
📄 gettext.sh(5.07 KB)
📄 glilypond(18.01 KB)
📄 gperl(6.5 KB)
📄 gpinyin(5.03 KB)
📄 grap2graph(3.08 KB)
📄 grn(118.4 KB)
📄 grodvi(150.01 KB)
📄 groff(130.26 KB)
📄 groffer(8.06 KB)
📄 grog(2.73 KB)
📄 grolbp(149.57 KB)
📄 grolj4(144.72 KB)
📄 gropdf(70.41 KB)
📄 grops(192.28 KB)
📄 grotty(145.68 KB)
📄 h2ph(28.55 KB)
📄 h2xs(59.51 KB)
📄 hpftodit(158.4 KB)
📄 htdbm(18.69 KB)
📄 htdigest(10.75 KB)
📄 htpasswd(17.62 KB)
📄 httxt2dbm(10.3 KB)
📄 iconv(25.27 KB)
📄 idle3.8(99 B)
📄 includeres(1.44 KB)
📄 indexinfo(10.87 KB)
📄 indxbib(73.84 KB)
📄 innochecksum(3.44 MB)
📄 instmodsh(4.2 KB)
📄 json_pp(4.88 KB)
📄 ldapadd(67.1 KB)
📄 ldapcompare(56.88 KB)
📄 ldapdelete(58.27 KB)
📄 ldapexop(57.43 KB)
📄 ldapmodify(67.1 KB)
📄 ldapmodrdn(56.87 KB)
📄 ldappasswd(57.66 KB)
📄 ldapsearch(78.48 KB)
📄 ldapurl(18.74 KB)
📄 ldapwhoami(55.38 KB)
📄 libnetcfg(15.42 KB)
📄 lkbib(80.95 KB)
📄 logresolve(10.15 KB)
📄 lookbib(81.07 KB)
📄 lz4(68.09 KB)
📄 lz4_decompress(7.7 KB)
📄 lz4c(68.09 KB)
📄 lz4cat(68.09 KB)
📄 mmroff(3.75 KB)
📄 my_print_defaults(3.4 MB)
📄 myisam_ftdump(3.63 MB)
📄 myisamchk(3.73 MB)
📄 myisamlog(3.61 MB)
📄 myisampack(3.66 MB)
📄 mysql(3.66 MB)
📄 mysql_config(5.05 KB)
📄 mysql_config_editor(3.4 MB)
📄 mysql_install_db(4.96 MB)
📄 mysql_plugin(3.41 MB)
📄 mysql_secure_installation(3.56 MB)
📄 mysql_ssl_rsa_setup(3.44 MB)
📄 mysql_tzinfo_to_sql(3.37 MB)
📄 mysql_upgrade(4.16 MB)
📄 mysqladmin(3.56 MB)
📄 mysqlbinlog(3.78 MB)
📄 mysqlcheck(3.57 MB)
📄 mysqld_multi(26.39 KB)
📄 mysqld_safe(27.21 KB)
📄 mysqldump(3.63 MB)
📄 mysqldumpslow(7.67 KB)
📄 mysqlimport(3.55 MB)
📄 mysqlpump(3.92 MB)
📄 mysqlshow(3.55 MB)
📄 mysqlslap(3.57 MB)
📄 mysqltest(3.85 MB)
📄 mysqlxtest(4.2 MB)
📄 neqn(919 B)
📄 ngettext(35.89 KB)
📄 nroff(3.21 KB)
📄 paperconf(10.55 KB)
📄 pcre-config(2.31 KB)
📄 pcre2-config(2.13 KB)
📄 pcre2grep(46.03 KB)
📄 pcre2test(166.76 KB)
📄 pcregrep(35.81 KB)
📄 pcretest(103.81 KB)
📄 pdfmom(3.03 KB)
📄 pdfroff(20.96 KB)
📄 perl(7.41 KB)
📄 perl5.32.1(7.41 KB)
📄 perlbug(44.21 KB)
📄 perldoc(274 B)
📄 perlivp(10.58 KB)
📄 perlthanks(44.21 KB)
📄 perror(3.53 MB)
📄 pfbtops(53.68 KB)
📄 php(5.31 MB)
📄 php-cgi(5.24 MB)
📄 php-config(3.16 KB)
📄 phpize(4.42 KB)
📄 pic(231.69 KB)
📄 pic2graph(3.66 KB)
📄 piconv(8.17 KB)
📄 pl2pm(4.44 KB)
📄 pod2html(4.05 KB)
📄 pod2man(14.69 KB)
📄 pod2text(10.56 KB)
📄 pod2usage(3.86 KB)
📄 podchecker(3.58 KB)
📄 post-grohtml(247.92 KB)
📄 pre-grohtml(129.52 KB)
📄 preconv(78.54 KB)
📄 protoc(13.9 KB)
📄 prove(13.35 KB)
📄 prxs(9.25 KB)
📄 psbook(16.39 KB)
📄 psmerge(1.97 KB)
📄 psnup(24.64 KB)
📄 psresize(22.61 KB)
📄 psselect(17.91 KB)
📄 pstops(23.34 KB)
📄 ptar(3.48 KB)
📄 ptardiff(2.58 KB)
📄 ptargrep(4.3 KB)
📄 pybabel(960 B)
📄 pybabel-3.8(960 B)
📄 pydoc3.8(84 B)
📄 python3.8(5.13 KB)
📄 python3.8-config(3.09 KB)
📄 rbash(918.65 KB)
📄 refer(161.39 KB)
📄 replace(3.38 MB)
📄 resolve_stack_dump(3.4 MB)
📄 resolveip(3.4 MB)
📄 roff2dvi(5.58 KB)
📄 roff2html(5.58 KB)
📄 roff2pdf(5.58 KB)
📄 roff2ps(5.58 KB)
📄 roff2text(5.58 KB)
📄 roff2x(5.58 KB)
📄 salt(948 B)
📄 salt-api(956 B)
📄 salt-call(958 B)
📄 salt-cloud(960 B)
📄 salt-cp(954 B)
📄 salt-key(956 B)
📄 salt-master(962 B)
📄 salt-minion(962 B)
📄 salt-proxy(972 B)
📄 salt-run(956 B)
📄 salt-ssh(956 B)
📄 salt-syndic(962 B)
📄 salt-unity(960 B)
📄 screen(435.05 KB)
📄 setvhost.sh(3.05 KB)
📄 shasum(9.75 KB)
📄 showchar(2.51 KB)
📄 soelim(66.83 KB)
📄 splain(18.97 KB)
📄 spm(946 B)
📄 streamzip(5.4 KB)
📄 tbl(149.71 KB)
📄 tfmtodit(68.05 KB)
📄 troff(577.19 KB)
📄 uchardet(8.03 KB)
📄 unlz4(68.09 KB)
📄 xml2-config(1.79 KB)
📄 xmlcatalog(15.22 KB)
📄 xmllint(61.66 KB)
📄 xmlwf(31.56 KB)
📄 xsubpp(5.05 KB)
📄 zipdetails(50.05 KB)
📄 zlib_decompress(7.56 KB)

Editing: mysqldumpslow

#!/usr/local/bin/perl

# Copyright (c) 2000, 2021, Oracle and/or its affiliates.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License, version 2.0,
# as published by the Free Software Foundation.
#
# This program is also distributed with certain software (including
# but not limited to OpenSSL) that is licensed under separate terms,
# as designated in a particular file or component or in included license
# documentation.  The authors of MySQL hereby grant you an additional
# permission to link the program and your derivative works with the
# separately licensed software that they have included with MySQL.
#
# 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 General Public License, version 2.0, 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-1301, 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
# at, al, and ar 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 (al, at, ar, c, t, l, r)
    '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 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 $basedir = ($defaults =~ m/--basedir=(.*)/)[0]
	or die "Can't determine basedir from 'my_print_defaults mysqld' output: $defaults";
    warn "basedir=$basedir\n" if $opt{v};

my $datadir = ($defaults =~ m/--datadir=(.*)/)[0];
    my $slowlog = ($defaults =~ m/--slow-query-log-file=(.*)/)[0];
    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 mysqld' 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=(.*)/)[0]
	    or die "Can't determine --$opt{i}-datadir from 'my_print_defaults instances' output: $instances";
	warn "datadir=$datadir\n" if $opt{v};
    }

if ( -f $slowlog ) {
        @ARGV = ($slowlog);
        die "Can't find '$slowlog'\n" unless @ARGV;
    } else {
        @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{4}-\d{2}-\d{2}T\d{2}:\d{2}:\d{2}\.\d+(Z|[+-]\d{2}:\d{2}).*\n//;
    my ($user,$host,$dummy,$thread_id) = s/^#? User\@Host:\s+(\S+)\s+\@\s+(\S+)\s+\S+(\s+Id:\s+(\d+))?.*\n// ? ($1,$2,$3,$4) : ('','','','','');

s/^# Query_time: ([0-9.]+)\s+Lock_time: ([0-9.]+)\s+Rows_sent: ([0-9.]+).*\n//;
    my ($t, $l, $r) = ($1, $2, $3);
    $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;

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->{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) = @{ $v }{qw(c t l r)};
    $v->{at} = $t / $c;
    $v->{al} = $l / $c;
    $v->{ar} = $r / $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) = @{ $v }{qw(c t at l al r ar)};
    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=%.1f (%d), $user\@$host\n%s\n\n",
	    $c, $at,$t, $al,$l, $ar,$r, $_;
}

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 (al, at, ar, c, l, r, t), 'at' is default
                al: average lock time
                ar: average rows sent
                at: average query time
                 c: count
                 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;
    }
}

003 File Manager

Editing: mysqldumpslow

Upload File

Create Folder