[Snort-users] DataBase Load Problem.
ryan at ...35...
Thu Nov 30 16:46:17 EST 2000
On Thu, 30 Nov 2000, Jed Pickel wrote:
> > MySQL has to do a table lock on each write at present.
> The database plugin does not use any write locks. The schema was
> designed such that write locks are not necessary.
Applications generally don't control/worry about explicit locking in
SQL. That's supposed to be up to the DB.
> 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.
More information about the Snort-users