Re: Question about best hardware

[Jason Haar <Jason.Haar () trimble co nz>]

On Mon, Mar 08, 2004 at 04:20:34PM -0600, Hutchinson, Andrew wrote:
> events of interest when the db approaches 4 millions recs), but I'm
> using Postgresql and not using ACID (I wanted some different
> capabilities, multiple user access levels, etc. so I made muy own
> interface).  MySQL is generally faster than Postgresql though, and
> should be able to handle WAY more than 100K records w/o any problem.

Ah! And there's the rub. I - like most people who refer to this problem -
am really referring to ACID - not "raw" MySQL.

I think the wonderous amount of manipulation that ACID does is where the
bottleneck really is...

> around with it a bit lately.  Perhaps a good way to run down the problem
> would be to turn on slow-query logging (with the --log-slow-queries
> option at MySQL startup), and then run those same queries interactively
> against the db with the EXPLAIN keyword to see what's causing them to be
> slow.  I'd do this, but again I don't currently use MySQL or ACID...

Thanks. I'll give that a try

-- 
Cheers

Jason Haar
Information Security Manager, Trimble Navigation Ltd.
Phone: +64 3 9635 377 Fax: +64 3 9635 417
PGP Fingerprint: 7A2E 0407 C9A6 CAF6 2B9F 8422 C063 5EBB FE1D 66D1


-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
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