[mysqld] performance-schema-instrument=’wait/lock/table/sql/handler=OFF’ 

To control table lock instrumentation state at runtime, update the setup_instruments  table: 

•Enable: 

UPDATE performance_schema.setup_instruments SET ENABLED = ’YES’, TIMED = ’YES’ WHERE NAME = ’wait/lock/table/sql/handler’; 

•Disable: 

UPDATE performance_schema.setup_instruments SET ENABLED = ’NO’, TIMED = ’NO’ WHERE NAME = ’wait/lock/table/sql/handler’; 

The table_handles  table has these columns: 

• OBJECT_TYPE 

The table opened by a table handle. 

• OBJECT_SCHEMA 

The schema that contains the object. 

• OBJECT_NAME 

The name of the instrumented object. 

• OBJECT_INSTANCE_BEGIN 

The table handle address in memory. 

• OWNER_THREAD_ID 

The thread owning the table handle. 

• OWNER_EVENT_ID 

The event which caused the table handle to be opened. 

• INTERNAL_LOCK 

The table lock used at the SQL level. The value is one of READ , READ WITH SHARED LOCKS , READ HIGH PRIORITY , READ NO INSERT , WRITE ALLOW WRITE , WRITE CONCURRENT INSERT , WRITE LOW PRIORITY , or WRITE . For information about these lock types, see the include/thr_lock.h source file. 

• EXTERNAL_LOCK 

The table lock used at the storage engine level. The value is one of READ EXTERNAL  or WRITE EXTERNAL . 

The table_handles  table has these indexes: 

•Primary key on ( OBJECT_INSTANCE_BEGIN ) 

•Index on ( OBJECT_TYPE , OBJECT_SCHEMA , OBJECT_NAME ) 

