Munin contributed plugins

#!/usr/bin/php

<?php

/**

 * @author: Konstantin Kuklin <konstantin.kuklin@gmail.com>

 * Date: 24.05.12

 */

$sCommandSystem = "echo 'show status;' | mysql -h127.0.0.1 -P9306 | grep connections | awk '{ print $2}';";

$sTmpFilePath = "/tmp/sphinx_connections";

if (isset($argc) && $argc > 1) {

    if ($argv[1] == 'autoconf') {

        echo "yes\n";

    }

    if ($argv[1] == 'config') {

        echo "graph_title Sphinx Connections in last 5 minutes\n" .

            "graph_info This graph shows the number of connections for last 5 minutes\n" .

            "graph_category sphinx\n" .

            "graph_args --base 1000 --lower-limit 0\n" .

            "graph_vlabel Connections\n" .

            "graph_info The number of current connections with respect to the max_connections setting.graph_category sphinx\n" .

            "graph_order current\n" .

            "graph_total Total\n" .

            "current.label In Use\n" .

            "current.draw AREA\n" .

            "current.info The number of connections in last 5 minutes\n" .

            "current.warning 2500\n" .

            "current.critical 4000\n";

    }

    exit(0);

}

$iCurrent = @exec($sCommandSystem);

if (!file_exists($sTmpFilePath)) {

    $fp = fopen($sTmpFilePath, "w");

    fputs($fp, $iCurrent);

    fclose($fp);

    $toShow = 0;

} else {

    $iOldCount = file_get_contents($sTmpFilePath, true);

    $fp = fopen($sTmpFilePath, "w");

    fputs($fp, $iCurrent);

    fclose($fp);

    $toShow = (int) ($iCurrent - (int) $iOldCount);

}

echo "current.value $toShow\n";