Adam Powell wrote:
>
> Sorry about this, before I forget I have one more question. We run an ad
> network that consists of PHP pages linking to a mySQL database. We have to
> upgrade to Oracle because basically mySQL cannot hack the number of ads that
> we are serving, however this is waay in the future. Currently something is
> causing a memory leak in the database, our 450 keeps going up to 999 Meg
> used (the mySQLd process that is) and then starts swapping and the techs
> have to restart it.
>
> We use queries such as
>
> $res = mysql("dbname", "SELECT * FROM personal WHERE username='$username'");
> $d = mysql_fetch_object($res);
> mysql_free_result($res);
> echo "Welcome $d->first_name $d->second_name";
>
> Can anybody tell me any possible reasons, or things to watch out for, that
> may be causing any memory leaks? There are a LOT of pages like the one
> above, and I think that something fundamentally wrong is happening in all of
> them.
>
> Thanks again,
> Adam
>
What OS are you using? Good possibility that you have memory leaks in
libc itself, but I am not sure. I've never heard of any memory leaks in
MySQL itself.
--
Sasha Pachev
http://www.sashanet.com
