Hello all pmacct users My big problem is still with resources and loosing data. My network has about 1500 hosts and total bandwith about 40Mbit/s. My system is Pentium 4 3.0Ghz and 2GB RAM DDR dual channel. 2x WD 100GB.Using pmacct 0.8.1.
Here is the main problem i think i have this problem that mysql is eating memory with letting it go.This is one of 12 processes. mysql 1797 0.0 2.5 318784 53340 ? S Feb02 0:00 /usr/local/mysql/libexec/mysqld Below i present the system info .Please help me determinig the leak and any error in my configuration. This is from pmacct .conf and rc.local(some config i use) rc.local echo 512000 > /proc/sys/net/core/wmem_max echo 512000 > /proc/sys/net/core/rmem_max echo 2048 4096 8192 >/proc/sys/net/ipv4/tcp_wmem echo 2048 4096 8192 >/proc/sys/net/ipv4/tcp_rmem and pmacct.conf sql_db: bwstat sql_table: acct sql_table_version: 1 sql_refresh_time: 60 sql_history: 1h sql_history_roundoff: mh networks_file: /etc/pmacct/networks.lst plugin_pipe_size: 4096000 plugin_buffer_size: 4096 sql_cache_entries: 99991 (some /etc/my.cnf key_buffer = 256M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size= 16M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 4 -- Best regards, Pajlatek mailto:[EMAIL PROTECTED]
