[Snort-users] Mysql

Jeff Dell jdell at ...1095...
Tue Jul 27 06:39:04 EDT 2004


There are a lot of factors that go into a MySQL database getting full.. Some
of them that you might want to consider:

Hardware - Especially memory, It is cheap so max it out.
Software - There are some ways to tweak MySQL so you can get the most
performance from it.
Query - Depending on how your queries are structured this can greatly
slowdown or speed up a query. 

I have been doing a lot of performance testing and I have a few million
events in a MySQL database. Depending on the query it will take anywhere
from .01 second to 10 minutes on a p4 2.4Ghz with 1gig of Ram. I would
suggest tuning your queries and you will be able to get 10+ million events
in the database without too much difficulty and get acceptable response
times on a machine with a little power and memory.

Cheers,

Jeff

-----Original Message-----
From: snort-users-admin at lists.sourceforge.net
[mailto:snort-users-admin at lists.sourceforge.net] On Behalf Of Esler, Joel -
Contractor
Sent: Tuesday, July 27, 2004 8:54 AM
To: snort-users at lists.sourceforge.net
Subject: [Snort-users] Mysql

Has anyone had experience with the mysql database get full?  Is there a
maximum size it can increase to?

J


-------------------------------------------------------
This SF.Net email is sponsored by BEA Weblogic Workshop
FREE Java Enterprise J2EE developer tools!
Get your free copy of BEA WebLogic Workshop 8.1 today.
http://ads.osdn.com/?ad_idG21&alloc_id040&op=ick
_______________________________________________
Snort-users mailing list
Snort-users at 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=ort-users






More information about the Snort-users mailing list