Mysql Performance with snort and demarc/puresecure

["Dave Packham" <dave.packham () utah edu>]

I am using a dual GIG CPU box with 1 GIG of ram with demark/puresecure
and logging about 20k+ events per hour into my snort collector with
MySql.  I have used the my-huge.cnf file to allow MySql to use a ton of
ram.   My question is...  what are some other tweaks that I can use at
the OS or MySql level to get better performance?

Hdparm?
Mysqloptimize?

Can I pre build some lookups during the night etc?

Anything?

Thanks

Dave Packham
U of Utah


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Oh, it's good to be a geek.
http://thinkgeek.com/sf
_______________________________________________
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