[Snort-users] DataBase Load Problem.

Ryan Russell 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.

http://www.mysql.com/documentation/mysql/bychapter/manual_Performance.html#Internal_locking


						Ryan




More information about the Snort-users mailing list