Show MySQL Status and stuff

[Anon]

I was wondering, is there a way to show the status of MySQL?

I was tinkering around a bit, I don't know if this will even work...but this is the code I'm testing:

<?

include('config.inc.php');

$showstatus = mysql_query("SHOW STATUS");
$showtablestatus = mysql_query("SHOW TABLE STATUS");

print '<font face="Arial" size="2">Status: '.$showstatus.'</font><p>';

print '<font face="Arial" size="2">Table Status: '.$showtablestatus.'</font><p>';

?>

config.inc.php includes the command to connect to the server and the database. But when I view the website I get this:

Status: Resource id #2
Table Status: Resource id #3

...I know the resource ID's are the connections to the database, but I was wondering if there was a way to relay the actual server status. If there is a way that is :o)

• zimm

[bretticus]

you're missing a crucial step...sounds like you didn't RTFM

[vponz]

Try this:

$result = mysql_query("SHOW STATUS");

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo $row['Variable_name'] . " " . $row['Value'] . "<br>";
}

See the MySql manual to get the columns name returned by SHOW TABLE STATUS.

Víctor Ponz
Spain