List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:April 24 1999 2:26pm
Subject:Re: one more thing
View as plain text  
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
Thread
one more thingAdam Powell24 Apr
  • Re: [PHP3] one more thingRasmus Lerdorf24 Apr
  • Re: one more thing(Graeme B. Davis)24 Apr
  • Re: one more thingSasha Pachev24 Apr
  • Re: one more thingAdam Powell24 Apr
    • Re: [PHP3] Re: one more thingRasmus Lerdorf24 Apr
    • Re: one more thingMichael Widenius25 Apr