|
|
Posted by Marcus on 07/08/06 01:24
After much searching, this is the most info I could find on the
Lock_tables_priv privilege in the mysql system database:
from mysql.com...
The LOCK TABLES privilege enables the use of explicit LOCK TABLES
statements to lock tables for which you have the SELECT privilege. This
includes the use of write locks, which prevents anyone else from reading
the locked table.
My question is does this have any effect on locks in transactions, i.e.
as update locks, etc. used with InnoDB tables? It seems like I should
set this value to 'N' for most of my database users, but I just wanted
to make sure this is talking about something different from transaction
locking as I couldn't find that specific info out. Thanks a bunch.
Navigation:
[Reply to this message]
|