List:General Discussion« Previous MessageNext Message »
From:Adam Powell Date:April 24 1999 2:43pm
Subject:Re: one more thing
View as plain text  
Right, its Sun OS 5.6, MySQL 3.22.20a, and PHP 3.0.6.  I think the problems
are caused by not adding a free statement at the end of the scripts, but I
thought PHP did a pretty good job of clearing up after itself...

Adam

----- Original Message -----
From: Sasha Pachev <sasha@stripped>
To: Adam Powell <adam@stripped>
Cc: <php3@stripped>; <mysql@stripped>
Sent: 24 April 1999 15:26
Subject: Re: one more thing


> 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