diff -ruN --exclude=CVS /usr/ports/databases/mytop/Makefile ./Makefile --- /usr/ports/databases/mytop/Makefile 2012-05-20 14:03:30.000000000 +0800 +++ ./Makefile 2012-05-31 04:16:10.000000000 +0800 @@ -7,7 +7,7 @@ PORTNAME= mytop PORTVERSION= 1.6 -PORTREVISION= 8 +PORTREVISION= 9 CATEGORIES= databases MASTER_SITES= http://jeremy.zawodny.com/mysql/mytop/ diff -ruN --exclude=CVS /usr/ports/databases/mytop/files/patch-mytop ./files/patch-mytop --- /usr/ports/databases/mytop/files/patch-mytop 2012-05-20 14:03:30.000000000 +0800 +++ ./files/patch-mytop 2012-05-31 04:16:02.000000000 +0800 @@ -1,5 +1,5 @@ --- mytop.orig 2007-02-17 12:57:46.000000000 +0800 -+++ mytop 2012-05-18 13:58:30.000000000 +0800 ++++ mytop 2012-05-31 04:15:52.000000000 +0800 @@ -153,7 +153,7 @@ "idle|i" => \$config{idle}, "resolve|r" => \$config{resolve}, @@ -153,6 +153,22 @@ $lines_left--; } +@@ -905,13 +952,13 @@ + ## + + #my $sz = $width - 52; +- my @sz = (8, 9, 15, 10, 9, 6); ++ my @sz = (9, 9, 15, 10, 9, 6); + my $used = scalar(@sz) + Sum(@sz); + my $free = $width - $used; + + print BOLD(); + +- printf "%8s %9s %15s %10s %9s %6s %-${free}s\n", ++ printf "%9s %9s %15s %10s %9s %6s %-${free}s\n", + 'Id','User','Host/IP','DB','Time', 'Cmd', 'Query or State'; + + print RESET(); @@ -952,8 +999,11 @@ { $thread->{Host} =~ s/:\d+$//; @@ -167,6 +183,15 @@ } ## Fix possible undefs +@@ -1044,7 +1094,7 @@ + print GREEN() if $thread->{Command} eq 'Connect'; + } + +- printf "%8d %9.9s %15.15s %10.10s %9d %6.6s %-${free}.${free}s\n", ++ printf "%9d %9.9s %15.15s %10.10s %9d %6.6s %-${free}.${free}s\n", + $thread->{Id}, $thread->{User}, $thread->{Host}, $thread->{db}, + $thread->{Time}, $thread->{Command}, $smInfo; + @@ -1099,8 +1149,8 @@ my @data = Hashes("SHOW INNODB STATUS");