Hi all, after reading all that statements, that SQL databases cannot handle the amount of flows of a "normal" line, I am interested about the facts. So I would like to start a little survey, how many rows of flows per time which SQL db can handle on which kind of hardware and in which configuration (or not).
I'll start: Amount: ------- 3.5 - 4 M rows per day without any problems Config: ------- sql_table_version: 5 aggregate: src_mac,dst_mac,vlan,src_host,dst_host,src_port,dst_port,tos,proto,flows sql_refresh_time: 60 sql_history: 1m sql_history_roundoff: m sql_dont_try_update: true The tables have only _one_ index over "stamp_inserted". (As I mentioned in former mails, the indexes affected the performance of INSERTS a lot in my case.) Setup: ------ PIII 900 Mhz 384MB RAM Single hard disk UDMA100. OpenBSD 3.7 PostgreSQL 7.4.3 Monitors a 100Mbit, 2Mbit and a 6 Mbit DSL line over a 1Gbit mirroring port in promiscuous mode. Cheers, Sven -- Sven Anderson Institute for Informatics - http://www.ifi.informatik.uni-goettingen.de Georg-August-Universitaet Goettingen Lotzestr. 16-18, 37083 Goettingen, Germany _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
