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.
From: snort-users-admin at lists.sourceforge.net
[mailto:snort-users-admin at lists.sourceforge.net] On Behalf Of Esler, Joel -
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?
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.
Snort-users mailing list
Snort-users at lists.sourceforge.net
Go to this URL to change user options or unsubscribe:
Snort-users list archive:
More information about the Snort-users