Web lists-archives.com

Re: Global read lock on delete




Artem -

> |THREAD_ID       LOCK_MODE       LOCK_DURATION   LOCK_TYPE TABLE_SCHEMA
> TABLE_NAME
> 268871  MDL_INTENTION_EXCLUSIVE MDL_EXPLICIT    Global read lock
> 270022  MDL_INTENTION_EXCLUSIVE MDL_STATEMENT   Global read lock
> 268871  MDL_SHARED_NO_READ_WRITE        MDL_EXPLICIT    Table metadata lock
> spru    searchsobjects
> 268871  MDL_SHARED_NO_READ_WRITE        MDL_EXPLICIT    Table metadata lock
> spru    searches
> 268871  MDL_INTENTION_EXCLUSIVE MDL_EXPLICIT    Schema metadata lock    spru
> 270022  MDL_INTENTION_EXCLUSIVE MDL_TRANSACTION Schema metadata lock    spur

The global read lock is in MDL_INTENTION_EXCLUSIVE mode, as an
intention lock it's not an actual global read lock in effect, but
rather something to prevent another thread to take GRL while
GRL-incompatible statements (DELETE, LOCK TABLES) are still running.

-- 
Laurynas

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql