Performance Schema rwlock_instances Table

The rwlock_instances table lists all read write lock (rwlock) instances that the Performance Schema sees while the server is executing. A read write is a mechanism for ensuring threads can either share access to common resources, or have exclusive access.

The performance_schema_max_rwlock_instances system variable specifies the maximum number of instrumented rwlock objects.

The rwlock_instances table contains the following columns:

NAMEInstrument name associated with the read write lock
OBJECT_INSTANCE_BEGINAddress in memory of the instrumented lock
WRITE_LOCKED_BY_THREAD_IDTHREAD_ID of the locking thread if locked in write (exclusive) mode, otherwise NULL.
READ_LOCKED_BY_COUNTCount of current read locks held


Comments loading...