Re: Backend DB's

[Michael Scheidell <scheidell () secnap net>]

Myisam is faster for reads and write, if properly tuned (see billions of
articles).
Innodb is slower (but is safer)

Due to the way both are built, multiple writers can corrupt myisam.

(We saw issues with this in the mysql based Bayesian DB supported by
SpamAssassin, corruption issues)

Some claim that innodb gets corrupted faster and is harder to recover from.
Again, google.

Mostly, myisam is faster than Innodb.
One tool you might look at is the mysqltuner.pl
http://mysqltuner.com/

YMMV

Ps, we tried innodb on snort/base.. It was slower.
We tried postgresql.. The articles on optimization are not as complete.
Might take you a year to get it to run as fast.
Pps.  Delete old alerts and run mysqlcheck --optimize snort weekly.

-- 
Michael Scheidell, CTO
> |SECNAP Network Security
Winner 2008 Network Products Guide Hot Companies
FreeBSD SpamAssassin Ports maintainer

_________________________________________________________________________
This email has been scanned and certified safe by SpammerTrap(r). 
For Information please see http://www.spammertrap.com
_________________________________________________________________________

-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
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://www.geocrawler.com/redir-sf.php3?list=snort-users