Posted by vivek on 07/04/07 00:32

Could someone please help me figure out why the memory usage
fluctuates when I use mysql_real_escape_string? I'm finding (what I
think are) memory leaks with a few mysql functions in php and I'm
trying to figure them all out. This one is pretty vexing. Thanks in
advance.

Here is example code:
class memTest {
function __construct() {
$con = mysql_connect("***************","*******","****");
if (!$con) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db("*******", $con);
mysql_query("SET NAMES 'utf8'");
for ($i = 1; $i<=10; $i++) {
$temp = 'mysql';
echo "mem: ", memory_get_usage(), "\n";
echo mysql_real_escape_string($temp), "\n";
echo "mem: ", memory_get_usage(), "\n\n";
}
mysql_close($con);
}
}
$a = new memTest();

Here is what is output:
mem: 43216
mysql
mem: 43208

mem: 43208
mysql
mem: 43216

mem: 43216
mysql
mem: 43224

mem: 43224
mysql
mem: 43232

mem: 43232
mysql
mem: 43240

mem: 43240
mysql
mem: 43248

mem: 43248
mysql
mem: 43256

mem: 43256
mysql
mem: 43264

mem: 43264
mysql
mem: 43272

mem: 43272
mysql
mem: 43280

[Back to original message]