|
|
Posted by Jerry Stuckle on 07/08/06 01:29
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.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|