#!/usr/bin/perl
#################################################################
## User
## Gives the current processes, mysqladmin proc output for a user
##  and whoever is hitting their sites.
##
##  If you see any issues please let me know
##        - kevin.schottie@endurance.com
#################################################################

my $user = shift;

if ($user !~ /\w{2,15}$/) {
	print "User not in proper format\n";
	exit;
}
my $dbuser = substr($user, 0, 8);

open PS,"ps ax -o user:@{[length($user)+1]},pid,pcpu,pmem,vsz,rss,tty,stat,start_time,bsdtime,cmd |";
open MYSQLPROC, "/usr/bin/mysql -e \"select USER,DB,STATE,TIME,COMMAND,INFO from INFORMATION_SCHEMA.PROCESSLIST WHERE (USER LIKE '" . $dbuser . "_%' OR USER = '$dbuser')\\G\" |";

my @ps = <PS>;
my @mysqlproc = <MYSQLPROC>;

close (PS);
close (MYSQLPROC);

my @runningprocesses = grep (/^$user /,@ps);
print "Running Processes:\n";
foreach (@runningprocesses) {
        print $_;
}

print "\nRunning Queries:\n";
foreach (@mysqlproc) {
        print $_;
}
print "\nOpen connections\n";
print `lsof -Pnawi -u $user`;
