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
