Do you have a question? Post it now! No Registration Necessary. Now with pictures!
July 8, 2006, 1:24 am
rate this thread
Lock_tables_priv privilege in the mysql system database:
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.
You are correct - you generally want that set to 'N'. It specifically
addresses the LOCK TABLES command, and has no effect on internal locks
generated by MySQL or INNODB.
Remove the "x" from my email address
JDS Computer Training Corp.
- » ssh on command line: force using a group size (prime size) of 1024 (and no...
- — The site's Newest Thread. Posted in » Secure Shell Forum