How can I improve ACID Performance

[Marty.Bostick () protective com]

I just don't get it.  I have a Compaq Proliant DL-380/G2 with Dual 1.26ghz
CPU's and a Huge RAID 5 Array on Ultra-3 15k/rpm disks.  Why does ACID
still suck wind?

I have tuned the heck out of everything I can think of.  I have reduced the
number of output plugins on Snort, optimized the Mysql tables and still it
sucks wind whenever I need to perform a large delete or select.

I am open to suggestions on improving performance(if it is possible) for my
installation.

Consequently, I am running three Snort instances outputting to three
different databases on the same machine.  My machine tends to remain about
80% idle as far as the CPUs are concerned.

Please help.

Thanks

Marty Bostick
Database Administrator
(205) 423-5079


_______________________________________________
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