mailing list archives
Re: Snort populates Mysql a lot
From: "evilghost () packetmail net" <evilghost () packetmail net>
Date: Thu, 23 Dec 2010 09:54:13 -0600
-----BEGIN PGP SIGNED MESSAGE-----
On Dec 23, 2010, at 10:04 AM, J. L. Cabral wrote:
Dear, Snort 2.9 is working fine, but I have a problem: in 3 days I get more than 1.000.000 alerts visualizated in
BASE, and so the access to this web interafce is very slowly.
I had to delete all the data from the mysql tables and start Snort again.
Can you give me any advice to get the alerts without affect the performance of the system ???
And how many alerts approximately can MySQL stores without crash ???
There are some performance and memory adjustments you can make to MySQL to
enhance the performance of MySQLd. Such examples would include enabling caches,
indices's, and disabling unused storage engines.
I have several tables which commonly see about 1.000.000 rows of data or more daily.
If you're not familiar with performance adjustments to MySQL may I suggest a
Perl script, available at http://mysqltuner.pl/mysqltuner.pl as a very good
starting point to asses some adjustments you can make to increase performance.
The root issue could be three key items:
1) MySQL box isn't strong enough to handle the query load.
2) MySQL needs some performance tuning and adjustments.
3) Superfluous alerts need to be disabled or removed (as Joel indicated)
I hope this was helpful.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
-----END PGP SIGNATURE-----
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
Snort-users list archive: