[Snort-users] DataBase Load Problem.

Jed Pickel jed at ...153...
Thu Nov 30 17:47:35 EST 2000


> > Are you referring to
> > some kind of locking MySQL does internally? If so, do you know of a
> > URL that describes that process?
> 
> Every time you write to the DB, it has to lock the whole table.
> 
> http://www.mysql.com/documentation/mysql/bychapter/manual_Performance.html#Internal_locking

If you are referring to locking to prevent concurrency issues with
threads I follow you. The word "lock" has too many meanings in this
discussion so we are confusing each other. Anyway, I'll talk with
Roman to see what more we can do within the database plugin and/or
ACID to get some better performance out of MySQL.

* Jed



More information about the Snort-users mailing list