Snort mailing list archives
RE: Mysql
From: "Jeff Dell" <jdell () activeworx com>
Date: Tue, 27 Jul 2004 09:37:58 -0400
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 () lists sourceforge net [mailto:snort-users-admin () lists sourceforge net] On Behalf Of Esler, Joel - Contractor Sent: Tuesday, July 27, 2004 8:54 AM To: snort-users () 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 () 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 ------------------------------------------------------- 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=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
Current thread:
- Mysql Esler, Joel - Contractor (Jul 27)
- RE: Mysql Jeff Dell (Jul 27)