/ etc / munin / plugins / [ HOME SHELL ]

Name	Size	Permission
apache_accesses	5.17 KB	-rwxr-xr-x
apache_processes	6.52 KB	-rwxr-xr-x
apache_volume	5.12 KB	-rwxr-xr-x
cpu	7.3 KB	-rwxr-xr-x
df	4.26 KB	-rwxr-xr-x
df_inode	4.31 KB	-rwxr-xr-x
diskstats	34.62 KB	-rwxr-xr-x
entropy	988 B	-rwxr-xr-x
exim_mailqueue	3.12 KB	-rwxr-xr-x
exim_mailstats	5.51 KB	-rwxr-xr-x
forks	1.01 KB	-rwxr-xr-x
fw_packets	1.75 KB	-rwxr-xr-x
http_loadtime	3.22 KB	-rwxr-xr-x
if_err_eth0	3.07 KB	-rwxr-xr-x
if_err_eth1	3.07 KB	-rwxr-xr-x
if_eth0	5.78 KB	-rwxr-xr-x
if_eth1	5.78 KB	-rwxr-xr-x
interrupts	1.99 KB	-rwxr-xr-x
irqstats	4.2 KB	-rwxr-xr-x
load	2.69 KB	-rwxr-xr-x
memory	11.16 KB	-rwxr-xr-x
munin_stats	3.78 KB	-rwxr-xr-x
mysql_bytes	1.77 KB	-rwxr-xr-x
mysql_innodb	5.52 KB	-rwxr-xr-x
mysql_queries	2.59 KB	-rwxr-xr-x
mysql_slowqueries	1.5 KB	-rwxr-xr-x
mysql_threads	1.58 KB	-rwxr-xr-x
netstat	3.3 KB	-rwxr-xr-x
nfs4_client	1.24 KB	-rwxr-xr-x
open_files	1.2 KB	-rwxr-xr-x
open_inodes	1.06 KB	-rwxr-xr-x
proc_pri	1.56 KB	-rwxr-xr-x
processes	15.26 KB	-rwxr-xr-x
swap	1.24 KB	-rwxr-xr-x
threads	1.4 KB	-rwxr-xr-x
uptime	859 B	-rwxr-xr-x
users	2.46 KB	-rwxr-xr-x
vmstat	1.13 KB	-rwxr-xr-x

Code Editor : mysql_queries

#!/usr/local/cpanel/3rdparty/perl/542/bin/perl
# -*- perl -*-

=head1 NAME

mysql_queries - Munin plugin to display MySQL query rate.

=head1 APPLICABLE SYSTEMS

Any MySQL platform

=head1 CONFIGURATION

[mysql*]
     user root
     env.mysqlopts <options-for-mysqladmin-here>
     env.mysqladmin <optional-override-of-mysqladmin-path>

It is most usual that root must run the mysqladmin command.

Only use the .env settings if you need to override the defaults.

=head1 INTERPRETATION

To Be Written

=head1 BUGS

None known

=head1 AUTHOR

=head1 LICENSE

GPLv2

=head1 MAGIC MARKERS

#%# family=manual
  #%# capabilities=autoconf

=cut

use strict;

my $MYSQLADMIN = $ENV{mysqladmin} || "mysqladmin";
my $COMMAND    = "$MYSQLADMIN $ENV{mysqlopts} extended-status";

my @WANTED_ORDER = ( "Com_select", "Com_delete", "Com_insert", "Com_update", "Com_replace", "Qcache_hits" );
my %WANTED = ( "Com_delete"  => "delete",
               "Com_insert"  => "insert",
               "Com_select"  => "select",
               "Com_update"  => "update",
               "Com_replace" => "replace",
               "Qcache_hits" => "cache_hits",
             );

my $arg = shift();

if ($arg eq 'config') {
    print_config();
    exit();
} elsif ($arg eq 'autoconf') {
    unless (test_service() ) {
        print "yes\n";
    } else {
        print "no\n";
    }
    exit 0;
}

open(SERVICE, "$COMMAND |")
  or die("Could not execute '$COMMAND': $!");

while (<SERVICE>) {
    my ($k, $v) = (m/(\w+).*?(\d+(?:\.\d+)?)/);
    next unless ($k);
    if (exists $WANTED{$k} ) {
	print("$WANTED{$k}.value $v\n");
    }
}

close(SERVICE);

sub print_config {

my $num = 0;

print("graph_title MySQL queries
graph_args --base 1000
graph_vlabel queries / \${graph_period}
graph_category mysql
graph_info Note that this is a old plugin which is no longer installed by default.  It is retained for compatability with old installations.
graph_total total\n");

foreach my $key (@WANTED_ORDER){
        my $title = $WANTED{$key};
        print("$title.label ${title}\n",
              "$title.min 0\n",
              "$title.type DERIVE\n",
              "$title.max 500000\n",
              "$title.draw ", ($num) ? "STACK" : "AREA" ,  "\n",
             );
        $num++;
    }

}

sub test_service {
    system ("$MYSQLADMIN --version >/dev/null 2>/dev/null");
    if ($? == 0)
    {
	system ("$COMMAND >/dev/null 2>/dev/null");
	if ($? == 0)
	{
	    print "yes\n";
	}
	else
	{
	    print "no (could not connect to mysql)\n";
	}
    }
    else
    {
	print "no (mysqladmin not found)\n";
    }
    exit 0;
}

Code Editor : mysql_queries

User Profile

Quick Links

Signal Health Group

Useful Links

${this.title}

Code Editor : mysql_queries

Quick Links

Signal Health Group

Useful Links