RE: How can I improve ACID Performance

["Reeves, Michael (GEAE, Compaq)" <michael.reeves () ae ge com>]

http://www.mysql.com/doc/S/e/Server_parameters.html

I have similar issues.. mine are attributed though to over a million
records. I did see a big jump in performace when I tweaked the database
memory usage.

Mike



-----Original Message-----
From: Marty.Bostick () protective com [mailto:Marty.Bostick () protective com]
Sent: Wednesday, October 10, 2001 9:56 AM
To: snort-users () lists sourceforge net
Subject: [Snort-users] How can I improve ACID Performance


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

_______________________________________________
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