Tuning MySQL
MySQL is the most common database platform used to hold a Snort intrusion database. Although the exact tuning commands will differ for individual databases, the performance tuning concepts are similar for most databases. The default installation and configuration of MySQL is not the most efficient possible. There are some methods of influencing the behavior of MySQL that can result in substantial performance gains if Barnyard is not being used.
One method of increasing performance is to add indexes to some of the tables that Snort uses. Indexes are used to increase the speed at which MySQL returns data. When an index is created, MySQL can skip over lots of data to find exactly the data that is required. Without an index, it must ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access