[ic] memory usage

[Peter Jakl]

> >>>> In analyzing some speed problems, redhat linux indicates that the
> >>>> interchange process itself is using 204mb of memory. We have a
> catalog
> >>>> of over 100,000 items. Is this typical? Could some of the speed
> issues
> >>>> we have be attributed to having a system with 512mb of total
memory
> and
> >>>> each interchange instance requiring 204mb (granted that a good
chunk
> >>>> appears to be shared)?
> >>>>
> >>> Are you sure that's 204MB and not 20.4MB?  The memory usage you
are
> >>> seeing would not be typical.  How are you measuring that amount?
> >>>
> >> I run the "top" utility in redhat and the memory clearly indicates
204M
> >> where the next largest process has a value such as 12500 for
something
> like
> >> mysqld. I'm assuming values are in units of 'K' so mysqld is using
> 12.5mb
> >> with interchange at 204mb. I'd like to see what other people have
as a
> >> value. I do have 150,000 items in the products table. Is
interchange
> caching
> >> data?
> >>
> > Interchange doesn't cache resultsets or any other dynamic data
between
> > page requests, other than small things such as database connection
> > handles, so that shouldn't be an issue.
> >
> > As a comparison, here are my largest interchange, httpd and mysql
> > processes, as reported by top and then pasted here:
> >
> > PID USER     PRI  SIZE  TRS  RSS SHARE STAT %CPU %MEM   TIME COMMAND
> > 19634 centrewo   0 25252  636  24M 15032 S     0.0  1.6   0:08
> interchange
> > 20712 nobody     0  5788  808 5396  4884 S     0.0  1.3   0:00 httpd
> > 671 mysql      0  4380 1168 4076  1112 S     0.0  0.2   0:00 mysqld
> >
> > It looks like both your interchange and mysql processes are using
> > around 10x the memory that mine do, which is why I asked whether
> > you meant 20.4MB rather than 204MB.
> >
> > I'm at a loss to explain how your interchange process could sustain
> > a size of 204MB, unless you are keeping your products table as an
> > 'in-memory' table, or are running thousands of shops.  Even then,
> > your mysqld seems to be using more memory than it is entitled to.
> >
> > Can anyone else shed some light on this?
> 
> mine is similar to above also...
> 
>   PID USER     PRI  NI  SIZE  RSS SHARE STAT %CPU %MEM   TIME COMMAND
> 13877 interch    9   0 24916  24M 14260 S     0.0  3.2   0:15
interchange
> 13017 apache     9   0  3520 3520  3104 S     0.0  0.4   0:00 httpd
>   610 mysql      5   0  3368 3368  1496 S     0.0  0.4   0:01 mysqld
> 

I created the original post on this. Just to be clear, here's my pasted
output from "top":

  PID USER     PRI  NI  SIZE  RSS SHARE STAT  LIB %CPU %MEM   TIME
COMMAND
 4601 interch    9   0  205M 194M  1572 S       0  0.0 38.7   0:28
interchange
  517 mysql      9   0 10740  10M  1544 S       0  0.0  2.0   0:00
mysqld
  520 mysql      8   0 10740  10M  1544 S       0  0.0  2.0   0:01
mysqld
  521 mysql      9   0 10740  10M  1544 S       0  0.0  2.0   4:31
mysqld

Peter