Mysql-status in XML Login or Register to Bookmark this snippet

Description PHP

This snippet, allows for statistics on mysql using the status function in the mysql client. For this script to work, it needs to have a mysql user names "status" which effectively has no permissions, and no access to any tables, therefore being very secure, and also unobtrusive. The xml formatting allows for several different types of translation and usage.

The Code Download

<?php
//this script gets the average queries per second
$status = shell_exec('mysqladmin status -u status');
 
$status = str_replace(': ',':',$status);
$status = str_replace(' Queries','  Queries',$status);
//$status = str_replace(' ','',$status);
$statusArray = explode('  ', $status);
foreach($statusArray as $k => $v) {
    $vArray = explode(':',$v);
    $outputArray[str_replace(' ','',$vArray[0])] = round(($vArray[1]));
    };
 
echo "<?xml version="1.0" encoding="ISO-8859-1" ?>n";
echo "<mysqlStatus>n";
foreach($outputArray as $k => $v) {
    echo " <".$k.">".$v."</".$k.">n";
    };
echo "</mysqlStatus>n"; 
?>

Snippets v2

Mysql-status in XML Login or Register to Bookmark this snippet