<?php

$link=mysqli_connect("127.0.0.1","root","") or die (mysqli_connect_error());
mysqli_select_db($link,"test") or die(mysqli_error($link));

print "global status before select:\n";
$rs=mysqli_query($link,"show global status like 'com_select'") or die(mysqli_error($link));
while($row=mysqli_fetch_array($rs))
{
        print_r($row);       
}
mysqli_free_result($rs);
print "now running 100 selects\n";
for($i=0;$i<100;$i++)
{
        print ".";
        $rs=mysqli_query($link,"select now()") or die(mysqli_error($link));
        while($row=mysqli_fetch_array($rs))
        {
                
        }
        mysqli_free_result($rs);       
}

print "\nglobal status after select:\n";
$rs=mysqli_query($link,"show global status like 'com_select'") or die(mysqli_error($link));
while($row=mysqli_fetch_array($rs))
{
        print_r($row);       
}
mysqli_free_result($rs);

print "about to change user\n";
mysqli_change_user($link,"root","","test") or die(mysqli_error($link));

print "global status after change user:\n";
$rs=mysqli_query($link,"show global status like 'com_select'") or die(mysqli_error($link));
while($row=mysqli_fetch_array($rs))
{
        print_r($row);       
}
mysqli_free_result($rs);


?>