show processlist \G
Array
(
[0] => Uptime: 5380
[1] => Threads: 2
[2] => Questions: 1321299
[3] => Slow queries: 0
[4] => Opens: 26
[5] => Flush tables: 1
[6] => Open tables: 17
[7] => Queries per second avg: 245.595
)
<html><head><title>Moniteur MYSQL</title>
<style>table{font-family:verdana;font-size:8pt}</style>
</head><body>
<center><table border=0 cellspacing=0 cellpadding=0><tr><td valign=top>
<table width=90% border=1 cellspacing=0 cellpadding=0>
<?
$link = mysql_connect('localhost', 'login', 'motdepasse');
$result = mysql_query('SHOW STATUS', $link);
$nb = 0;
while ($row = mysql_fetch_assoc($result)) {
$nb = $nb+1;
if (($nb == "29") || ($nb == "57") || ($nb == "85")) {
print "</table></td><td valign=top><table width=90% border=1 cellspacing=0 cellpadding=0>";
echo '<tr><td> ' . $row['Variable_name'] . '</td><td><b> ' . $row['Value'] . "</td></tr>";
} else {
echo '<tr><td> ' . $row['Variable_name'] . '</td><td><b> ' . $row['Value'] . "</td></tr>";
}
}
mysql_close();
?>
</table></td></tr></table></body></html>