[ic] memory usage

[sphen]

on 12/21/01 4:48 AM, Kevin Walsh at kevin@cursor.uk.com wrote:

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