[Netacct-mysql-users] [0.74r1] nacctd forks for mysql connection and sometimes takes a lot of memory

[Friedrich L. <fl...@fl...>]

Hi!

I see that some time that when nacctd forks in process.c for processing
the SQL selects and updates it takes up a lot of memory - steadily increasing
till it is somehow able to send all data.

See this output of "top":

  10:17pm  up 35 days, 11:35,  1 user,  load average: 2.04, 2.19, 2.15
81 processes: 76 sleeping, 5 running, 0 zombie, 0 stopped
CPU states: 63.5% user, 30.0% system,  6.3% nice,  0.0% idle
Mem:   255456K av,  251320K used,    4136K free,       0K shrd,   21152K buff
Swap: 1052632K av,  200044K used,  852588K free                   16544K cached

   PID USER     PRI  NI  SIZE  RSS SHARE STAT %CPU %MEM   TIME COMMAND
29245 root      20   0  329M 162M  4292 S     0.0 65.2   0:09 nacctd
11056 root      20   0  6168 6076    88 S     1.1  2.3   3:31 nacctd
  5408 wwwrun    20   0  4680 2796  2296 S     0.0  1.0   0:04 httpd
  5399 wwwrun    20   0  5232 2792  2272 S     0.0  1.0   0:03 httpd
  9987 mysql     20   0  7356 2352  1856 S     0.0  0.9   0:00 mysqld-max
  9989 mysql     20   0  7356 2352  1856 S     0.0  0.9   0:00 mysqld-max
  9990 mysql     20   0  7356 2352  1856 S     0.0  0.9   0:00 mysqld-max
  9991 mysql     20   0  7356 2352  1856 S     0.0  0.9   0:00 mysqld-max
29252 mysql      0   0  7356 2352  1856 R    75.6  0.9 127:12 mysqld-max
26064 root      20   0  3952 2108  1808 S     0.0  0.8   0:03 xconsole
  5217 named     20   0  2508 1868   808 S     0.0  0.7   0:05 named
17331 root      20   0  1796 1796  1600 S     0.0  0.7   0:44 ntpd


# ps fwxa
11056 ?        R      3:38 /usr/local/sbin/nacctd
29245 ?        S      0:09  \_ /usr/local/sbin/nacctd

Can someone have a look where the code might consume more and
more memory and not releasing it? Maybe the mySQL results are not
freed before each new request or the like ?!

-- 
MfG / Regards
Friedrich Lobenstock
____________________________________________________________________
Friedrich Lobenstock         FL226-RIPE             Internetservices
URL: http://www.fl.priv.at/                     Email: fl...@fl...
____________________________________________________________________