|
From: Friedrich L. <fl...@fl...> - 2002-08-19 22:43:40
|
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 |