Snort mailing list archives
Re: Barnyard2 reports database insert errors
From: waldo kitty <wkitty42 () windstream net>
Date: Sat, 02 Nov 2013 15:20:03 -0400
On 11/1/2013 11:11 PM, Dave Corsello wrote: [...]
+-------------------+--------+ | table_name | engine | +-------------------+--------+ | acid_ag | MyISAM | | acid_ag_alert | MyISAM | | acid_event | MyISAM | | acid_ip_cache | MyISAM | | agent_asset_names | InnoDB | | aggregated_events | NULL | | asset_names | InnoDB | | base_roles | MyISAM | | base_users | MyISAM | | caches | InnoDB | | classifications | InnoDB | | daily_caches | InnoDB | | data | InnoDB | | delayed_jobs | InnoDB | | detail | InnoDB | | encoding | InnoDB | | event | InnoDB | | events_with_join | NULL | | favorites | InnoDB | | icmphdr | InnoDB | | iphdr | InnoDB | | lookups | InnoDB | | notes | InnoDB | | notifications | InnoDB | | opt | InnoDB | | reference | InnoDB | | reference_system | InnoDB | | schema | InnoDB | | search | InnoDB | | sensor | InnoDB | | settings | InnoDB | | severities | InnoDB | | sig_class | InnoDB | | sig_reference | InnoDB | | signature | InnoDB | | tcphdr | InnoDB | | udphdr | InnoDB | | users | InnoDB | +-------------------+--------+
not that this will have anything to do with your problem, but... have you also tuned your mysql installation for innodb usage? one of the web apps we use insisted on using innodb instead of myisam and it ran like fecal material until we tuned the innodb settings... it may be that if the database is having to extend the innodb files, that it may take time or more ram than configured for which might cause comms problems... possibly? maybe? just a thought i figured i'd toss out there ;) -- NOTE: No off-list assistance is given without prior approval. Please keep mailing list traffic on the list unless private contact is specifically requested and granted. ------------------------------------------------------------------------------ Android is increasing in popularity, but the open development platform that developers love is also attractive to malware creators. Download this white paper to learn more about secure code signing practices that can help keep Android apps secure. http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk _______________________________________________ Snort-users mailing list Snort-users () lists sourceforge net Go to this URL to change user options or unsubscribe: https://lists.sourceforge.net/lists/listinfo/snort-users Snort-users list archive: http://sourceforge.net/mailarchive/forum.php?forum_name=snort-users Please visit http://blog.snort.org to stay current on all the latest Snort news!
Current thread:
- Re: Barnyard2 reports database insert errors, (continued)
- Re: Barnyard2 reports database insert errors beenph (Nov 02)
- Re: Barnyard2 reports database insert errors Dave Corsello (Nov 02)
- Re: Barnyard2 reports database insert errors beenph (Nov 02)
- Re: Barnyard2 reports database insert errors Dave Corsello (Nov 03)
- Re: Barnyard2 reports database insert errors Dave Corsello (Nov 04)
- Re: Barnyard2 reports database insert errors beenph (Nov 04)
- Re: Barnyard2 reports database insert errors Dave Corsello (Nov 05)
- Re: Barnyard2 reports database insert errors waldo kitty (Nov 05)
- Re: Barnyard2 reports database insert errors Dave Corsello (Nov 05)
- Re: Barnyard2 reports database insert errors waldo kitty (Nov 05)
- Re: Barnyard2 reports database insert errors waldo kitty (Nov 02)
- Re: Barnyard2 reports database insert errors Dave Corsello (Nov 02)