Performance Schema Lock Tables [mysqld] performance-schema-instrument=’wait/lock/table/sql/handler=OFF’ UPDATE performance_schema.setup_instruments SET ENABLED = ’YES’, TIMED = ’YES’ WHERE NAME = ’wait/lock/table/sql/handler’; UPDATE performance_schema.setup_instruments SET ENABLED = ’NO’, TIMED = ’NO’ WHERE NAME = ’wait/lock/table/sql/handler’; 5030 •Index on ( OBJECT_TYPE ,  OBJECT_SCHEMA ,  OBJECT_NAME ) •Primary key on ( OBJECT_INSTANCE_BEGIN ) • EXTERNAL_LOCK • INTERNAL_LOCK • OWNER_EVENT_ID • OWNER_THREAD_ID • OBJECT_INSTANCE_BEGIN • OBJECT_NAME • OBJECT_SCHEMA • OBJECT_TYPE •Disable: •Enable: To control table lock instrumentation state at runtime, update the  setup_instruments  table: The  table_handles  table has these columns: The table opened by a table handle. The schema that contains the object. The name of the instrumented object. The table handle address in memory. The thread owning the table handle. The event which caused the table handle to be opened. 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. 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: