mysql> create database memory_test;

mysql> use memory_test;

mysql> create table leak_test
       ( id int not null primary key auto_increment,
         data varchar(255) not null default '');

mysql> insert into leak_test (data) values ("data1"),("data 2"),
       ("data 3"),("data 4"),("data 5"),("data6"),("data 7"),
       ("data 8"),("data 9"),("data 10");

                
for ( $x=0; $x<300; $x++ ) {
    $db = mysql_connect("localhost", "root", "test");
    mysql_select_db("test");
    $sql  = "SELECT data FROM test"; 
    $result = mysql_query($sql); // The operation suspected of leaking
    mysql_free_result($result);
    mysql_close($db);
 }

                
";
    
$db = mysql_connect("localhost", "user", "password");
mysql_select_db("memory_test");

echo "After connecting, we're using (in bytes): ",
     memory_get_usage(),"\n
"; 

for ( $x=0; $x<10; $x++ ) {
    $sql  =
        "SELECT data FROM leak_test WHERE id='".$x."'"; 
    $result = mysql_query($sql); // The operation
                                 // suspected of leaking.
    echo "After query #$x, we're using (in bytes): ",
         memory_get_usage(), "\n
";
    mysql_free_result($result);
    echo "After freeing result $x, we're using (in bytes): ",
         memory_get_usage(), "\n
";
}
  
mysql_close($db);
echo "After closing the connection, we're using (in bytes): ",
     memory_get_usage(), "\n
";
echo "Peak memory usage for the script (in bytes):".
     memory_get_peak_usage();

?>

                
At the start we're using (in bytes): 63216
After connecting, we're using (in bytes): 64436
After query #0, we're using (in bytes): 64760
After freeing result 0, we're using (in bytes): 64828
After query #1, we're using (in bytes): 65004
After freeing result 1, we're using (in bytes): 65080
After query #2, we're using (in bytes): 65160
After freeing result 2, we're using (in bytes): 65204
After query #3, we're using (in bytes): 65284
After freeing result 3, we're using (in bytes): 65328
After query #4, we're using (in bytes): 65408
After freeing result 4, we're using (in bytes): 65452
After query #5, we're using (in bytes): 65532
After freeing result 5, we're using (in bytes): 65576
After query #6, we're using (in bytes): 65656
After freeing result 6, we're using (in bytes): 65700
After query #7, we're using (in bytes): 65780
After freeing result 7, we're using (in bytes): 65824
After query #8, we're using (in bytes): 65904
After freeing result 8, we're using (in bytes): 65948
After query #9, we're using (in bytes): 66028
After freeing result 9, we're using (in bytes): 66072
After closing the connection, we're using (in bytes): 65108
Peak memory usage for the script (in bytes): 88748