r...@mgmt5 examples]# top
top - 19:31:01 up 4 days, 9:24, 5 users, load average: 0.12, 0.08, 0.07
Tasks: 202 total, 1 running, 201 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0%us, 0.0%sy, 0.0%ni, 99.9%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 24675552k total, 3611064k used, 21064488k
Btw... when running with updates..
The mysql processlist keep growing and growing with updates
How would i bring down the amount of updates?
Thomas
-Oprindelig meddelelse-
Fra: pmacct-discussion-boun...@pmacct.net
[mailto:pmacct-discussion-boun...@pmacct.net] På vegne af Paolo
Hi Thomas,
What matters is really how many 'src_host, dst_host' aggregates
are generated out of the traffic. Predicting for me is difficult
but you can turn sql_dont_try_update to false (so that it doesn't
complain about duplicates anymore for the sake of this test) and
see whether during the
Paolo i have lots and lots of ram so i upped the cache...
Now no duplicates... but still the traffic is to small... :(
If i do something like
SELECT SUM(bytes) FROM `acct` WHERE `ip_src` LIKE '130.239.18.173' AND
`ip_dst` LIKE '94.231.108.4'
The number is just to small..
Thomas