By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,824 Members | 2,410 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,824 IT Pros & Developers. It's quick & easy.

Lock_tables_priv

P: n/a
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.
Jul 8 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Marcus wrote:
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.
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
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Jul 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.