[ic] memory usage

[Kevin Walsh]

> > > 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?

-- 
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin@cursor.uk.com
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/