[Netacct-mysql-users] [0.74r1] MySQL-Daemon goes to 100%

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

Hi!

As usuall I was to early, just found nacctd consuming about 250MB and counting
memory and mysql daemon at nearly 100%. Some minutes later it was down to
about 20MB. Restarting the daemon and it is down to about 800KB.

What can make nacctd react so badly?

-- 
MfG / Regards
Friedrich Lobenstock

-------- Original Message --------
Subject: [ netacct-mysql-Bugs-597108 ] [0.74r1] MySQL-Daemon goes to 100%
Date: Mon, 19 Aug 2002 09:00:59 -0700
From: no...@so...
To: no...@so...

Bugs item #597108, was opened at 2002-08-19 13:59
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=378119&aid=597108&group_id=23298

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Friedrich Lobenstock (friedl)
Assigned to: Nobody/Anonymous (nobody)
Summary: [0.74r1] MySQL-Daemon goes to 100%

Initial Comment:

With 0.74r1 the mysql daemon goes to 100% after a while
and nacctd
builds up memory. With 0.73 this problem does not
exist, at least not up to now ;-)



----------------------------------------------------------------------

 >Comment By: Friedrich Lobenstock (friedl)
Date: 2002-08-19 18:00

Message:
Logged In: YES
user_id=38090

Seems to be a problem because the default value for flush is
300.
Now I'm down to 30 seconds and the situations seems to be
more stable.

PS: I'm using the follwing config:
database mysql
mysql_user acct
mysql_password XXXXXXX
mysql_host localhost
mysql_port 0
mysql_database netacct
mysql_table accounting
pidfile  /var/run/nacctd.pid
compactnet  AAA.BBB.CCC.0 255.255.255.0
ignoremask 255.255.255.0
flush 30
fdelay 60
file /var/log/net-acct
dumpfile /var/log/net-acct-dump
notdev eth0
device eth1
ignoremask 255.255.255.0
ignorenet 127.0.0.0 255.0.0.0
debug 2
debugfile /var/log/nacctd.debug
headers tr      40      38
headers lo      14      12
headers isdn    4       0
headers eth     14      12
headers plip    14      12


----------------------------------------------------------------------

Comment By: Friedrich Lobenstock (friedl)
Date: 2002-08-19 16:44

Message:
Logged In: YES
user_id=38090

Hmmmm....a downgrade did not really help.
nacctd starts building up memory and mysql is using a much
cpu as
it can get.

Output from top:
PID USR PRI NI SIZE RSS SHARE ST %CPU %MEM TIME COMMAND
26585 root      20   0 51884  50M   764 S     0.0 20.3
0:01 nacctd
14029 wwwrun    20   0  7876 7496  5312 S     0.0  2.9
0:04 httpd
  1884 mysql     20   0  5444 5444  2320 S     0.0  2.1
0:00 mysqld-max
  1886 mysql     20   0  5444 5444  2320 S     0.0  2.1
0:00 mysqld-max
  1887 mysql     20   0  5444 5444  2320 S     0.0  2.1
0:00 mysqld-max
  1889 mysql     20   0  5444 5444  2320 S     0.0  2.1
0:00 mysqld-max
14352 wwwrun    20   0  6360 5444  3548 S     0.0  2.1
0:04 httpd
26586 mysql      0   0  5444 5444  2320 R    97.3  2.1
15:55 mysqld-max
14011 root      20   0  4988 4228  3824 S     0.0  1.6
0:00 httpd
26064 root      20   0  3712 3576   916 S     0.0  1.3
0:02 xconsole
27074 root      20   0  2216 2172  1692 R     0.9  0.8
0:01 sshd
30985 root       0   0  2412 2012  1668 S     0.0  0.7
0:47 snmpd
17331 root      20   0  1796 1796  1600 S     0.0  0.7
0:44 ntpd
27118 root      20   0  1712 1712  1252 S     0.0  0.6
0:00 bash


----------------------------------------------------------------------

You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=378119&aid=597108&group_id=23298