Re: Barnyard2 reports database insert errors

[waldo kitty <wkitty42 () windstream net>]

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!